Ditto error sql

« Evo Parse Error »

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 ‘orderBy=menuindex ASC’ at line 1

SQL > SELECT DISTINCT,sc.published,sc.isfolder,sc.createdon FROM bd_sait.modx_site_content sc LEFT JOIN bd_sait.modx_document_groups dg on WHERE IN (11,12,13,14,15,359) AND sc.published=1 AND sc.deleted=0 AND sc.privateweb=0 GROUP BY,sc.published,sc.isfolder,sc.createdon ORDER BY sc.createdon DESC LIMIT 3orderBy=menuindex ASC

1 Like

MODX Evolution is not longer supported here. Please go to or (you need an invitation there) to get support.


It looks like some ditto parameter issue, since the query contains LIMIT 3 `orderBy=` menuindex ASC.

i thought that too. Thanks for the reply mcdvoice

1 Like