By Fabian Mendoza on Friday, 10 July 2015
Posted in Technical Issues
Replies 3
Likes 0
Views 1K
Votes 0
Hello,

I have an error in my staging site.. Everytihng was fine. I made the update to joomla 3.4.3, but i dont know if this is related. just was one thing i made diferently.

Im testing the easyblog 5 in this staging site...

Well, the thing is that i acces to my super admin account in front end, basicly i don´t do nothing. Then i log out and thats when appeard this:

Error 100!
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 z5zhm_easyblog_post as a LEFT JOIN z5zhm_easyblog_featured AS f ON f.content_id = a.id LEFT JOIN z5zhm_easyblog_category AS c ON c.id = a.category_id LEFT JOIN z5zhm_users AS ua ON ua.id = a.created_by LEFT JOIN z5zhm_easyblog_users AS eu ON eu.id = ua.id LEFT JOIN z5zhm_easyblog_ratings AS v ON v.uid = a.id LEFT JOIN z5zhm_languages AS l ON a.language = l.lang_code LEFT JOIN z5zhm_easyblog_meta AS m ON (m.content_id = a.id AND m.type = "post") LEFT JOIN z5zhm_easyblog_post_tag AS pt ON pt.post_id = a.id LEFT JOIN z5zhm_easyblog_tag AS t ON t.id = pt.tag_id LEFT JOIN z5zhm_easyblog_comment AS cc ON cc.post_id = a.id LEFT JOIN z5zhm_easyblog_category_acl AS ca ON (ca.category_id = c.id AND ca.type = "group") LEFT JOIN z5zhm_easyblog_category_acl_item AS cai ON (cai.id = ca.acl_id AND cai.action = "view") WHERE ((((c.private = 0 AND a.private = 0) OR (1 IN (CONCAT_WS(",", ca.content_id)))) AND (a.published = 1 or a.published = 2) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-10 01:58:19') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-10 01:58:19') AND (a.published != -2)) AND a.category_id IN (5,2,4)) GROUP BY a.id ORDER BY a.created DESC LIMIT 6


I don´t know what is causing this but i see Easyblog in all the message so thats why im writing yu for a solution.

Thanks for your help.
Hi Fabian Mendoza,

It seems like this error exactly same as our customer reported this Rocksprocket module from this post thread -> http://stackideas.com/forums/easyblog5-rocksprocket-and-image-wall-issues

Perhaps you try disable Rocksprocket module and see how it goes?

By the way, we already contacted this issues in Rocksprocket team and we are still waiting for their respond.
·
Friday, 10 July 2015 10:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Mmmm ok..

But i need to tell you that i actually had Roksprocket disable, so i don´t know if is axactly related with that or i have to uninstallit completly..

Another tihng is that dependign on the browser the behave is different.

In chrome sends to another page with this message, like a 301 error page, and in firefox it shows the message as a joomla message and stays in the same page, in this case, the home.

Hope this can be something to find the solution.

Wait for tour answer.

Thanks.
·
Friday, 10 July 2015 11:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Fabian Mendoza,

Thanks for getting back to us,

Perhaps you can provide us with your site detail in the following so we can help you check on this?
#1. Joomla backend and FTP access
#2. How to replicate this error
·
Friday, 10 July 2015 12:23
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post