Rok Sproket & Easyblog 5 not working together
-
-
- johnwa
- Newbie
- Posts: 11
- Thanks: 0
- John
-
I have just upgraded my Easyblog installation which I have integrated with a number of the Rok products including rok sporket. Since the upgrate Rokspoket no longet functions. I have updated to the latest version of Rok Spoken and the lates V4 version of gantry but still get errors as below:
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 spoket, any idea when this will be fixed?
-
-
-
- MrT
- Preeminent Rocketeer
- Posts: 101084
- Thanks: 13484
- Web Designer/Developer
-
http://www.rockettheme.com/forum/joomla-extension-roksprocket/243207-easyblog-5?start=0#1209305
http://www.rockettheme.com/forum/joomla-extension-roksprocket/241637-roksprocket-easyblog-5?start=0#1201354
At the moment roksprocket does not work with Easyblog 5.
Regards, Mark. - Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
-
-
-
- MrT
- Preeminent Rocketeer
- Posts: 101084
- Thanks: 13484
- Web Designer/Developer
-
Official RT reply from DEVS...
RT wrote:We will be releasing a new version of roksprocket that will be compatible with Easyblog 5. We are actively working on this but cannot give an accurate timescale at this stage.
I hope that helps.
Regards, Mark. - Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
-
-
-
- MrT
- Preeminent Rocketeer
- Posts: 101084
- Thanks: 13484
- Web Designer/Developer
-
All roksprocket 2.1.7 released with Easyblog 5 compatibility.
Regards, Mark. -
The following users have thanked you: Froman
- Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
-
Time to create page: 0.131 seconds