Fixing errored database

[Luke]

Any idea on fixing this?

CREATE  TABLE post(
postid int( 10  )  unsigned NOT  NULL  AUTO_INCREMENT ,
threadid int( 10  )  unsigned NOT  NULL ,
parentid int( 10  )  unsigned NOT  NULL ,
username varchar( 100  )  NOT  NULL ,
userid int( 10  )  unsigned NOT  NULL ,
title varchar( 250  )  NOT  NULL ,
dateline int( 10  )  unsigned NOT  NULL ,
pagetext mediumtext,
allowsmilie smallint( 6  )  NOT  NULL ,
showsignature smallint( 6  )  NOT  NULL ,
ipaddress varchar( 15  )  NOT  NULL ,
iconid smallint( 5  )  unsigned NOT  NULL ,
visible smallint( 6  )  NOT  NULL ,
attach smallint( 5  )  unsigned NOT  NULL ,
infraction smallint( 5  )  unsigned NOT  NULL ,
reportthreadid int( 10  )  unsigned NOT  NULL ,
importthreadid bigint( 20  )  NOT  NULL ,
importpostid bigint( 20  )  NOT  NULL ,
post_thanks_amount int( 10  )  unsigned NOT  NULL ,
 PRIMARY  KEY ( postid ) ,
 KEY userid( userid ) ,
 KEY threadid( threadid, userid ) ,
 KEY importpost_index( importpostid ) ,
 KEY dateline( dateline ) ,
 KEY dateline_2( dateline ) ,
 KEY dateline_3( dateline ) ,
 KEY dateline_4( dateline ) ,
 KEY title( title, pagetext ) 
);

          MySQL said:
  #1170 - BLOB/TEXT column 'pagetext' used in key specification without a key length 

Luke Reviewed by Luke on 23rd Jun 2009. Fixing errored database Any idea on fixing this? CREATE TABLE post( postid int( 10 ) unsigned NOT NULL AUTO_INCREMENT , threadid int( 10 ) unsigned NOT NULL , parentid int( 10 ) unsigned NOT NULL , username varchar( 100 ) NOT NULL , userid int( 10 ) unsigned NOT NULL , title varchar( 250 ) NOT NULL , dateline int( 10 ) unsigned NOT NULL , Rating: 5

[Sp32]

I found this, dunno if its any help though:

http://bugs.mysql.com/bug.php?id=13545

[Luke]

Didnt shed much light @ Sp32

Im gonig to try:

pagetext mediumtext, (250)