I have recently migrated a site from version 1.0.15 to version 1.5.22 using a component called mtwMigrator. This component is a 1.5 native component which you use after you have install the new site to import the data from the old version.
In the main this component worked extremely well, however when I look in the User Manager there are only records for the 2 administrators.
Further investigation revealed that all the records are there in the jos_users table but relevant records are not in the jos_cor_acl_aro table which is why the users do not display in the User manager.
Does any one know of an sql script to sync these tables if not I guess I will have to write one.

Cheers
Geoffrey

Hi Geoffrey

this component for J!.5 might help extensions.joomla.org/search?q=userport

it takes in a file with the basic user credentials (username, pwd, email) and creates all the necessary records in all the necessary tables.

You could probably massage it to work for the migration - it comes with a bunch of options on usage.

Dex

I don't know that the 1.0 and 1.5 ACL tables are all that different.

If you have myPHPadmin to bother databases, compare them, then if they are the same, and the user IDs have not changed, just export the contents of the 1.0 table as SQL, and paste it in the SQL tab on the table for the 1.5 database.

There's 3 ACL tables all up I think that you should check. All these tables should have the same number of records.

jos_users
jos_core_acl_aro - maps users to access request objects
jos_core_acl_groups_aro_map - maps the aro table values to the joomla ACL groups

(help.joomla.org/content/view/25/125/ explains ACL and ARO)

Thanks Patrick,
I have tried to sync the tables with the MYSQL utility that I have but the tables are different from 1.0.x to 1.5.x I'll try Dex's solution before doing something more drastic like writing and SQL script to do the sync. It could be that I am lazy or it could be that I don't want to reinvent the wheel.
Cheers

Thanks Dex,
I'll give this a go. Let you know how I go

Yep, it's the password encryption that's good to have, plus it's a bit easier than DIY

Thanks Guys,
Solved this the manual way.