Move users from Joomla 1.0 to 1.7

Joomla version 1.0 is end-of-life and are no longer supported. Please use Joomla 3.x instead.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
codj2k
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Oct 17, 2007 5:14 pm

Move users from Joomla 1.0 to 1.7

Post by codj2k » Sat Jan 21, 2012 9:44 pm

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?

 
User avatar
RussW
Joomla! Exemplar
Joomla! Exemplar
Posts: 9356
Joined: Sun Oct 22, 2006 4:42 am
Location: Sunshine Coast, Queensland, Australia
Contact:

Re: Move users from Joomla 1.0 to 1.7

Post by RussW » Sun Jan 22, 2012 1:22 am

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.
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 27005
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Move users from Joomla 1.0 to 1.7

Post by Per Yngve Berg » Sun Jan 22, 2012 12:03 pm

You are missing the jml_user_usergroup_map table which maps users to groups.

codj2k
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Wed Oct 17, 2007 5:14 pm

Re: Move users from Joomla 1.0 to 1.7

Post by codj2k » Sun Jan 22, 2012 12:43 pm

I have that, it is the 4th table above. Please see the original post

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 27005
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Move users from Joomla 1.0 to 1.7

Post by Per Yngve Berg » Sun Jan 22, 2012 2:32 pm

jos_core_acl_aro is the jos_users table in 1.7

 

Locked

Return to “Upgrading - 1.0.x”