By James Dudley on Monday, 01 February 2016
Posted in Technical Issues
Replies 5
Likes 0
Views 298
Votes 0
When I try to approve a post, I get the following error message:

1054 Unknown column 'post_id' in 'where clause' SQL=DELETE FROM `ctsi_easyblog_post_rejected` WHERE `post_id`='5'

In MySQL, when I describe the ctsi_easyblog_post_rejected table, I get the following:


mysql> desc ctsi_easyblog_post_rejected;
+------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+----------------+
| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment |
| draft_id | bigint(20) unsigned | NO | MUL | NULL | |
| created_by | int(11) | NO | | NULL | |
| message | text | NO | | NULL | |
| created | datetime | NO | | NULL | |
+------------+---------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

There is an 'id' column, but no 'post_id' column.

The admin interface indicates that I have the following version of EasyBlog: Installed Version: 5.0.6
Hey James,

Can you update to the latest version 5.0.32 ? Your installed version is pretty ancient
·
Monday, 01 February 2016 22:56
·
0 Likes
·
0 Votes
·
0 Comments
·
FYI, in the admin interface it said "Software IS Up To Date" when I had 5.0.6. In any event, I did upgrade to 5.0.32 and the problem persists.
·
Tuesday, 02 February 2016 00:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey James,

Yeah, there was a bug with the "version checks" in the previous versions Hm, if you are still having this issue, can you run this SQL query in phpmyadmin?



Remember to replace #__ with your database table prefix.
·
Tuesday, 02 February 2016 03:19
·
0 Likes
·
0 Votes
·
0 Comments
·
I installed the new version over the old version, and still had the problem. Then, I uninstalled EasyBlog completely and re-installed it, and things still didn't work, but I noticed the posts I had created previously were still there (i.e., uninstalling EasyBlog did not delete its database tables). Finally, I uninstalled EasyBlog AND manually deleted the easyblog tables from the database, reinstalled the new version of EasyBlog, and things are working now. Thanks for the quick responses.
·
Tuesday, 02 February 2016 06:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello James,

Great, glad to hear that.
·
Tuesday, 02 February 2016 11:56
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post