Hi everyone,
I have followed the instructions on how to install MaxiGallery snippet one by one. Unfortunately, when I click the
button Manage Photos I get the following error. By the way, I get the same error sometimes when I am logged in as manager and,
while I am in the process of editing a file, I want to preview the page.
Could you help?
« 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 ’ORDER BY tv.name ASC’ at line 1 »
SQL: SELECT tv.id,tv.name, IF(tvc.value!=’’,tvc.value,tv.default_text) as value FROM `smartdogs`.`smrt_pref_site_tmplvars` tv INNER JOIN `smartdogs`.`smrt_pref_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `smartdogs`.`smrt_pref_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = ’2’ WHERE tv.id<>0 AND tvtpl.templateid = ORDER BY tv.name ASC
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0067 s (6 Requests)
PHP: 0.1264 s
Total: 0.1330 s
