I am building new website (Kallays template from Hogash) and just after installing News Show Pro GK5 i get famous 1064 error:
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,12' at line 21 SQL=SELECT content.id AS iid FROM j33_content AS content WHERE content.state = 1 AND content.access IN (1,1) AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2015-08-05 11:57:55' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-08-05 11:57:55' ) ORDER BY content. DESC LIMIT 0,12;
I have tried clearing cache, changing browser, changing article source as well as steps proposed on the forum:
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
Nothing seems to work for me.
The module is crashed at the backend as well: configration tabs ar displayed at the top, not on the left and there is a lot of additional code displayed i.e.:
{ "data_source": "JOOMLA_CONTENT_TITLE", "source": "com_content", "tab": "Joomla_Content_Additional_Settings", "tabj3" : "NSP_DATA_SOURCE_COM_CONTENT", "sources": [ { "name": "ALL_COM_CONTENT_ARTICLES", "value": "com_content_all" }, { "name": "COM_CONTENT_ARTICLES", "value": "com_content_articles" }, { "name": "COM_CONTENT_CATEGORIES", "value": "com_content_categories" }, { "name": "COM_CONTENT_TAGS", "value": "com_content_tags" } ], "supported_options": { "sort_values": { "Według daty": "created", "Według daty publikacji": "publish_up", "Według daty odpublikowania": "publish_down", "Według daty modyfikacji":...
What else can I do?
Thank you in advance for any help.
Dominik