Thursday, May 24th

Last update05:36:30 AM GMT

Font Size

Screen

Profile

Layout

Menu Style

Cpanel
Welcome, Guest
Username Password: Remember me

Syncing jos_ser table with jos_core_acl_aro table
(1 viewing) (1) Guest
Melbourne User Group Discussion and follow up from Joomla User Group meetings in Melbourne

If you have general Joomla questions, you're better off posting them in the main JoomlaOz discussion area - answers will then come from all over the country! If it's something tricky, consider going to forum.joomla.org for a global response.
  • Page:
  • 1

TOPIC: Syncing jos_ser table with jos_core_acl_aro table

Syncing jos_ser table with jos_core_acl_aro table 1 year, 2 months ago #3814

  • GeoffreyB
  • OFFLINE
  • Senior Boarder
  • Posts: 41
  • Karma: 1
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
Web Designer & Application Developer
Mornington Peninsula. (Melbourne)
www.morningtonpeninsulawebsites.com.au
Phone: 03 5977 0561
Mobile: 0414 902 258

Re: Syncing jos_ser table with jos_core_acl_aro table 1 year, 2 months ago #3815

  • dex
  • OFFLINE
  • Moderator
  • Posts: 779
  • Karma: 12
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
Dex Randall
Joomla! web design and production
Sydney JUG organiser + joomla.org.au site admin
www.spikesystems.com.au
www.twitter.com/dexx

Re: Syncing jos_ser table with jos_core_acl_aro table 1 year, 2 months ago #3816

  • Partic
  • OFFLINE
  • Moderator
  • Posts: 342
  • Karma: 21
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)
Patrick Jackson
www.kpsystems.com.au
Ask Anything Joomla and I'll helpfully tell you where to go

Re: Syncing jos_ser table with jos_core_acl_aro table 1 year, 2 months ago #3817

  • GeoffreyB
  • OFFLINE
  • Senior Boarder
  • Posts: 41
  • Karma: 1
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
Web Designer & Application Developer
Mornington Peninsula. (Melbourne)
www.morningtonpeninsulawebsites.com.au
Phone: 03 5977 0561
Mobile: 0414 902 258

Re: Syncing jos_ser table with jos_core_acl_aro table 1 year, 2 months ago #3818

  • GeoffreyB
  • OFFLINE
  • Senior Boarder
  • Posts: 41
  • Karma: 1
Thanks Dex,
I'll give this a go. Let you know how I go
Web Designer & Application Developer
Mornington Peninsula. (Melbourne)
www.morningtonpeninsulawebsites.com.au
Phone: 03 5977 0561
Mobile: 0414 902 258

Re: Syncing jos_ser table with jos_core_acl_aro table 1 year, 2 months ago #3819

  • dex
  • OFFLINE
  • Moderator
  • Posts: 779
  • Karma: 12
Yep, it's the password encryption that's good to have, plus it's a bit easier than DIY
Dex Randall
Joomla! web design and production
Sydney JUG organiser + joomla.org.au site admin
www.spikesystems.com.au
www.twitter.com/dexx

Re: Syncing jos_ser table with jos_core_acl_aro table 1 year, 2 months ago #3821

  • GeoffreyB
  • OFFLINE
  • Senior Boarder
  • Posts: 41
  • Karma: 1
Thanks Guys,
Solved this the manual way.
Web Designer & Application Developer
Mornington Peninsula. (Melbourne)
www.morningtonpeninsulawebsites.com.au
Phone: 03 5977 0561
Mobile: 0414 902 258
  • Page:
  • 1
Moderators: Partic, PtrNrs, Shane Thorpe
Time to create page: 0.63 seconds
You are here: Forum