We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 22770
    • 285 Posts
    I’m getting the following error on several pages on one of my websites:

    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - Got error 127 from table handler »
          SQL: SELECT tv.*, IF(tvc.value!='',tvc.value,tv.default_text) as value FROM `lawdb`.`modx_site_tmplvars` tv INNER JOIN `lawdb`.`modx_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `lawdb`.`modx_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = '90' WHERE tvtpl.templateid = '14' 


    I’ve had several database problems on other websites run by the same host on the same server, where database tables had become corrupted, but I’ve looked through the tables on this website and they all seem to be there. When I’ve looked through the content, it seems to be there also (although it’s a big site, so I haven’t been able to check every entry in every table.)

    Is this error also a database problem, and if so, what does it mean?

    Thanks!
      • 10487 MODX Staff
      • 1,535 Posts
      It’s another indicator that one of the tables being accessed in that query is corrupt and needs repairing.
        Garry Nutting
        Senior Developer
        MODX, LLC

        Email: [email protected]
        Twitter: @garryn
        Web: modx.com
        • 22770
        • 285 Posts
        Okay, as I can’t track down which table, I guess I’ll have to ask the host to restore the whole thing from a back-up.

        I am so unimpressed by this hosting right now... >:(

        Thanks.
          • 3749
          • 24,544 Posts
          Quote from: PatrickSamphire at Apr 29, 2009, 06:18 AM

          Okay, as I can’t track down which table, I guess I’ll have to ask the host to restore the whole thing from a back-up.

          I am so unimpressed by this hosting right now... >:(

          Thanks.

          Before doing that, it’s probably worth going into phpMyAdmin and doing a "repair" yourself.
            Did I help you? Buy me a beer
            Get my Book: MODX:The Official Guide
            MODX info for everyone: http://bobsguides.com/modx.html
            My MODX Extras
            Bob's Guides is now hosted at A2 MODX Hosting