About getting error 1064

how to solve that problem.
I am facing this problem in home page..

And I also tried to clear cache. but still getting same error..

error:

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 ') ORDER BY content.created DESC LIMIT 0' at line 12 SQL=SELECT content.id AS iid FROM u17a2_content AS content WHERE content.state = 1 AND content.access IN (1,1,5) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-07-16 10:17:05' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-07-16 10:17:05' ) AND ( ) ORDER BY content.created DESC LIMIT 0,12;

Please follow this procedure:

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

It's Work..
Thank you...

After one it's seems like same error.
again on home page getting error:

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,10' at line 21 SQL=SELECT content.id AS id FROM u17a2_k2_items AS content WHERE content.published = 1 AND content.trash = 0 AND content.access IN (1,1,5) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-07-17 04:52:27' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-07-17 04:52:27' ) ORDER BY content. DESC LIMIT 0,10;

@jimmi.prajapati - please repeat these steps for all module instances:

Code: Select all

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

if it won't help - please try to use another browser, because it must be a browser cache issue.

Hi there,
everything was working fine on my site http://www.chcemviac.com, but I wanted to change some settings in one of the news show pro gk5, modules, and after the change, I got the 1064 error page with no content left on a page. The only solution was to switch off the module, and I got everything back (instead of the module). I've tried the things you have mentioned in this discussion, but nothing has worked. Do you have any solution?

@mavievs - did you tried to use different browser? Because it must be an issue with your browser cache if you have upgraded the module.

I have done everything, upgrade the module, tried the list you've posted in this topic, tried different browsers. I can give you access to my page, you can turn it on and try it on your own, if you want.@dziudek

@mavies - please send me a PM, but I'm pretty sure that you still have a browser cache issue. Please wrote ID of the module with the problem in the PM message.

@mavievs - please check your page now I've resaved the module and published it - for me the module back-end is working fine.

thanks, have you done something special? in case this happens in future, what should I do?

I've just resaved the module settings - as I wrote you have some problem with the browser cache.

Do you have any idea how to solve that browser cache issue?

Every browser has a special shortcut to refresh the page without cache - you can also disable it often in the dev tools of a specific browser. Please also try to clear browsing data.