By Colin McLain on Wednesday, 18 March 2015
Posted in General Issues
Replies 1
Likes 0
Views 731
Votes 0
When trying to post a new blogpost via the admin side, I get this error.
Unknown column 'send_notification_emails' in 'field list' SQL=INSERT INTO `n0r8m_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 ('313','2015-03-17 19:01:57','2015-03-17 19:01:36','2015-03-17 19:01:36','0000-00-00 00:00:00','TEST','test','','<p>TEST TEST TEST TEST</p>','1','1','0','1','1','1','0','0','1','','','','','','','','{\"type\":\"image\",\"title\":\"lisa.jpg\",\"mime\":\"image/jpeg\",\"url\":\"https://hugtest.int.hugllc.com/images/easyblog_images/313/lisa.jpg\",\"dateCreated\":\"Wednesday, 04 February 2015\",\"dateModified\":1423075155,\"path\":\"/lisa.jpg\",\"place\":\"user:313\",\"thumbnail\":{\"url\":\"https://hugtest.int.hugllc.com/images/easyblog_images/313/b2ap3_thumbnail_lisa.jpg\"},\"icon\":{\"url\":\"https://hugtest.int.hugllc.com/images/easyblog_images/313/b2ap3_icon_lisa.jpg\"},\"key\":\"user:313|/lisa.jpg\",\"hash\":\"00870288752110191\",\"group\":\"files\",\"parentKey\":\"user:313|/\",\"friendlyPath\":\"My Media/lisa.jpg\"}','','0')


You probably don't need all that, but hey, it may help.

Thanks for your help.
Hello Colin,

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.
·
Wednesday, 18 March 2015 10:19
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post