I’m getting the following error when loading pages on Modx Evo 1.0.4, noticing that the tvc.contentid and also the tvtpl.templateid are empty or not present in the select statement. What would be causing this type of error?
« 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 `iaopc_cms_modx`.`modx_site_tmplvars` tv INNER JOIN `iaopc_cms_modx`.`modx_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `iaopc_cms_modx`.`modx_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = '' WHERE tv.name IN ('encryption') AND tvtpl.templateid =
Looks like a prior developer had some issues with upgrading versions so issues with version and the install were causing the issue. Once I ran the install the the last know working version the errors all went away.
cheers
Evo Revo // Ubuntu, CentOS, Win // Apache 2x, Lighttp (Lighty)
Visit
CharlesMx.com for latest news and status updates.
☆ A M B ☆