Keyword

sql error 1064 just sometimes !!

  • goran mihajlovic
  • goran mihajlovic's Avatar Topic Author
  • Offline
  • New Member
More
9 years 3 months ago #136355 by goran mihajlovic
sql error 1064 just sometimes !! was created by goran mihajlovic
Hi...

Please help me out of this problem....

When i select an item from the menu it show

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 guzto_k2_items AS content LEFT JOIN guzto_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( ) GROUP BY comments.itemID ;

even if the item is a wrapper.

if you are on the startpage and select from the left module any item.. then you got the message.... but if you select the last menu item and any of the subitems the site works even the left module selections... which was not working in startpage....

I don't really know if you understand me but you have to visit the site and make the selections...

the k2 is 2.6.9 and joomla is 3.2.3

Best Regards

MICROweb

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
9 years 3 months ago #136368 by Krikor Boghossian
Replied by Krikor Boghossian on topic sql error 1064 just sometimes !!
Hello,

Could you please enable the debugger to see which file is producing this error?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum