By Majid Ebr on Monday, 17 August 2015
Posted in Technical Issues
Replies 7
Likes 0
Views 600
Votes 0
Hi there,

I have a production website which runs on Joomla 2.5 and jomsocial 3.1. For various reasons, I do not want to upgrade that installation and I would like to start with a clean Joomla 3.4 installation and migrate the data from the old installation to it.
I have installed Joomla 3.4 and easysocial. Since the jomsocial migrator works only if the jomsocial exists on that installation, I did the following in order to make it work:

Modified jomsocial migrator to skip the checks if jomsocial exists and manually return the correct version
Copied the required jomsocial tables from the old database to the new one


After doing these steps, jomsocial migrator runs without any errors but the problem is that There is almost nothing imported. I checked the #___social_migrator table and everything seems to be there but nowhere else, for example no user in the user manager.

Then I though maybe the joomla users should already exist, so I started over with a clean installation and first copied joomla users from the old Joomla 2.5 to the new Joomla 3.4 and then did the steps above.
This time the users are there, but I think because they are synchronised with the Joomla users. But nothing else, no custom fields or any other information, though the migrator had successfully recognised the custom fields in both tries.

One thing I noticed on the migration log, I have this message for every single user:
User id '1028' has succefully mapped into EasySocial profile id 2 and all the associated fields has migrated into EasySocial.


in which the user id changes for each user but EasySocial profile ID stays the same (2) for all of them. Could this be a hint of something going wrong?

Otherwise could you please help with the migration issue?

Thank you in advance.
Hi Majid,

Thank you for the access details.

Regarding your issue, I've checked your database and apparently your user ids in jos_users is different than the userid in your JomSocial user table jos_community_users

All your user data for custom fields in JomSocial are based on the jos_community_users.userid.

May i know how you actually import the jos_users from your old site to your test site? When import, the jos_users.id must be intact.

Hope this help and have a nice day!
Sam
·
Tuesday, 18 August 2015 12:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Majid,

I am sorry for the delay of this reply,

Can I have the permission help you migrate again?

If can, I will do following step and check on this migration issue.
#1. Can you Install the Jomsocial in Joomla 3.4? (because I would like to see is it all the data migrated over Easysocial)
#2. Can you provide us with your Joomla backend, PHPMYADMIN and FTP access.
#3. I will truncate all you migrated the data in Easysocial then re-run again the migration.
·
Monday, 17 August 2015 18:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Alex,

Thank you for helping with this.
Unfortunately I can't have joomsocial installed in the new Joomla 3.4, since I don't have the installation files for Joomla 3 and no active subscription for a long time.
Is there any other way to proceed?

thanks,
Majid
·
Monday, 17 August 2015 19:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Majid,

I am sorry for the delay of this reply.

Unfortunately I can't have joomsocial installed in the new Joomla 3.4, since I don't have the installation files for Joomla 3 and no active subscription for a long time. Is there any other way to proceed?


If that is the case, we will try to re-run the migration based on the JomSocial db tables that you've already copied into your Joomla 3.4. By the way, did you copy the user's avatar and user photos from your Jomsocial into Joomla 3.4 as well? If not, you might want to do this as the migrator will also migrate user's avatar and photos. Also, you will need to bring over the data fromJoomla users table ( jos_users ) into your Joomla 3.4 as well because the migrator will not create the user records in jos_users table.

We will need your Joomla 3.4 the backend admin access, your phpmyadmin access to your Joomla 3.4 db and also FTP account to your Joomla 3.4 site.

Please advise.

Hope this help and have a nice day!
Sam
·
Monday, 17 August 2015 20:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Sam,

I have updated the first post with the requested information.
Regarding the avatars, I got a message during migration about them but since it was just a test I didn't bother for now.
As I already said, I imported all users from Joomla 2.5 before using the migration tool but it didn't help.

Thanks for helping with this issue.
·
Tuesday, 18 August 2015 02:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Sam,

Sorry for the delay in replying you. Thanks a lot for the hint. I had used a plugin to import old joomla users and I had not enabled the option to conserve the user IDs. I tried again and seems to be fine now, though I have to do a more through check.

Thank you again.
·
Friday, 11 September 2015 14:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Majid,

You are most welcome. Glad to hear your issue now resolved
Have a nice day!
Sam
·
Friday, 11 September 2015 15:48
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post