MyBB Community Forums

I am struggling to upgrade from 1.15 to 1.23, and i can get the upgrade to run, but then I get errors all over the board, the latest is

MySQL error: 1030
Got error 127 from table handler
Query: SELECT uid, username FROM mybb_users ORDER BY uid DESC LIMIT 1

EDIT: now I get this on entry to the board

MySQL error: 1054
Unknown column 'newpms' in 'field list'
Query: UPDATE mybb_users SET newpms='0' WHERE uid='2' MySQL error: 1030
Got error 134 from table handler
Query: UPDATE mybb_users SET lastvisit='1172290297', lastactive='1172291433' WHERE uid='2'

apparently the upgrade damaged my database, but i am no programmer, any suggestions would be appreciated
thanks
Dave

This appears to be a bug with certain Versions of MySQL (http://forums.mysql.com/read.php?88,2725...#msg-35249) Running the REPAIR TABLE command in PHPMyAdmin seems to fix this temporarily from what I've read so far.

Edit, check this out: http://forums.mysql.com/read.php?88,2725...#msg-77624

Quote:I found one article about this problem.

But it is in Chinese.
[hanliu.kxup.com]

It seems that there is some limitation about data file.

So improve the limitation will be helpful.

Execute the following sql:

ALTER TABLE cdb_posts MAX_ROWS=100000000 AVG_ROW_LENGTH=15000;

You can adjust the MAX_ROWS to a little smaller.
Because it costs much time to change a large data file.

This only appears to be a problem on forums with a large amount of data.