By d on Tuesday, 01 July 2014
Posted in General
Replies 1
Likes 0
Views 506
Votes 0
Had joomla 1.5 used spupgrade to 3.1, easyblog posts didn't import. I tried the tutorial to migrate from 1.5 to 2.5 for easyblog but I must be doing something wrong. When i try to import into the database i get:

--
-- Dumping data for table `qtjak_easyblog_acl`
--

INSERT INTO `qtjak_easyblog_acl` (`id`, `action`, `default`, `description`, `published`, `ordering`) VALUES
(1, 'add_entry', 1, 'If allowed, user is allowed to post a new blog post.', 1, 0),
(2, 'publish_entry', 1, 'If allowed, user is allowed to publish their blog post on the site. ', 1, 0),
(3, 'allow_feedburner', 1, 'If allowed, user can set their own Feedburner URL which will be linked to their own blog.', 1, 0),
(4, 'upload_avatar', 1, 'If allowed, user can upload their avatar.', 1, 0),
(5, 'manage_comment', 1, 'If allowed, user can manage any comments that are posted throughout the site.', 1, 0),
(6, 'update_twitter', 1, 'If allowed, user can post updates to their own Twitter account.', 1, 0),
(7, 'update_tweetmeme', 1, 'If allowed, user can update Tweetmeme settings. **Deprecated**', 0, 0),
(8, 'delete_entry', 1, 'If allowed, user can delete their own blog post.', 1, 0),
(9, 'add_trackback', 1, 'If allowed, user can specify[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'



I did notice I had easyblog installed first on 3.1, so should I uninstall it then try importing again, then install easyblog again? Thanks.
Hello D.,

Yes, you need uninstall it first before importing the database. You might want to start all over again by following this guide:

1. Open up PHPMyAdmin tool that is provided by your hosting provider and open up your current site's database.
2. Make a sql dump for all the tables that has the prefix of #__easyblog_*
3. Download the .sql file and save it on your desktop.
4. If your new site's database prefix also uses #__ , then you can skip this part. However, if you are using a different database prefix, you'll need to edit the .sql file that you've just downloaded, and do a search and replace of #__ with your new database prefix.
5. Open your PHPMyAdmin and this time, open up your new site's database.
6. You should see an import link at the top. Click on that, and click on browse. Select the .sql file and click the run import button.
7. Install the latest EasyBlog on your new site

8. Enjoy blogging! If you have any problems at this point, drop us an email and we'll take a look at this.

If you face any issue, you might want to provide your sites' access and also your phpmyadmin for both sites.
·
Tuesday, 01 July 2014 09:39
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post