Approve Post Error
By Ian on Tuesday, 11 August 2015
Posted in General Issues
Replies 7
Likes 0
Views 507
Votes 0
Hi,

I am using EasyBlog 3.9. When I approve a pending post in the front end, I just get a blank white screen. When I approve them in the back end, I get this error:

Error 1054: Unknown column 'draft_id' in 'where clause' SQL=DELETE FROM `hvk2c_easyblog_post_rejected` WHERE `draft_id`='30'

Each time this happens, the post is duplicated - one remains in the pending list, and one gets published.

Strange:)

Any help?

Thanks
Hello Ian,

Can you try to run this SQL in your phpmyadmin:


CREATE TABLE IF NOT EXISTS `hvk2c_easyblog_post_rejected` (

  `id` bigint(20) unsigned NOT NULL auto_increment,

  `draft_id` bigint(20) unsigned NOT NULL,

  `created_by` int(11) NOT NULL,

  `message` text NOT NULL,

  `created` datetime NOT NULL,

  PRIMARY KEY  (`id`),

  KEY `draft_id` (`draft_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
Nik Faris
·
Tuesday, 11 August 2015 10:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick,

Thanks, but that hasn't fixed the issue.

Ian
Ian
·
Tuesday, 11 August 2015 10:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Ian,

Can you provide us the access to your phpmyadmin?
Nik Faris
·
Tuesday, 11 August 2015 10:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick

Please see details attached.

Thanks

Ian
Ian
·
Tuesday, 11 August 2015 11:53
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Ian,

I've fixed it for you by renaming the column in easyblog_post_rejected. By the way, did you downgrade from EB5 to EB39?
Nik Faris
·
Tuesday, 11 August 2015 13:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks.

Yes, I tried EB5 but felt more comfortable with EB3.9 at this stage.
Ian
·
Tuesday, 11 August 2015 13:29
·
0 Likes
·
0 Votes
·
0 Comments
·
hey Ian,

But we are not encourage downgrade back to Easyblog 3.9 from Easyblog 5.x is because it will messed up all the table structure.

Perhaps we can help you solve all the issue as you facing the issue in previously?

Looking forward of your response.
Arlex Wong
·
Tuesday, 11 August 2015 15:41
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post