Hi I renew my EasyBlog Subscription just to be able to upgrade it version, the process itself worked fine, but I got a error with one specific module (RokSproket module), it was working really fine before the upgrade, and now I simply dont load, also when I go to check this module in the backend I got this error message:
- - - - - - - - - - - - - - - - - - - - - - - - - -
500 - Ocorreu um erro.
Unknown column 'a.private' in 'field list' 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 v1da_easyblog_post as a LEFT JOIN v1da_easyblog_featured AS f ON f.content_id = a.id LEFT JOIN v1da_easyblog_category AS c ON c.id = a.category_id LEFT JOIN v1da_users AS ua ON ua.id = a.created_by LEFT JOIN v1da_easyblog_users AS eu ON eu.id = ua.id LEFT JOIN v1da_easyblog_ratings AS v ON v.uid = a.id LEFT JOIN v1da_languages AS l ON a.language = l.lang_code LEFT JOIN v1da_easyblog_meta AS m ON (m.content_id = a.id AND m.type = "post") LEFT JOIN v1da_easyblog_post_tag AS pt ON pt.post_id = a.id LEFT JOIN v1da_easyblog_tag AS t ON t.id = pt.tag_id LEFT JOIN v1da_easyblog_comment AS cc ON cc.post_id = a.id LEFT JOIN v1da_easyblog_category_acl AS ca ON (ca.category_id = c.id AND ca.type = "group") LEFT JOIN v1da_easyblog_category_acl_item AS cai ON (cai.id = ca.acl_id AND cai.action = "view") LEFT OUTER JOIN (select rsi.provider_id, rsi.order from v1da_roksprocket_items as rsi where module_id = 174) rsi on a.id = rsi.provider_id 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 (125)) GROUP BY a.id ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order
Retornar ao Painel de Controle
- - - - - - - - - - - - - - - - - - - - - - - - - -
With Best Regards
Bruno Alecrim
- - - - - - - - - - - - - - - - - - - - - - - - - -
500 - Ocorreu um erro.
Unknown column 'a.private' in 'field list' 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 v1da_easyblog_post as a LEFT JOIN v1da_easyblog_featured AS f ON f.content_id = a.id LEFT JOIN v1da_easyblog_category AS c ON c.id = a.category_id LEFT JOIN v1da_users AS ua ON ua.id = a.created_by LEFT JOIN v1da_easyblog_users AS eu ON eu.id = ua.id LEFT JOIN v1da_easyblog_ratings AS v ON v.uid = a.id LEFT JOIN v1da_languages AS l ON a.language = l.lang_code LEFT JOIN v1da_easyblog_meta AS m ON (m.content_id = a.id AND m.type = "post") LEFT JOIN v1da_easyblog_post_tag AS pt ON pt.post_id = a.id LEFT JOIN v1da_easyblog_tag AS t ON t.id = pt.tag_id LEFT JOIN v1da_easyblog_comment AS cc ON cc.post_id = a.id LEFT JOIN v1da_easyblog_category_acl AS ca ON (ca.category_id = c.id AND ca.type = "group") LEFT JOIN v1da_easyblog_category_acl_item AS cai ON (cai.id = ca.acl_id AND cai.action = "view") LEFT OUTER JOIN (select rsi.provider_id, rsi.order from v1da_roksprocket_items as rsi where module_id = 174) rsi on a.id = rsi.provider_id 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 (125)) GROUP BY a.id ORDER BY IF(ISNULL(rsi.order),1,0),rsi.order
Retornar ao Painel de Controle
- - - - - - - - - - - - - - - - - - - - - - - - - -
With Best Regards
Bruno Alecrim