Error 1054 on blog post approval
By Benoit Gonneville Damme on Wednesday, 24 June 2015
Posted in Technical Issues
Replies 4
Likes 0
Views 1.1K
Votes 0
Hi there,

I created a profile on my website using FB integration, I have the Easyblog Easysocial app installed. When that user created a test blog post on EB, I went to the backend to "approve" the post.

I got "1054 Unknown column 'post_id' in 'where clause' SQL=DELETE FROM `jos_easyblog_post_rejected` WHERE `post_id`='4'"

Find bellow my site details.

Thank

B.
Hello Benoit Gonneville Damme,

It seems like this table #__easyblog_post_rejected missing this column `post_id`, can you try run this sql in your database and see how it goes?

ALTER TABLE `#__easyblog_post_rejected` ADD `post_id` INT(11) UNSIGNED NOT NULL ;


Note: Replace #__ with your table prefix.
Arlex Wong
·
Wednesday, 24 June 2015 01:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Yup, that worked and I was able to approve the article!

Thanks

B.
Benoit Gonneville Damme
·
Wednesday, 24 June 2015 04:03
·
0 Likes
·
0 Votes
·
0 Comments
·
I spoke too fast.

It worked, but when I went to update the article, it went back to "approval" status and when I approve it in the back end, it does say " The pending entry has been approved.' but the article stays in the "pending approval" section and no changes are made in the frontend.
Benoit Gonneville Damme
·
Wednesday, 24 June 2015 04:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Benoit Gonneville Damme,

Sorry for late reply to this,

Can you try update to latest version and see how it goes? because this issues already fix in latest version.

keep us updated then the result
Arlex Wong
·
Wednesday, 24 June 2015 16:03
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post