By info on Friday, 21 June 2019
Posted in Technical Issues
Replies 7
Likes 0
Views 670
Votes 0
Hi, I need to migrate the easyblog site I have to an already established joomla site. Both already have a set of users in their databases.

I read your article about migration here: https://stackideas.com/docs/easyblog/administrators/migrations/migrating-to-a-different-joomla-site

and I noticed the point "Migrated all users from the original site into the new site. All user ids on the new site needs to be the same as the origin site"

If I use a user migration tool, I think they will create new user ids for the blog users being migrated. What will happen if the user ids on the new site don't match the origin site? basically how do you recommend the users be migrated?

Thanks
Most likely this guideline handle for the new fresh Joomla site. Imagine if your new site already have the existing users, mean there is higher possibility new site user id will match with your old site user id, then your old site user id have to update to another new id.

So it will cause your existing blog post author user id can't associated with your original author user id whoever created this blog post in previously, because the original author user id already updated to new user id, mean this blog post author will associated with your new site existing user id.
·
Friday, 21 June 2019 10:02
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex, I tried to change a user id from the origin site to a different number to avoid conflict on the existing new site.
I used the SQL query UPDATE `zzfew_users` SET `id` = 63 WHERE `zzfew_users`.`id` = 959

so the old joomla user id of 959 is changed to user id of 63. I used 63 because it doesn't already exist on the new site.

The user id looks successfully changed in the joomla user list, but now the author is gone from easyblog, and the articles that were assigned to that author now have no author assigned to them.

So then i saw the sql field xxxx_easyblog_users and changed the id there from 959 to 63 and added the nickname which was missing, but the author is still missing from the list of authors in easyblog backend.

What am I missing? Is there an easier way to do this? Thanks
·
Saturday, 22 June 2019 04:05
·
0 Likes
·
0 Votes
·
0 Comments
·
i found out the reason the author wasn't showing up in the list of easyblog authors was because the joomla user didn't have any user groups assigned to it. once I assigned the user to a group, the user shows up on the list, but i also had to reassign the articles to that author
·
Saturday, 22 June 2019 04:26
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey there,

I am really sorry for the delay of this reply as it is a weekend for us here.

UPDATE `zzfew_users` SET `id` = 63 WHERE `zzfew_users`.`id` = 959

Yes, you can't just execute this SQL query if you still not familiar the Joomla user system, because when you create a new user in Joomla backend, it actually will involved some of the Joomla user table like what you already figure out in your previous reply about the user group.

If only 1 author created all these blog post from your old site, then it will be less work to change your existing blog post author id to 63 . Keep us update if you need any assistance.
·
Saturday, 22 June 2019 11:40
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex, I continued with the rest of the instructions to migrate, but it did not work for me.
After step 6 of installing easyblog, i only see one easyblog post titled "You have successfully installed EasyBlog"

It appears that the installation of easyblog overwrote the imported data from the origin site?

Should I just drop all the easyblog tables in phpmyadmin and reimport the data from the origin site now that easyblog is installed?

Thanks
·
Tuesday, 25 June 2019 07:20
·
0 Likes
·
0 Votes
·
0 Comments
·
It appears that the installation of easyblog overwrote the imported data from the origin site?

Nope, it won't override your existing blog data, perhaps you can take a look this #__easyblog_post table and see whether you can see your old blog data?

By the way, may i know your new site is it doesn't have any Easyblog table right?

Should I just drop all the easyblog tables in phpmyadmin and reimport the data from the origin site now that easyblog is installed?

Yes, you have to uninstall your Easyblog on your new site then manually drop all the #__easyblog_xxx table then re-import your old site Easyblog table into your new site then only install Easyblog.

Or you can update your site backend, FTP, Database access so we can better have a check.
·
Tuesday, 25 June 2019 10:21
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post