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
-
☆ 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

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.