error 1064
Support forum dedicated to free and advanced Joomla content presentation module with various layout options and data sources support.
- GK User
- Mon Jul 18, 2016 12:25 pm
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:
1064
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..
Greetings
Krzysztof
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:
1064
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..
Greetings
Krzysztof
-
- Fresh Boarder
- GK User
- Tue Jul 19, 2016 6:39 am
Solution: reinstall module.
-
- Fresh Boarder
- teitbite
- Fri Jul 22, 2016 10:42 am
Hi
From the error message I can see order option was not selected. I believe all it needed was to re-save configuration.
From the error message I can see order option was not selected. I believe all it needed was to re-save configuration.
-
- Moderator
3 posts
• Page 1 of 1