First off, I’ve searched a bit, and I wanted to pin this at the MySQL version, but I tied a second host just now, on Rackspace Cloud, we’ve had no trouble with other 1.0.3 sites. Any ideas?
« 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 'menuindex' at line 4 »
SQL: SELECT DISTINCT sc.id,sc.introtext,sc.published,sc.pagetitle FROM `358650_pinetech`.`saw_site_content` sc LEFT JOIN `358650_pinetech`.`saw_document_groups` dg on dg.document = sc.id WHERE sc.id IN (96,97,98) AND sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) GROUP BY sc.id ORDER BY sc.createdon ASC, sc.id menuindex
[Copy SQL to ClipBoard]
Parser timing
MySQL: 1.8214 s (21 Requests)
PHP: 0.3777 s
Total: 2.1991 s
Ran Query from phpMyAdmin
http://grab.by/4xGW
