News show pro GK5

GK User
Thu Mar 05, 2015 5:51 am
I tried to change the title in the News show pro GK5 module, which was titled Speakers, on the front page and after I saved I got the following error on the homepage:

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,8' AT LINE 21 SQL=SELECT CONTENT.ID AS ID FROM MS741_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 22:45:19' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2015-03-04 22:45:19' ) AND ( CONTENT.CATID = 33 ) ORDER BY CONTENT. DESC LIMIT 0,8;
It appears the page you were looking for doesn't exist. Sorry about that.

I am unable to get the module to work. Can you please assist?

Thanks.
User avatar
Senior Boarder

GK User
Thu Mar 05, 2015 7:12 am
Probably your data source doesn't exist. Please check that first.
If that will not help, please try:
Code: Select all
0) Install new current version of NSP GK5 (re-install)
1) Open module in edit mode
2) Click Refresh button in your browser
3) Change data source to another from list
4) Change order of showing items
5) Save changes - check on front page
6) If okey, change data source back to option which you have at the beginning
User avatar
Moderator

GK User
Mon Mar 09, 2015 6:19 am
Thanks. That fixed the problem. Really appreciate your help.
User avatar
Senior Boarder

GK User
Mon Mar 09, 2015 7:16 pm
Please let me know if you would have any additional questions regarding this topic.
User avatar
Moderator


cron