Error 1064:SQL syntax
Rate this topic: 
1.00 out of 6 based on 1 vote(s)
1.00 out of 6 based on 1 vote(s)- 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.
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.
-
- Fresh Boarder
- 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.
-
- Fresh Boarder
- 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.
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.
-
- Administrator
3 posts
• Page 1 of 1