E_NOLOGIN_ACCESS and only first 20 users show in backend

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
hosstapio
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Mon Aug 23, 2010 6:59 am

E_NOLOGIN_ACCESS and only first 20 users show in backend

Post by hosstapio » Mon Aug 23, 2010 7:09 am

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?

User avatar
pe7er
Joomla! Master
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

Post by pe7er » Mon Aug 23, 2010 7:39 am

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
Kind Regards,
Peter Martin, Global Moderator
Company website: https://db8.nl/en/ - Joomla specialist, Nijmegen, Netherlands
The best website: https://the-best-website.com

hosstapio
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Mon Aug 23, 2010 6:59 am

Re: E_NOLOGIN_ACCESS and only first 20 users show in backend

Post by hosstapio » Mon Aug 23, 2010 8:12 am

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'

User avatar
pe7er
Joomla! Master
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

Post by pe7er » Mon Aug 23, 2010 8:31 am

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:

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

hosstapio
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Mon Aug 23, 2010 6:59 am

Re: E_NOLOGIN_ACCESS and only first 20 users show in backend

Post by hosstapio » Mon Aug 23, 2010 8:52 am

Thanks. That did the job.

quebecguitare
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Wed Apr 08, 2009 3:56 am

Re: E_NOLOGIN_ACCESS and only first 20 users show in backend

Post by quebecguitare » Mon Feb 28, 2011 6:11 pm

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:

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;
I suspect the column are not named the same on my joomla version.
Please help.

Regards,
Alex

User avatar
linkedla
Joomla! Apprentice
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

Post by linkedla » Thu Mar 10, 2011 4:44 am

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
Jose Antonio Suarez.
Graphic Designer


Locked

Return to “Migrating and Upgrading to Joomla! 1.5”