Help Please

All was fine with our site, which we had just moved to a new server, when i opened the 'expand templates' section in the vbulletin admin control panel, i was given an error. The direct error was as follows:

<! -- Database error in vBulletin:
Invalid SQL: SELECT template FROM template WHERE title='options'
MySQL error: Got error 127 from table handler.

Now, when we attempt to access any page of the forums, we are given this error:

Warning: MySQL: Unable to save result set in /home/bird/public_html/forums/admin/db_mysql.php on line 93

Can anybody tell us what happened, and how on earth to get it back on track again?

Thanks,
Oliver

[Dean C]

Do you have any hacks installed?

- miSt

[Erwin]

The Lounge is the wrong place to post this. Moving to Support.

[TECK]

Run those queries:
[sql]CHECK TABLE template[/sql]
[sql]REPAIR TABLE template[/sql]That will fix your error 127.
Just to be sure, run repair.php also, included in your vBulletin package.

Also, make sure you have plenty of space on your database before you do those queries.
For example, if you have a 115MB database, you should have an additional 120MB of free space in order to make sure you don't run into problems while checking/repairing.

[eggz]

Thank you TECK that did it.