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:

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

I've had a similar problem in trying to restore backups before. As the problem is something to do with creating tables, what I did was to i) remove the drop/create table statements from my backup, ii) reinstall the module (which creates the tables properly from the module's original sql file) and then iii) restore the backup (now data only) into the clean tables.

Good luck :)