Hi all, I have problem with this module. It appears on some websites with this module. When I open this module and save wuthout making any changes I get this info on frontend:
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 'DESC LIMIT 0,1' AT LINE 21 SQL=SELECT CONTENT.ID AS IID FROM #__CONTENT AS CONTENT LEFT JOIN #__CONTENTITEM_TAG_MAP AS TAG_MAP ON CONTENT.ID = TAG_MAP.CONTENT_ITEM_ID LEFT JOIN #__TAGS AS TAG ON TAG.ID = TAG_MAP.TAG_ID WHERE CONTENT.STATE = 1 AND CONTENT.ACCESS IN (1,1) AND ( CONTENT.PUBLISH_UP = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_UP <= '2016-07-18 13:09:33' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2016-07-18 13:09:33' ) AND ( TAG.ID = 19 ) AND CONTENT.LANGUAGE IN ('EN-GB','*') ORDER BY CONTENT. DESC LIMIT 0,1; IT APPEARS THE PAGE YOU WERE LOOKING FOR DOESN'T EXIST. SORRY ABOUT THAT.
I don't change any date of publication of articles..
Coud you help me? I have any idea..
Tue Jul 19, 2016 6:39 am
Solution: reinstall module.
Fri Jul 22, 2016 10:42 am
From the error message I can see order option was not selected. I believe all it needed was to re-save configuration.
• Page 1 of 1
Please post all new support queries in our New Forum.