« 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 'AS UNSIGNED) ASC' 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 `xx`.`modx_site_content` sc LEFT JOIN `xx`.`modx_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 (78,79,80,81)) AND sc.id IN (93,116,115,114,113,110,109,107,118,120,126,91,122,92,124,78,79,108,111,112,119,125,123,117,121,106,105,100,99,98,97,96,95,94,80,102,101,103,104,81,162,163,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212) GROUP BY sc.id ORDER BY sc.CAST(description AS UNSIGNED) ASC ;
Нашла более удобный выход, перед 4хзначными ценами ставлю пробел- пользователи не видят, а сортировка пашет