The Joomla! Forum ™

Download

Demo


Board index » Joomla! Older Version Support » Joomla! 1.0 » Upgrading - 1.0.x

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.



Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
  Print view Previous topic | Next topic 
Author Message
codj2k
PostPosted: Sat Jan 21, 2012 9:44 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Oct 17, 2007 5:14 pm
Posts: 4
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?
Top
 Profile  
 
RussW
PostPosted: Sun Jan 22, 2012 1:22 am 
User avatar
Joomla! Exemplar
Joomla! Exemplar

Joined: Sun Oct 22, 2006 4:42 am
Posts: 9352
Location: Sunshine Coast, Queensland, Australia
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/
Network SMARTS, Systems Engineering http://www.networksmarts.com.au/
Top
 Profile  
 
Per Yngve Berg
PostPosted: Sun Jan 22, 2012 12:03 pm 
Joomla! Master
Joomla! Master

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 13759
Location: Akershus, Norway
You are missing the jml_user_usergroup_map table which maps users to groups.
Top
 Profile  
 
codj2k
PostPosted: Sun Jan 22, 2012 12:43 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Oct 17, 2007 5:14 pm
Posts: 4
I have that, it is the 4th table above. Please see the original post
Top
 Profile  
 
Per Yngve Berg
PostPosted: Sun Jan 22, 2012 2:32 pm 
Joomla! Master
Joomla! Master

Joined: Mon Oct 27, 2008 9:27 pm
Posts: 13759
Location: Akershus, Norway
jos_core_acl_aro is the jos_users table in 1.7
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 


Board index » Joomla! Older Version Support » Joomla! 1.0 » Upgrading - 1.0.x

Who is online

Users browsing this forum: No registered users and 3 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group