Installation error

[vapor (Chrisseman)]

[size="4"]Error Table:[/size]

CREATE TABLE IF NOT EXISTS forumtopics

(

id int(10) NOT NULL auto_increment,


title varchar(125) NOT NULL default '',


alias text,


dateposted int(10) NOT NULL default '0',


authorid int(10) NOT NULL default '0',


language char(3) NOT NULL default '',


views int(10) NOT NULL default '0',


replies int(10) NOT NULL default '0',


lastpostdate int(10) NOT NULL default '0',


lastpostauthorid int(10) NOT NULL default '0',


visible tinyint(1) NOT NULL default '0',


content TEXT NULL,


PRIMARY KEY (id),


KEY title (title),


KEY alias (alias),


KEY language (language),


KEY lastpostdate (lastpostdate),


KEY dateposted (dateposted)

) ENGINE = InnoDB;

[size="4"]Phpmyadmin message:[/size]

SQL query:

CREATE TABLE IF NOT EXISTS forumtopics(

id int( 10 ) NOT NULL AUTO_INCREMENT ,

title varchar( 125 ) NOT NULL default ‘’,

alias text,

dateposted int( 10 ) NOT NULL default ‘0’,

authorid int( 10 ) NOT NULL default ‘0’,

languagechar( 3 ) NOT NULL default ‘’,

views int( 10 ) NOT NULL default ‘0’,

replies int( 10 ) NOT NULL default ‘0’,

lastpostdate int( 10 ) NOT NULL default ‘0’,

lastpostauthorid int( 10 ) NOT NULL default ‘0’,

visible tinyint( 1 ) NOT NULL default ‘0’,

content TEXT NULL ,

PRIMARY KEY ( id ) ,

KEY title( title ) ,

KEY alias( alias ) ,

KEY language( language ) ,

KEY lastpostdate( lastpostdate ) ,

KEY dateposted( dateposted )

) ENGINE = InnoDB;

MySQL said: Documentation

#1170 - BLOB/TEXT column ‘alias’ used in key specification without a key length

[size="4"]I tried:[/size]

alias text VARCHAR(50),

It still fails…

Any suggestions?

[Da_Sourcerer]

Umh, that error refers to the KEY on the alias field, not the field itself. Try removing that. Simple keys on a text field aren’t that smart anyway.

[vapor (Chrisseman)]

Crap…this was supposed to be posted into vince’ full featured cms thread hahaha.

I am not familiar with mysql structure, obviously.

Thanks sorcerer! Removing that line worked.