1064 Error

GK User
Wed Mar 04, 2015 1:37 am
Hi There,

I went and unpublished the html type module in position "bottom 3" and received the follwoing error at the front end. I cannot get around it. Tried re-publishing module, clearing out cache. I have not deleted anything as I am working with the demo data of the quick install. Please let me know if you can think what it might be.

YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MARIADB SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR 'DESC LIMIT 0,3' AT LINE 21 SQL=SELECT CONTENT.ID AS ID FROM V1UOD_K2_ITEMS AS CONTENT WHERE CONTENT.PUBLISHED = 1 AND CONTENT.TRASH = 0 AND CONTENT.ACCESS IN (1,1) AND ( CONTENT.PUBLISH_UP = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_UP <= '2015-03-04 00:28:44' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2015-03-04 00:28:44' ) AND ( CONTENT.CATID = 27 ) ORDER BY CONTENT. DESC LIMIT 0,3;
User avatar
Fresh Boarder

GK User
Wed Mar 04, 2015 12:16 pm
Hello,

As it was described in many other topics:

1) Upgrade the NSP GK5 module to the newest version - 1.8.0.6
2) Clear your browser cache or use other browser
3) Please go to the module back-end, wait till UI will fully loaded and click "Save & Close" button
User avatar
Administrator


cron