OK, I have been asked to help a site admin out with this error and I am really not sure what I need to do...
I do not know all of the details but they were trying to do an upgrade and obviously their phrase table got corrupted.
The error is all kinds of pages and it is formated like this:
I have tried to go into the AdminCP >> Repair / Optimize Tables tool and that did not solve the issue. The tool does indicate that the table is corrupted and needs to be rebuilt and teh size is reported to be 0kb.
I also tried going into AdminCP >> Languages & Phrases >> Rebuild All Languages and that did not help....
I also tried using MyPHPAdmin to run the Repair directly
Can I get another idea on how the phrase table can be rebuilt? Should I advise the Site Admin to download the latest 3.6.x version and run the upgrade script to rebuild their languages and phrases tabes? That is my logical guess but this is the first time I have seen this error so I am looking for advise first!
I do not know all of the details but they were trying to do an upgrade and obviously their phrase table got corrupted.
The error is all kinds of pages and it is formated like this:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT COUNT(*) AS total
FROM phrase AS phrase
WHERE languageid IN(-1, 0)
AND fieldname = 'global';
MySQL Error : Table './XXXXX/phrase' is marked as crashed and should be repaired
Error Number : 145
Date : Thursday, February 7th 2008 @ 01:27:00 PM
Script : http://www.XXXXX.com/forums/admincp/...eldname=global
Referrer : http://www.XXXXX.com/forums/admincp/index.php?do=nav
IP Address : XXXXXXXXXX
Username : XXXXXXXXXX
Classname : vB_Database
Invalid SQL:
SELECT COUNT(*) AS total
FROM phrase AS phrase
WHERE languageid IN(-1, 0)
AND fieldname = 'global';
MySQL Error : Table './XXXXX/phrase' is marked as crashed and should be repaired
Error Number : 145
Date : Thursday, February 7th 2008 @ 01:27:00 PM
Script : http://www.XXXXX.com/forums/admincp/...eldname=global
Referrer : http://www.XXXXX.com/forums/admincp/index.php?do=nav
IP Address : XXXXXXXXXX
Username : XXXXXXXXXX
Classname : vB_Database
I also tried going into AdminCP >> Languages & Phrases >> Rebuild All Languages and that did not help....
I also tried using MyPHPAdmin to run the Repair directly
Can I get another idea on how the phrase table can be rebuilt? Should I advise the Site Admin to download the latest 3.6.x version and run the upgrade script to rebuild their languages and phrases tabes? That is my logical guess but this is the first time I have seen this error so I am looking for advise first!
Comment