By Luigi Di Iorio on Thursday, 02 July 2015
Posted in Technical Issues
Likes 0
Views 683
Votes 0
When I try to approve a pending post I get this error:

1054 Unknown column 'post_id' in 'where clause' SQL=DELETE FROM `jos_easyblog_post_rejected` WHERE `post_id`='8'
Hello Luigi,

Can you download the attachment below and place it inside your /administrator/components/com_easyblog/controllers/ folder and see how it goes?
·
Thursday, 02 July 2015 17:39
·
0 Likes
·
0 Votes
·
0 Comments
·
sorry, still not working
·
Saturday, 04 July 2015 01:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Luigi Di Iorio,

I am really sorry for the delay of this reply as it is a weekend for us here.

This issues should be solved in latest version of Easyblog. If you're using latest version now, can you run this SQL in your PHPMYADMIN and see how it goes?

// Remember replace your table prefix in #__
ALTER TABLE `#__easyblog_post_rejected` CHANGE `draft_id` `post_id` INT(11) UNSIGNED NOT NULL;
·
Saturday, 04 July 2015 15:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, that fixed the issue
·
Saturday, 04 July 2015 16:22
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Luigi Di Iorio,

You're welcome. glad to heard your issues resolved.
·
Saturday, 04 July 2015 16:36
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post