My modx site comes up this this error... I have no idea what or how I should fix it.... does anyone have any suggestions?
« 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.rank,tv.name ASC’ at line 1 »
SQL: SELECT tv.id,tv.name, IF(tvc.value!=’’,tvc.value,tv.default_text) as value FROM `ryan_ahh`.`ahh_site_tmplvars` tv INNER JOIN `ryan_ahh`.`ahh_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `ryan_ahh`.`ahh_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = ’1’ WHERE tv.id<>0 AND tvtpl.templateid = ORDER BY tv.rank,tv.name ASC
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0019 s (4 Requests)
PHP: 0.0147 s
Total: 0.0166 s
The important thing is not to stop questioning. Curiosity has its own reason for existing. One cannot help but be in awe when he contemplates the mysteries of eternity, of life, of the marvelous structure of reality. It is enough if one tries merely to comprehend a little of this mystery every day. Never lose a holy curiosity.
-Albert Einstein (1879 - 1955)
Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
My apologies...
Web Server:
* PHP version and how it’s running (suexec, mod_php, CGI, etc.) ??
* Apache or IIS version Apache Don’t know version
* Operating System and version Unix
Database:
* MySQL version 5.0
* List of any tables over 1MB in size None
MODx:
* Version 0.9.6.3
* Any changes you’ve made Stock instal
* Any snippets you’re running on the page that is not working properly No snippets
* Any plugins you’re running MaxiGallery, and the ones that were installed with modx.
Browser/Client:
* Browser name and version Firefox 3.0.12
* Operating System and version Windows XP Pro SP3
The important thing is not to stop questioning. Curiosity has its own reason for existing. One cannot help but be in awe when he contemplates the mysteries of eternity, of life, of the marvelous structure of reality. It is enough if one tries merely to comprehend a little of this mystery every day. Never lose a holy curiosity.
-Albert Einstein (1879 - 1955)
Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
This may be a maxigallery problem, it looks a bit like this
http://modxcms.com/forums/index.php?topic=21786.0. If your using search the forums for maxigallery there may be a fix/workround for it.
Use MODx, or the cat gets it!
MODX Staff
