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,6' at line 21

When attempting to use the Gavick News Show Pro GK5 module in conjunction with their News template.

I've used the Quickstart package on my internal development server and installed K2 so that I can use its features.
If I edit any one of the instances of the News Show Pro GK5 modules and save the settings, and reload the home page, I get the following 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,6' at line 21
I've determined that if I go directly to the database and edit the params field and add "news_sort_value":"created" and save the change, the home page displays correctly.
When I am on the Data Source tab for the module, the News Order drop-down list is always empty which I'm assuming is the source of the problem.

You have no rights to post comments

Recent Random Insights