1064 error when people click Home
- cmrpc
- OFFLINE
-
Senior Member
- Posts: 41
- Thanks: 2
- Karma: 0
8 years 11 months ago #264308
by cmrpc
"People say the road to hell is paved with good intentions. Why? Do they think there’s a shortage of bad ones?"
1064 error when people click Home was created by cmrpc
I keep getting this error only when I am logged in and trying to get to the front of the site by clicking home.
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 n7u4l_k2_items AS content LEFT JOIN n7u4l_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( ) GROUP BY comments.itemID ;
Any Ideas?
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 n7u4l_k2_items AS content LEFT JOIN n7u4l_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( ) GROUP BY comments.itemID ;
Any Ideas?
"People say the road to hell is paved with good intentions. Why? Do they think there’s a shortage of bad ones?"
Please Log in to join the conversation.
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
8 years 11 months ago #264309
by nant
Reading what you wrote, I see issue is related to k2 comments - seek help from K2 team - seems that this is not related at all with CB.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic 1064 error when people click Home
cmrpc wrote: I keep getting this error only when I am logged in and trying to get to the front of the site by clicking home.
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 n7u4l_k2_items AS content LEFT JOIN n7u4l_k2_comments AS comments ON comments.itemID = content.id WHERE comments.published AND ( ) GROUP BY comments.itemID ;
Any Ideas?
Reading what you wrote, I see issue is related to k2 comments - seek help from K2 team - seems that this is not related at all with CB.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- cmrpc
- OFFLINE
-
Senior Member
- Posts: 41
- Thanks: 2
- Karma: 0
8 years 11 months ago #264310
by cmrpc
"People say the road to hell is paved with good intentions. Why? Do they think there’s a shortage of bad ones?"
Replied by cmrpc on topic 1064 error when people click Home
Thanks
"People say the road to hell is paved with good intentions. Why? Do they think there’s a shortage of bad ones?"
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.195 seconds
-
You are here:
- Home
- Forums
- Community Discussions
- Community Builder
- 1064 error when people click Home