[Forum] Error: Table upgrade required.

[tiengnhat]

When i "Repair / Optimize Tables", some erro has happened.
Can you tell me abou fix it?
overhead: 86.00 MB

     [B]Error[/B]: Table upgrade required.  Please do "REPAIR TABLE `tag`" or dump/reload to fix it!
tagcontent     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead

contenttype     Check     Status: OK       contenttype     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead       contenttype     Optimize     Status: OK       fbb_invited     Check     Status: OK       fbb_invited     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead       fbb_invited     Optimize     Status: OK       fbb_log     Check     Status: OK       fbb_log     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead       fbb_log     Optimize     Status: OK       searchcore     Check     Status: OK       searchcore     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead       searchcore     Optimize     Status: OK       searchgroup     Check     Status: OK       searchgroup     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead       searchgroup     Optimize     Status: OK       searchlog     Check     Status: OK       searchlog     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead       searchlog     Optimize     Status: OK       tag     Check     [B]Error[/B]: Table upgrade required.  Please do "REPAIR TABLE `tag`" or dump/reload to fix it!       tag           
      tagcontent     Check     Status: OK       tagcontent     Optimize     Note: Table does not support optimize,  doing recreate + analyze instead       tagcontent     Optimize     Status: OK

[snakes1100]

Did you recently upgrade SQL?

Not sure if you have root access to the server or not, if you do NOT, open phpmyadmin and run this cmd:

mysql_upgrade;

If you do, you can run this via the cmd line:

mysqlcheck --check-upgrade --all-databases --auto-repair

This could also be another issue, just report back if the above two correct the issue or not.

[tiengnhat]

Did you recently upgrade SQL?

Not sure if you have root access to the server or not, if you do NOT, open phpmyadmin and run this cmd:

mysql_upgrade;

If you do, you can run this via the cmd line:

[COLOR=red][B]mysqlcheck --check-upgrade --all-databases --auto-repair[/B][/COLOR]

This could also be another issue, just report back if the above two correct the issue or not.

Thank you for help me.
But when i run "mysqlcheck --check-upgrade --all-databases --auto-repair " from SSH, some error has happened.

[[email protected]~]# mysqlcheck --check-upgrade --all-databases --auto-repair
 
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using pa
ssword: NO) when trying to connect

Can you help me for fix it?
Thank you for your support!

[tiengnhat]

Anyone can help me for fix it?
Can you see this picture.

[tiengnhat]

Anyone can help me for fix it?
Can you see this picture.

anyone help me for fix this error. Overhead is too big for some day.
How can i fix it?
(see picture plz)
thanks you!

[Trevor Hannant]

Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP, then you can use phpMyAdmin to repair tables.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

You may have to ask your host to try and repair this for you.