installation error with easyblog 3.9
By faruk on Friday, 10 April 2015
Posted in General Issues
Replies 10
Likes 0
Views 761
Votes 0
Hi, I am having issues with easyblog 3.9 latest version. please advise.

Error: 1054

Unknown column 'a.private' in 'where clause' SQL=SELECT a.*, b.`title` AS `category` FROM `xxx_easyblog_post` AS a LEFT JOIN `xxx_easyblog_category` AS b ON a.category_id = b.id INNER JOIN `xxx_easyblog_featured` AS c ON a.`id` = c.`content_id` AND c.`type` = 'post' WHERE a.`published` = 1 AND a.`private` = '0' ORDER BY a.`created` DESC LIMIT 10
Hi Faruk,

Can you provide me access to your followings

1.Joomla backend.

2.FTP

3.PHP my admin access

Also I suspect that one of your Easyblog table is missing one column.
Christopher Chiam
·
Friday, 10 April 2015 11:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks I sorted it out
faruk
·
Monday, 13 April 2015 08:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Faruk,

I am glad that the issues have been resolve. Please do not hesitate to contact us if you need further assistance.
Christopher Chiam
·
Monday, 13 April 2015 10:26
·
0 Likes
·
0 Votes
·
0 Comments
·
It would be nice if the resolution to this issue was posted.
I have the same error and want to know how to solve it.
I have re-installed Easyblog to make sure that all columns were in the DB, but no solution to the issue.
Pieter J.van horssen
·
Tuesday, 28 April 2015 19:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Honestly, I just deleted everything and including the tables to I did a fresh install. did want to take a risk in on a live site. The good thing about my previous entries was backed the on a test site using rss importer of easyblog. Nothing fancy
faruk
·
Tuesday, 28 April 2015 20:06
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey guys,

You are hitting these issues most likely because you guys updated to 5.0 Alpha and tried to reinstall EasyBlog 3.9 again. Since upgrading to 5.0, this column would actually get deleted and when reverting, you will hit such errors.
Mark
·
Tuesday, 28 April 2015 23:51
·
0 Likes
·
0 Votes
·
0 Comments
·
He Mark,
You were so right and | feel a litle silly that I did not think of that.
I re-installed vsersion 5 latedst alpha and everything is a okay.

Thanks,
Pieter
Pieter J.van horssen
·
Wednesday, 29 April 2015 01:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Is it safe to install 5 latest alpha 5 on live site?

Kind Regards
faruk
·
Wednesday, 29 April 2015 02:06
·
0 Likes
·
0 Votes
·
0 Comments
·
It is never safe to install a Alpha version on a life site.
Wait till general release which means that the beta versions must have been passed as well.
BTW, I was testing on my test site.

Rgrds,
Pieter J.van horssen
·
Wednesday, 29 April 2015 05:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, Pieter.

Hello Faruk,

It is not safe to install an Alpha on live site. It might break your site.
Nik Faris
·
Wednesday, 29 April 2015 10:26
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post