MyBB Community Forums

Please help

SQL query:

CREATE TABLE mybb_posts(
pid int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
tid int( 10 ) unsigned DEFAULT '0' NOT NULL ,
replyto int( 10 ) unsigned DEFAULT '0' NOT NULL ,
fid smallint( 5 ) unsigned DEFAULT '0' NOT NULL ,
subject varchar( 120 ) NOT NULL ,
icon smallint( 5 ) unsigned DEFAULT '0' NOT NULL ,
uid int( 10 ) unsigned DEFAULT '0' NOT NULL ,
username varchar( 80 ) NOT NULL ,
dateline bigint( 30 ) DEFAULT '0' NOT NULL ,
message text NOT NULL ,
ipaddress varchar( 30 ) NOT NULL ,
includesig char( 3 ) NOT NULL ,
smilieoff char( 3 ) NOT NULL ,
edituid int( 10 ) unsigned DEFAULT '0' NOT NULL ,
edittime int( 10 ) DEFAULT '0' NOT NULL ,
visible int( 1 ) DEFAULT '0' NOT NULL ,
posthash varchar( 32 ) NOT NULL ,
PRIMARY KEY ( pid ) ,
KEY tid( tid, uid ) ,
KEY uid( uid ) ,
KEY dateline( dateline ) ,
KEY message( message )
)

MySQL said: Documentation
#1170 - BLOB column 'message' used in key specification without a key length

This will be fixed in the 1.2.2 update tomorrow

I fix it i believe.

Tikitiki Wrote:This will be fixed in the 1.2.2 update tomorrow

We did?
Column Indexes.
I believe you could get this problem with a backup. I don't believe you should get this problem when using the MyBB installer however.

If you got it from the installer, what did you do?