We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 14947
    • 2 Posts
    Hi All, My webguy is on vacation and I cant reach him. When I attempt to access our site I receive the error below. I have access to al; files but I know nothing about modx. Could someone please direct me to the appopriate document or file with a plain english fix..preferably cut and past?

    I’ve posted all the site info below per an earlier post - Thank You

    PHP Version 5.2.12
    sERVER api CGI
    aPACHI
    Linux 2.6.33.3
    MySQL - 5.0.83
    phpMyAdmin - 2.8.0.1
    MODx version 0.9.6.1p2
    Version codename rev 3281
    Parser 23-Aug-2010 11:04 AM 0

    Error Log
    « MODx Parse Error »
    MODx encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’’ at line 1 »
    SQL: SELECT tv.*, IF(tvc.value!=’’,tvc.value,tv.default_text) as value FROM `interalia_modx`.`modx_site_tmplvars` tv INNER JOIN `interalia_modx`.`modx_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `interalia_modx`.`modx_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = ’65’ WHERE tv.name IN (’access_level’) AND tvtpl.templateid =
    [Copy SQL to ClipBoard]

    Parser timing
    MySQL: 0.0059 s (0 Requests)
    PHP: 0.2723 s
    Total: 0.2782 s
      • 14947
      • 2 Posts
      Thanks Susan for repying..I gave up too soon. I found the problem in the modx configuration settings..We had just moved servers and he forgot to change the File Manager Path to reflect the new server settngs....

      nothing to this web stuff wink
        • 28042 ☆ A M B ☆
        • 24,524 Posts
        Well, after reading your post again I saw that you were a very good boy and gave us all the information we could possibly need grin I’m glad you figured it out. It is really mostly just common sense, with a small amount of internal knowledge necessary. And question #1 of any troubleshooting process is "what got changed recently?" since that’s most likely where the trouble is.
          Studying MODX in the desert - http://sottwell.com
          Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
          Join the Slack Community - http://modx.org