I have absolutely no idea what is causing this, but Ditto seems to be randomly broken on my site.
Here is the error I'm getting:
« 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 '
Parse error: syntax error, unexpected T_VARIABLE in /Volumes/L' at line 1 »
SQL: SELECT DISTINCT sc.id, sc.menutitle, sc.pagetitle, sc.introtext, sc.menuindex, sc.published, sc.hidemenu, sc.parent, sc.isfolder, sc.description, sc.alias, sc.longtitle, sc.type,if(sc.type='reference',sc.content,'') as content, sc.template, sc.link_attributes FROM `prefix`.`prefix_site_content` sc LEFT JOIN `prefix`.`prefix_document_groups` dg ON dg.document = sc.id WHERE sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) AND sc.hidemenu=0 AND sc.id IN (
Parse error: syntax error, unexpected T_VARIABLE in /.../document.parser.class.inc.php(814) : eval()'d code on line 46
) GROUP BY sc.id ORDER BY sc.menuindex ASC ;
I'm using ModX Evolution 1.0.6 and Ditto 2.1.
I can't really think of any changes that have happened recently other than a custom built AJAX Search that exists only on one page. However, I doubt this is the problem as I had tested it on the site a few times and there weren't problems then.
Thanks for your help!
Edit: MySQL version 5.1.40
[ed. note: bartleby last edited this post 14 years, 1 month ago.]
