1
I'm trying to roll back a XOOPS install to 2.13a, but my database backup is generating an error when I try to restore it:
Quote:
#1170 - BLOB column 'hometext' used in key specification without a key length
Can anyone suggest how to fix this? The backup was made with XOOPS Backup and Restore 3.0. MySQL version 4.0.24
Query is below:
le="color: #000000"><?php SQL-query: CREATE TABLE xoops_stories( storyid int( 8 ) unsigned NOT NULL AUTO_INCREMENT , uid int( 5 ) unsigned DEFAULT '0' NOT NULL , title varchar( 255 ) NOT NULL , created int( 10 ) unsigned DEFAULT '0' NOT NULL , published int( 10 ) unsigned DEFAULT '0' NOT NULL , expired int( 10 ) unsigned DEFAULT '0' NOT NULL , hostname varchar( 20 ) NOT NULL , nohtml tinyint( 1 ) DEFAULT '0' NOT NULL , nosmiley tinyint( 1 ) DEFAULT '0' NOT NULL , hometext text NOT NULL , bodytext text NOT NULL , counter int( 8 ) unsigned DEFAULT '0' NOT NULL , topicid smallint( 4 ) unsigned DEFAULT '1' NOT NULL , ihome tinyint( 1 ) DEFAULT '0' NOT NULL , notifypub tinyint( 1 ) DEFAULT '0' NOT NULL , story_type varchar( 5 ) NOT NULL , topicdisplay tinyint( 1 ) DEFAULT '0' NOT NULL , topicalign char( 1 ) DEFAULT 'R' NOT NULL , comments smallint( 5 ) unsigned DEFAULT '0' NOT NULL , rating double( 6, 4 ) DEFAULT '0.0000' NOT NULL , votes int( 11 ) unsigned DEFAULT '0' NOT NULL , keywords varchar( 255 ) NOT NULL , description varchar( 255 ) NOT NULL , PRIMARY KEY ( storyid ) , KEY idxstoriestopic( topicid ) , KEY ihome( ihome ) , KEY uid( uid ) , KEY published_ihome( published, ihome ) , KEY title( title( 40 ) ) , KEY created( created ) , KEY search( title, hometext, bodytext ) )
