I have a site where there are 750+ users which I just added straight to the database. Username, pwd, real nam, etc required.
When I uploaded the CSV file from Excell to database, only first 20 user show in backend. Userlist tells that there are 38 pages of users, but when I go to some other page than the first on the other pages are blank.
If I check the DB all users are there.
When I try to log in in front end I get the error E_NOLOGIN_ACCESS.
What have I done wrong?
E_NOLOGIN_ACCESS and only first 20 users show in backend
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.
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.
-
- Joomla! Apprentice
- Posts: 26
- Joined: Mon Aug 23, 2010 6:59 am
- pe7er
- Joomla! Master
- Posts: 24927
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: E_NOLOGIN_ACCESS and only first 20 users show in backend
Welcome to Joomla forum!
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
Some SQL queries to repair the tables:
http://forum.joomla.org/viewtopic.php?p ... 2#p1663342
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
Some SQL queries to repair the tables:
http://forum.joomla.org/viewtopic.php?p ... 2#p1663342
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
-
- Joomla! Apprentice
- Posts: 26
- Joined: Mon Aug 23, 2010 6:59 am
Re: E_NOLOGIN_ACCESS and only first 20 users show in backend
Thanks. I thougt it would be something to do with those tables.
I have in acl_aro table data like this
Edit Delete 14 users 1002 0 Aapo Pääkkö 0
Edit Delete 18 users 1009 0 Anita Birstolin 0
Edit Delete 19 users 1005 0 Aino Marjatta Pohjoisaho-Vaininen 0
Edit Delete 20 users 1006 0 Aino-Maija Rautkallio 0
Edit Delete 21 users 1007 0 Aino Kanniainen 0
Edit Delete 22 users 1008 0 Aku Kaura 0
And the values are corresponding jos_users tables ID's. And my acl_aro_groups map like this
group_id section_value aro_id
Edit Delete 21 19
Edit Delete 21 22
Edit Delete 21 23
Edit Delete 21 797
Edit Delete 21 824
Edit Delete 21 828
Edit Delete 21 831
Edit Delete 21 832
Edit Delete 21 833
Edit Delete 21 834
Edit Delete 21 835
Edit Delete 21 836
Edit Delete 21 837
Edit Delete 21 838
Edit Delete 21 839
Edit Delete 21 840
Edit Delete 21 841
Edit Delete 25 10
Edit Delete 25 18
Edit Delete 25 20
Edit Delete 25 21
But when I try to run queries to repair the tabels I get this error:
#1054 - Unknown column 'aro_id' in 'field list'
I have in acl_aro table data like this
Edit Delete 14 users 1002 0 Aapo Pääkkö 0
Edit Delete 18 users 1009 0 Anita Birstolin 0
Edit Delete 19 users 1005 0 Aino Marjatta Pohjoisaho-Vaininen 0
Edit Delete 20 users 1006 0 Aino-Maija Rautkallio 0
Edit Delete 21 users 1007 0 Aino Kanniainen 0
Edit Delete 22 users 1008 0 Aku Kaura 0
And the values are corresponding jos_users tables ID's. And my acl_aro_groups map like this
group_id section_value aro_id
Edit Delete 21 19
Edit Delete 21 22
Edit Delete 21 23
Edit Delete 21 797
Edit Delete 21 824
Edit Delete 21 828
Edit Delete 21 831
Edit Delete 21 832
Edit Delete 21 833
Edit Delete 21 834
Edit Delete 21 835
Edit Delete 21 836
Edit Delete 21 837
Edit Delete 21 838
Edit Delete 21 839
Edit Delete 21 840
Edit Delete 21 841
Edit Delete 25 10
Edit Delete 25 18
Edit Delete 25 20
Edit Delete 25 21
But when I try to run queries to repair the tabels I get this error:
#1054 - Unknown column 'aro_id' in 'field list'
- pe7er
- Joomla! Master
- Posts: 24927
- Joined: Thu Aug 18, 2005 8:55 pm
- Location: Nijmegen, Netherlands
- Contact:
Re: E_NOLOGIN_ACCESS and only first 20 users show in backend
Sorry, my bad.. The queries I referred to are for Joomla 1.0.
In Joomla 1.5 the structure of the "jos_core_acl_aro" table has been changed and it does not have an "aro_id" anymore.
I rewrote the SQL code to Joomla 1.5.
Note: I haven't tested it myself, so make sure you create a back-up before running:
In Joomla 1.5 the structure of the "jos_core_acl_aro" table has been changed and it does not have an "aro_id" anymore.
I rewrote the SQL code to Joomla 1.5.
Note: I haven't tested it myself, so make sure you create a back-up before running:
Code: Select all
DELETE FROM jos_core_acl_aro WHERE aro <> 10;
DELETE FROM jos_core_acl_groups_aro_map WHERE aro_id <> 10;
INSERT INTO jos_core_acl_aro (section_value, value , name)
SELECT 'users', id, name from jos_users WHERE id NOT IN (SELECT value from jos_core_acl_aro WHERE id = 10);
INSERT INTO jos_core_acl_groups_aro_map (group_id, aro_id)
SELECT 18, id FROM jos_core_acl_aro where id <> 10;
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com
-
- Joomla! Apprentice
- Posts: 26
- Joined: Mon Aug 23, 2010 6:59 am
Re: E_NOLOGIN_ACCESS and only first 20 users show in backend
Thanks. That did the job.
-
- Joomla! Apprentice
- Posts: 13
- Joined: Wed Apr 08, 2009 3:56 am
Re: E_NOLOGIN_ACCESS and only first 20 users show in backend
Hi there, I have a similar problem,
jos_core_acl_aro have missing users that are listed in jos_users.
This causes missing user in joomla user management backend. I think it was due to a recent backup recovery.
I tried everything on this thread but still it doesn't work!
I think this query doesn't work with my joomla version 1.5.22:
I suspect the column are not named the same on my joomla version.
Please help.
Regards,
Alex
jos_core_acl_aro have missing users that are listed in jos_users.
This causes missing user in joomla user management backend. I think it was due to a recent backup recovery.
I tried everything on this thread but still it doesn't work!
I think this query doesn't work with my joomla version 1.5.22:
Code: Select all
DELETE FROM jos_core_acl_aro WHERE aro <> 10;
DELETE FROM jos_core_acl_groups_aro_map WHERE aro_id <> 10;
INSERT INTO jos_core_acl_aro (section_value, value , name)
SELECT 'users', id, name from jos_users WHERE id NOT IN (SELECT value from jos_core_acl_aro WHERE id = 10);
INSERT INTO jos_core_acl_groups_aro_map (group_id, aro_id)
SELECT 18, id FROM jos_core_acl_aro where id <> 10;
Please help.
Regards,
Alex
- linkedla
- Joomla! Apprentice
- Posts: 29
- Joined: Fri Dec 15, 2006 3:05 am
- Location: Miami, USA
- Contact:
Re: E_NOLOGIN_ACCESS and only first 20 users show in backend
Hello,
I had this problem by God blessing just a user.
Solution I did search the user in J! user list, non existent user there, search in VM user list and there is it, so it is a misconfiguration between the two tables I did delete the user form VM and recreate it with the info i had in the VM user list.
After that the user appears min both lists.
I am not a coder so i do not know how to sync J! and VM user tables but certainly here some one will help, also I hope this can help someone else.
I have J!. 1.5.22 and VM 1.1.7 over lamp
I had this problem by God blessing just a user.
Solution I did search the user in J! user list, non existent user there, search in VM user list and there is it, so it is a misconfiguration between the two tables I did delete the user form VM and recreate it with the info i had in the VM user list.
After that the user appears min both lists.
I am not a coder so i do not know how to sync J! and VM user tables but certainly here some one will help, also I hope this can help someone else.
I have J!. 1.5.22 and VM 1.1.7 over lamp
Jose Antonio Suarez.
Graphic Designer
Graphic Designer