Error 1064:SQL syntax

**GK User** Mon May 25, 2015 8:40 pm Reply with quote Report this post

I am getting this error on my webpage can anyone help as I dont have a clue what to do next.

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

When I click on k2/items/article I get the following errors

Notice: Undefined property: stdClass::$rows in /home/simdetai/public_html/administrator/components/com_k2/models/extrafield.php on line 224

Notice: Undefined property: stdClass::$cols in /home/simdetai/public_html/administrator/components/com_k2/models/extrafield.php on line 225

Not sure what that means or what I need to do to correct them.

**GK User** Tue May 26, 2015 11:42 am Reply with quote Report this post

Your lack of support you give towards your paided customers is pathetic.

**GK User** Thu May 28, 2015 3:12 pm Reply with quote Report this post

Hello,

Our usual reply time at forum is around 24-72h - unfortunately you have wrote at your topic again and your topic become invisible in our list of topics without reply.

Which extension returns the mentioned SQL error?

Regarding the PHP notices - it seems to be a core K2 issue - I suggest to consult it with K2 technical support.