After having to reinstall my websites after having been hacked, part of my site that uses a Ditto call now doesn’t work and keeps giving me the following 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 ’pagetitle’ at line 4 »
SQL: SELECT DISTINCT sc.id,sc.published FROM `fiveep_coolactivmain`.`modx_site_content` sc LEFT JOIN `fiveep_coolactivmain`.`modx_document_groups` dg on dg.document = sc.id WHERE sc.id IN (2,3,4,7,8,9,10,11,12,13,14,15,16,17,18,19,20,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,54,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,86,215,219,220,245,303) AND sc.published=1 AND sc.deleted=0 AND (sc.privateweb=0) GROUP BY sc.id ORDER BY sc.id pagetitle
[Copy SQL to ClipBoard]
My Ditto call is as follows
[[Ditto?parents=`21`&depth=`2` &tpl=`DittoCats` &paginate=`1` &sortBy=`pagetitle` sortDir=`asc` &summarize=`6` &filter=`DittoSort,Land,7`]]
I find it really strange because all my other Ditto calls on the site, some of which use the same type of syntax, all work perfectly.
The page in question is
http://www.coolactiv.com/ from there click on either the Land, Air or Water icons, or the alphabet letters. Strangely some of the alphabet letters work. For example G.
All of those Alphabet letters are created from the Ditto call. The page titles are A, B,C, D etc and ditto lists them as such. So I can’t understand why it isn’t working.
