Moving users

Joomla version 1.5 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
paschal-lamb
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Fri May 09, 2008 1:45 pm

Moving users

Post by paschal-lamb » Tue May 13, 2008 3:51 pm

I am rebuilding a Joomla 1.5 site. I want to move my user details on to the new site so that they will be able to login without having to re-register.

I have backed up the old database and run it insert SQL for the jos_users table and successfully inserted my users into that table. When I then go to the admin screen to look at the inserted user base I see nothing except the Admin user set up when I created the site.

What else must I do to fully take on my user base?

any help would be much appreciated.

Lamb.

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 24985
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Moving users

Post by pe7er » Tue May 13, 2008 4:55 pm

The users will only appear in the User Manager if all references in the following tables are correct:
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map

These are all needed for managing the users... So you have to copy the 2 other tables as well.

Some SQL queries to find the missing info:
http://forum.joomla.org/viewtopic.php?t=137296#p679956
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com

paschal-lamb
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Fri May 09, 2008 1:45 pm

Re: Moving users

Post by paschal-lamb » Tue May 13, 2008 7:58 pm

Thanks for the reply. The following tables are now populated with data from the old install:
jos_users
jos_core_acl_aro
jos_core_acl_groups_aro_map

I can now see all of the users in the admin screens. - That's great, thanks. However they do not work when a log in attempt is made with any of them except the Admin login (created by the install and not migrated). There is no error message anywhere. I guess I have some more to do, but can someone please advise me just what else I have to do to get my users up and running again?

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 24985
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, Netherlands
Contact:

Re: Moving users

Post by pe7er » Tue May 13, 2008 8:35 pm

Did you make use of any 3rd party extensions at the old site?
e.g. Community Builder, JACLPro?

What browser (& version) do you use? Could you test it with another (e.g. Firefox)?
Is JavaScript enabled?
Could you empty the browser cache & temp internet files?

If you create a new user, can you login with that new user in the front-end?
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com

paschal-lamb
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Fri May 09, 2008 1:45 pm

Re: Moving users

Post by paschal-lamb » Tue May 13, 2008 9:08 pm

pe7er wrote:Did you make use of any 3rd party extensions at the old site?
e.g. Community Builder, JACLPro? The only one I used was jfusion

What browser (& version) do you use? Could you test it with another (e.g. Firefox)?
Is JavaScript enabled? I use firefox and IE7. JavaScript is enabled
Could you empty the browser cache & temp internet files? Makes no difference

If you create a new user, can you login with that new user in the front-end?
A new user works fine.


Locked

Return to “Migrating and Upgrading to Joomla! 1.5”