SQL error

Professionally designed and responsive events Joomla template to launch your event based website.
GK User
Fri Mar 13, 2015 10:49 am
On developing a site that uses a template Events suddenly appeared sql 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 'ASC LIMIT 0,8' at line 21 SQL=SELECT content.id AS id FROM hrm3_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-13 10:01:56' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2015-03-13 10:01:56' ) AND ( content.catid = 33 ) ORDER BY content. ASC LIMIT 0,8;

Web uses Joomla! 3.4.0 Stable, MySQL 5.6.15 , PHP 5.4.37, web server Apache.
wed address: http://www.joomlapolis.cz/test/hrmeetup3/

This error causes the module News Show Pro GK5, which is published on the homepage, called Speakers - Speakers list.
When I make this modul unpublic, error disappears.

Any advice?
User avatar
Senior Boarder

GK User
Fri Mar 13, 2015 11:39 am
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


cron