Error 1064 K2 items

Rate this topic: Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.Evaluations: 0, 0.00 on the average.
GK User
Wed Dec 31, 2014 9:34 am
Reply with quote
Report this post
Whenever I edit an article component K2 - there is an error 1064 in the frontend. The following text:

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 ') GROUP BY comments.itemID' at line 11 SQL=SELECT content.id AS id, COUNT(comments.itemID) AS count FROM aah82_k2_items AS content LEFT JOIN aah82_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( content.id = ) GROUP BY comments.itemID ;
It appears the page you were looking for doesn't exist. Sorry about that.


Where is the error? I have been twice placed a new backup. Whenever I change a certain K2 products - is the error in the backend. Can you help? Many Thanks Ilona :?
User avatar
Expert Boarder

GK User
Fri Jan 02, 2015 12:07 am
Reply with quote
Report this post
Hi!
yesterday faced with the same problem)
solution proved as follows:
You need to check all the "News Show Pro GK4" section settings "Date sourse"
"error 1064" appears when "Date sourse" is selected or not selected existing materials.
It is enough to take a close look "Date sourse" and clear the cache browser and Joomla!
Good Luck :)
User avatar
Senior Boarder


cron