Announcement

Collapse
No announcement yet.

Error: Table upgrade required.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Trevor Hannant
    replied
    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:



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

    Leave a comment:


  • tiengnhat
    replied
    Originally posted by tiengnhat View Post
    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!
    Attached Files

    Leave a comment:


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


    Attached Files

    Leave a comment:


  • tiengnhat
    replied
    Originally posted by snakes1100 View Post
    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:
    Code:
    mysql_upgrade;
    If you do, you can run this via the cmd line:
    Code:
    [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.
    Code:
    [[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!

    Leave a comment:


  • snakes1100
    replied
    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:
    Code:
    mysql_upgrade;
    If you do, you can run this via the cmd line:
    Code:
    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.

    Leave a comment:


  • tiengnhat
    started a topic [Forum] Error: Table upgrade required.

    Error: Table upgrade required.

    When i "Repair / Optimize Tables", some erro has happened.
    Can you tell me abou fix it?
    overhead: 86.00 MB
    Code:
         [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
    Code:
    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X