I have just updated my side with latest MOdx 1.0.3 and now get the following:
« 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 ’)) AND sc.id IN (1,2,3,4,5,6,7,8,9,10,11,12,17,16,15,14,13,18,19,20,21) GROUP BY’ 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 `vikingPumps`.`vpl_site_content` sc LEFT JOIN `vikingPumps`.`vpl_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 NOT IN (1,2,3,4,5,6,)) AND sc.id IN (1,2,3,4,5,6,7,8,9,10,11,12,17,16,15,14,13,18,19,20,21) GROUP BY sc.id ORDER BY sc.menuindex ASC ;
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0144 s (4 Requests)
PHP: 0.0400 s
Total: 0.0544 s
I created a complete new ModX installation and get the same?
can anyone advise on this problem
Drew Davidson
