Page 1 of 1

Move users from Joomla 1.0 to 1.7

Posted: Sat Jan 21, 2012 9:44 pm
by codj2k
I am taking over a site that is still running on Joomla 1.0. I need to move the users to Joomla 1.7.

There are currently over 200 active users on the 1.0 site.

I have built the new version of the site from scratch on 1.7.

However, I need to import these users from 1.0 to 1.7.

I understand that I will have to export the following tables from phpMyAdmin on the 1.0 and import them to the 1.7 site.

These are the tables in 1.0:
1. jos_users
2. jos_groups
3. jos_core_acl_aro
4. jos_core_acl_groups_aro_map

However, Joomla 1.7 doesn't use the same / exact names as 1.0 and the structures appear different.

This is what I done so far...the items on the right are the table names in 1.7
1. jos_users = jml_users
2. jos_groups = jml_usergroups
3. jos_core_acl_aro =! COULDNT FIND A CLOSE MATCH IN 1.7
4. jos_core_acl_groups_aro_map = jml_user_usergroup_map

While the export and import processes were successful, when I try to login, both as an admin/backend and a a regular user, I get the following error messages:

ADMIN SITE ERROR
JUser: :_load: Unable to load user with id: 62
JUser: :_load: Unable to load user with id: 62
You do not have access to the administrator section of this site.



MAIN SITE ERROR
JUser: :_load: Unable to load user with id: 93
JUser: :_load: Unable to load user with id: 93
You cannot access the private section of this site.


Could someone help with which table matches what and if I need to edit any table to ensure this works?

Re: Move users from Joomla 1.0 to 1.7

Posted: Sun Jan 22, 2012 1:22 am
by RussW
the J!1.0 and J!1.7 ACL tables are not compatible. You will need to find an extension that exports the J!1.0 users to maybe a CSV file and then maybe another extension that can import tthe CSV in to J!1.7

or, do them by hand.

Re: Move users from Joomla 1.0 to 1.7

Posted: Sun Jan 22, 2012 12:03 pm
by Per Yngve Berg
You are missing the jml_user_usergroup_map table which maps users to groups.

Re: Move users from Joomla 1.0 to 1.7

Posted: Sun Jan 22, 2012 12:43 pm
by codj2k
I have that, it is the 4th table above. Please see the original post

Re: Move users from Joomla 1.0 to 1.7

Posted: Sun Jan 22, 2012 2:32 pm
by Per Yngve Berg
jos_core_acl_aro is the jos_users table in 1.7