We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 23702
    • 6 Posts
    ponscreative.com Reply #1, 16 years ago
    Hi Guys,

    I am currently desperate to fix this issue which is causing my site to be down.

    [2010-10-20 04:53:00] (ERROR @ /connectors/security/user.php) Error HY000 executing statement:

    Array
    (
    [0] => HY000
    [1] => 145
    [2] => Table ’./db4112_modx/modx_site_content’ is marked as crashed and should be repaired
    )

    I have tried to repair the db from the myPHP admin, but it will not work. That table is currently marked as In Use and it isn’t responding to any of the tools provided by myPHP admin. Our site is currently in development and were literally QA’ing the very last resource sad The error above is the very last one on our log report. The issues began when I started to get this error:

    [2010-10-19 17:56:27] (ERROR @ /connectors/resource/index.php) Error HY000 executing statement:
    UPDATE `modx_site_content` SET `content` = ’Hundreds of Merchants rely on Comodo\’s Scanning application to become PCI compliant. We made the process painless by designing an intuitive interface that puts the user in control of the compliance process.
    ’,`editedon` = ’1287536187’ WHERE `id` = ’39’ LIMIT 1
    Array
    (
    [0] => HY000
    [1] => 126
    [2] => Incorrect key file for table ’./db4112_modx/modx_site_content.MYI’; try to repair it
    )

    We were in the middle of fixing the very last typo when the resource began to give a save error, then an error saying it could not recognize the parent ID and ultimately the crash. Any recommendations? we were hoping to launch today, but now we are SOL. PLEASE HELP!!!!
      • 26903
      • 1,336 Posts
      Drop into the MYSQL console and try a repair from the command line, it may give you more info on what’s going on than phpmyadmin will, from the MYSQL ref http://dev.mysql.com/doc/refman/5.0/en/repair-table.html
        Use MODx, or the cat gets it!
        • 23702
        • 6 Posts
        ponscreative.com Reply #3, 16 years ago
        Thanks for the reply Shamblett,

        I had a buddy troubleshoot the issue. However I think there are several posts about this so I will pass you words of wisdom on.

        Cheers!