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:
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 )
)
