xt eCommerce Templates Module SEO Support: GPL Shop: Daten Wiederherstellen

[FOWIN]

Hallo,

musste wegen Serverabsturz den Shop neu installieren, was soweit funktioniert hat.

Aber ich kann das lokal gespeicherte Backup(ca1,8MB) nicht wieder herstellen! :(
Weder vom Shop aus, noch direkt mit myPHPAdmin (Import) Vers.2.7.0-pl2

Fehlermerldung:

SQL-Befehl:

CREATE TABLE content_manager(
content_id int( 11 ) NOT NULL AUTO_INCREMENT ,
categories_id int( 11 ) default '0' NOT NULL ,
parent_id int( 11 ) default '0' NOT NULL ,
group_ids text,
languages_id int( 11 ) default '0' NOT NULL ,
content_title text NOT NULL ,
content_heading text NOT NULL ,
content_text text NOT NULL ,
sort_order int( 4 ) default '0' NOT NULL ,
file_flag int( 1 ) default '0' NOT NULL ,
content_file varchar( 64 ) NOT NULL ,
content_status int( 1 ) default '0' NOT NULL ,
content_group int( 11 ) default '0' NOT NULL ,
content_delete int( 1 ) default '1' NOT NULL ,
PRIMARY KEY ( content_id ) ,
KEY content_heading( content_heading )
);

MySQL meldet: Dokumentation
#1170 - BLOB/TEXT column 'content_heading' used in key specification without a key length

Was kann das sein?

[bluemoon]

um die Tabelle Content Manager einzurnichten habe ich folgenden Befehl :


CREATE TABLE `content_manager` (
**`content_id` int(11) NOT NULL auto_increment,
**`categories_id` int(11) NOT NULL default '0',
**`parent_id` int(11) NOT NULL default '0',
**`group_ids` text,
**`languages_id` int(11) NOT NULL default '0',
**`content_title` text NOT NULL,
**`content_heading` text NOT NULL,
**`content_text` text NOT NULL,
**`sort_order` int(4) NOT NULL default '0',
**`file_flag` int(1) NOT NULL default '0',
**`content_file` varchar(64) NOT NULL default '',
**`content_status` int(1) NOT NULL default '0',
**`content_group` int(11) NOT NULL default '0',
**`content_delete` int(1) NOT NULL default '1',
**PRIMARY KEY**(`content_id`)
) TYPE=MyISAM AUTO_INCREMENT=17;