this is really something that is giving me headaches. Last year i had this issue on my joomla site but i managed to sync those tables using a sql query that i dont have anymore.
I really tought that this got solved for good, but yesterday i just noticed that this tables are not sync anymore. The jos_users table have 4967 users and the jos_core_acl_aro have 5135, wich is a big diference.
Im using joomla 1.5.22 and im using 2 components that i suspect it has something to do with this issue: Regreminder ( Notify inactiv users and delete inactiv accounts for a specific time) Unregister (Let the user delete their own account for good)
For now i would like to know a query to run in phpmyadmin so i can see wich data is missing in jos_users since jos_core_acl_aro have more data. Something like comparing this 2 tables and check the data missing. Ive been searching google for this but maybe im not im my lucky day..
Sincerely Daniel Q.
Don't know the table nor Joomla, so you have to fill in the gaps.
select a, b, c from jos_core_acl_aro
minus
select a, b, c from jos_users
a, b and c are the columns you want to see, which have to be in both tables (although they can have different names). Also together they should be unique in each table.