Community

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.id,sc.published,sc.isfolder,sc.createdon FROM bd_sait.modx_site_content sc LEFT JOIN bd_sait.modx_document_groups dg on dg.document=sc.id WHERE sc.id IN (11,12,13,14,15,359) AND sc.published=1 AND sc.deleted=0 AND sc.privateweb=0 GROUP BY sc.id,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 https://github.com/evolution-cms/evolution/issues or https://evocmf.slack.com/ (you need an invitation there) to get support.

2 Likes

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