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
User avatar
Fresh Boarder

GK User
Tue Jul 19, 2016 6:39 am
Solution: reinstall module.
User avatar
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.
User avatar
Moderator


cron
Remember me
Register New Account
If you are old Gavick user, click HERE for steps to retrieve your account.