Response Time
24 — 48 hours
I use the Rocket Theme's Rok Sproket component to drive a chunk of my site but I get the following error:
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 ':moeraki,73:breeze)) GROUP BY a.id' at line 15 SQL=SELECT a.id, a.title, a.content, a.intro, a.excerpt, a.category_id, a.private, a.published, a.created, a.created_by, a.modified, a.frontpage, a.language, a.hits, a.publish_up, a.publish_down, a.image, a.language, a.copyrights, a.source, a.robots,f.content_id,c.title AS category_title, c.private,ua.name AS author_name,ua.name AS author_name,ROUND( SUM(v.value) / COUNT(v.id), 0 ) AS rating, COUNT(v.uid) as rating_count,l.title AS language_title,m.keywords AS metakey, m.description AS metadesc,CONCAT_WS(",", t.title) AS tags,COUNT(cc.id) AS comment_count,CONCAT_WS(",", ca.content_id) AS category_access FROM cbx39_easyblog_post as a LEFT JOIN cbx39_easyblog_featured AS f ON f.content_id = a.id LEFT JOIN cbx39_easyblog_category AS c ON c.id = a.category_id LEFT JOIN cbx39_users AS ua ON ua.id = a.created_by LEFT JOIN cbx39_easyblog_users AS eu ON eu.id = ua.id LEFT JOIN cbx39_easyblog_ratings AS v ON v.uid = a.id LEFT JOIN cbx39_languages AS l ON a.language = l.lang_code LEFT JOIN cbx39_easyblog_meta AS m ON (m.content_id = a.id AND m.type = "post") LEFT JOIN cbx39_easyblog_post_tag AS pt ON pt.post_id = a.id LEFT JOIN cbx39_easyblog_tag AS t ON t.id = pt.tag_id LEFT JOIN cbx39_easyblog_comment AS cc ON cc.post_id = a.id LEFT JOIN cbx39_easyblog_category_acl AS ca ON (ca.category_id = c.id AND ca.type = "group") LEFT JOIN cbx39_easyblog_category_acl_item AS cai ON (cai.id = ca.acl_id AND cai.action = "view") WHERE ((((c.private < 2) OR ((1 IN (CONCAT_WS(",", ca.content_id))) OR (8 IN (CONCAT_WS(",", ca.content_id))))) AND (a.published != -2)) AND a.id IN (74:moeraki,73:breeze)) GROUP BY a.id
so guessing that there is a compatiblity with easyblog 5 and sproket
Can I roll back from EB5???
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 ':moeraki,73:breeze)) GROUP BY a.id' at line 15 SQL=SELECT a.id, a.title, a.content, a.intro, a.excerpt, a.category_id, a.private, a.published, a.created, a.created_by, a.modified, a.frontpage, a.language, a.hits, a.publish_up, a.publish_down, a.image, a.language, a.copyrights, a.source, a.robots,f.content_id,c.title AS category_title, c.private,ua.name AS author_name,ua.name AS author_name,ROUND( SUM(v.value) / COUNT(v.id), 0 ) AS rating, COUNT(v.uid) as rating_count,l.title AS language_title,m.keywords AS metakey, m.description AS metadesc,CONCAT_WS(",", t.title) AS tags,COUNT(cc.id) AS comment_count,CONCAT_WS(",", ca.content_id) AS category_access FROM cbx39_easyblog_post as a LEFT JOIN cbx39_easyblog_featured AS f ON f.content_id = a.id LEFT JOIN cbx39_easyblog_category AS c ON c.id = a.category_id LEFT JOIN cbx39_users AS ua ON ua.id = a.created_by LEFT JOIN cbx39_easyblog_users AS eu ON eu.id = ua.id LEFT JOIN cbx39_easyblog_ratings AS v ON v.uid = a.id LEFT JOIN cbx39_languages AS l ON a.language = l.lang_code LEFT JOIN cbx39_easyblog_meta AS m ON (m.content_id = a.id AND m.type = "post") LEFT JOIN cbx39_easyblog_post_tag AS pt ON pt.post_id = a.id LEFT JOIN cbx39_easyblog_tag AS t ON t.id = pt.tag_id LEFT JOIN cbx39_easyblog_comment AS cc ON cc.post_id = a.id LEFT JOIN cbx39_easyblog_category_acl AS ca ON (ca.category_id = c.id AND ca.type = "group") LEFT JOIN cbx39_easyblog_category_acl_item AS cai ON (cai.id = ca.acl_id AND cai.action = "view") WHERE ((((c.private < 2) OR ((1 IN (CONCAT_WS(",", ca.content_id))) OR (8 IN (CONCAT_WS(",", ca.content_id))))) AND (a.published != -2)) AND a.id IN (74:moeraki,73:breeze)) GROUP BY a.id
so guessing that there is a compatiblity with easyblog 5 and sproket
Can I roll back from EB5???
1 Replies
The replies under this section are restricted to logged in users or users with an active subscription with us
