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

  • 07 February 2020
    Warning: session_start(): Failed to read session data: user (path: c:/wamp/tmp) in libraries\joomla\session\handler\native.php on line 260Error: Failed to start application: Failed to start the session Solution: check to make sure $dbprefix in the configuration.php file is set to correctly ma...
  • 12 September 2019
    If you get this message after switching to php version 7.x, change your code to from count() to count(get_object_vars()).
  • 08 August 2019
    Using json_decode in PHP is handing for extracting json parameters from PHP. Similarly, you can use JSON_EXTRACT in an SQL query.   SELECT JSON_EXTRACT(`params`, '$.parent_info_session') FROM `minto_categories` WHERE `id` = 96   Thise selects the data from the parent_info_session par...
  • 09 June 2019
    I you're getting Unable to Connect or ERR_CONNECTION_REFUSED when trying to connect to a site on localhost, check the configuration.php file to see if $force_ssl is set to 2. Change it to 0 and the problem should go away. 
  • 02 May 2018
    You can use array_keys to get the keys from an array but how do you get the keys from elements in an object.  Easiest method is to cast the object to an array and use array_keys. $Keys = array_keys(array)$ObjectName);
  • 04 April 2018
    Assuming the Media Manager is already identifying application/pdf as a valid mime type and it's still not working. log into cPanel Choose "select PHP version" under "software" heading Make sure fileinfo is checked
  • 22 January 2018
    If you are trying to hide the author avatar and other related information that appears in a K2 Item, you can do this on an article-by-article basis or you can change the settings for the category that the article belongs to. Edit category > Item View Options > Author options > Display ext...