By Heino Rau on Monday, 06 October 2014
Posted in Technical Issues
Replies 3
Likes 0
Views 0.9K
Votes 0
Hey there,

i've migrated an old installation of easyblog from an old Joomla Page (2.5.6) to another Joomla-Page. Here's what I did:


Installing EasyBlog in the new Page
Making an SQL-Dump from the old Database including all easyblog_ tables (with DropTables)
Importing the SQL-Dump in the new Database


Everything works fine, but I can'ts edit or create any post.

Here ist the full error Message:

EasyBlogTableBlog: :store fehlgeschlagen!
Unknown column 'send_notification_emails' in 'field list' SQL=INSERT INTO `e4z0v_easyblog_post` (`id`,`created_by`,`modified`,`created`,`publish_up`,`publish_down`,`title`,`permalink`,`content`,`intro`,`category_id`,`published`,`private`,`frontpage`,`isnew`,`ispending`,`issitewide`,`robots`,`image`,`send_notification_emails`) VALUES ('','44','2014-10-05 17:43:26','2014-10-05 17:43:20','2014-10-05 17:43:20','0000-00-00 00:00:00','Test','test-2','','

Test TestTestTestTestTestTestTestTestTestTestTestTestTest
','2','1','0','1','0','0','1','','','0')

What can I do? The posted Solution to access the URL http://yoursite.com/administrator/index.php?option=com_easyblog&task=updatedb doen not work, I only get a blank page...
Hello Heino,

It looks like there's a missing database column on the site. If you try to install EasyBlog again, do you hit similar problems? If you do, Is it possible for you to provide us with the back end and FTP access to your site to check on this issue?
·
Monday, 06 October 2014 01:51
·
0 Likes
·
0 Votes
·
0 Comments
·
I am scared that If I Install it again, it could overwrite the easyblog_images folder and the Posts in the Database.

Could you give me a sql-dump including the possible missing Tables? So i could just add whta is missing without risking to destroy anything...
·
Monday, 06 October 2014 02:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Heino,

Installing it again will not override your images or blog posts Anyway try running the SQL queries below:


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;
·
Monday, 06 October 2014 03:01
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post