1
I tried updating newbb to newbb2 then decided to go back. I'd made a backup of both the sql database and php before i did anything.
When I tried to restore the sql databases using the backups everything seemed to work very smoothly, occassionally it asked me to drop a table before restoring.
All worked well but..
when it came to xoops_bb_posts_text i got this...
Quote:
Processing file: bkp0604041701_xoops_bb_posts_text.gz
Starting at the line: 1
Error at the line 14: );
Query: CREATE TABLE xoops_bb_posts_text ( post_id int(8) unsigned NOT NULL auto_increment, post_text text, PRIMARY KEY (post_id), KEY search (post_text) );
MySQL: BLOB/TEXT column 'post_text' used in key specification without a key length
Stopped on error
Start from the beginning (DROP the old tables before restarting)
I dropped the table but even once done it still shows the same message when rerun.
Any ideas folks I urgently need a fix?
thanks
Andrew