By Arghavan Gerami on Friday, 14 November 2014
Posted in General Issues
Replies 1
Likes 0
Views 628
Votes 0
Hi,

I am currently running EasyBlog 3.9.19335. And this is related to GeramiLaw.com website.

I am having trouble creating a blog entry. I get the following error message which suggest that the database tables are not in synch with the code. Essentially the field send_notification_emails does not exist in jos_easyblog_post table.


1054 Unknown column 'send_notification_emails' in 'field list' SQL=INSERT INTO `jos_easyblog_post` (`created_by`,`modified`,`created`,`publish_up`,`publish_down`,`title`,`permalink`,`content`,`intro`,`category_id`,`published`,`private`,`allowcomment`,`subscription`,`frontpage`,`isnew`,`ispending`,`issitewide`,`blogpassword`,`latitude`,`longitude`,`address`,`source`,`robots`,`copyrights`,`image`,`language`,`send_notification_emails`) VALUES ('268','2014-11-14 02:12:24','2014-11-14 02:12:04','2014-11-14 02:12:04','0000-00-00 00:00:00','test','test','','

test
','2','0','0','1','1','1','1','0','1','','','','','','','','','','0')


Note that this is an upgraded database structure from a previous version of Easy Blog.

Is there a database script that I can run to upgrade the database structure to make it compatible with EasyBlog 3.9.19335?

Many thanks
Hello,

Can you try to run this SQL and see how it goes:

ALTER TABLE `#__easyblog_post` ADD `send_notification_emails` TINYINT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `#__easyblog_drafts` ADD `send_notification_emails` TINYINT( 1 ) NOT NULL DEFAULT '1';


If this doesn't work, you can provide us your backend and FTP so we can have a better look on this issue.
·
Friday, 14 November 2014 10:55
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post