Page 3 of 3

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Thu Sep 29, 2011 4:27 pm
by nebyl
ATek wrote:nebyl - You rock!
can you say it one more time? :D
Happy to help ;)

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Thu Sep 29, 2011 10:29 pm
by om1985
nebyl wrote:
ATek wrote:nebyl - You rock!
can you say it one more time? :D
Happy to help ;)

Lol a :geek: fledgling little joomla master huh! lmfao. awesome dude, but haven't tried this out yet lol, as I haven't come across the error yet during this new install :)

www.oryanm.com

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Tue Oct 04, 2011 1:55 pm
by beneath
I spent 3 hours today bumping my head against the wall because i couldnt find any solution for this and if you google it you get lot of discussions about it. Many of you mentioned lot of different ways to fix this but most of them pointed to some database issues, and i was sure it wasnt any database issue because i didnt do any migrations or antyhing else (importing). Anyways what happened to me was:

user tries to register, he gets message: E_NOLOGIN_ACCESS
all the users that were registered before were still able to login.
i had no problems logging in as admin/superadmin to front or backend.

Problem was solved through settings in virtuemart permission modules. I cant even remember i messed up with 'em, but as soon as default values were back on, that E_NOLOGIN_ACCESS wasn't seen again :)

Hope this will help someone.

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Fri Oct 21, 2011 7:59 am
by spartan0311mp
I tried this and I am still getting the E_NOGLOGIN_ACCESS. I placed it at the end of the function and got an error, so I placed it directly under the

Code: Select all

	
function register_save()
{
lines and I was able to successfuly register a user, and activate the account, but on log in, the error returned. Am I missing something because of the new 1.5.24 update?

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Sun Oct 23, 2011 10:09 pm
by spartan0311mp
Anyone?

I have the debug info, but I don't know what I am looking at. This is killing business, gotta figure something out here, and soon :(

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Mon Oct 24, 2011 1:32 pm
by dpacadmin
Try disabling extensions and then test to see if it was the cause, I would start with joomlawatch.

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Mon Oct 24, 2011 3:52 pm
by spartan0311mp
will do, already started that process. thank you!

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Mon Oct 24, 2011 4:18 pm
by spartan0311mp
Found the culprit (well, so far anyway!)! System Plugin - EasyCalcCheck PLUS. I was using it to protect the back end with a token, and place a Captcha on the registration page. Looks like I will need to figure something else out with that.

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Sun Dec 11, 2011 8:23 pm
by bassy_beats
I am getting this same issue. When i order all jos_user by user type there is alot of them that have no usertype. I assume this is not normal.

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Tue Mar 13, 2012 1:35 am
by jagaa666
I fix this.

My base is corrupt. So my process:

1. Go to phpmyadmin
2. SQL (REPAIR TABLE `jos_core_acl_groups_aro_map` )

This table is corrupt. And my problem is fixed.

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Mon Jul 16, 2012 11:51 pm
by muskiediver
I have read through everything here, tried some things. But nothing seems to work for my specific issue. I am providing debug code in this post.

I and my users were getting this error when they tried to login:

Message
Error
• E_NOLOGIN_ACCESS

So I upgraded from Version 1.5.25 to Version 1.5.26

Login to back end (using admin2)

I turned on debug system

Log out of backend

go to home page.

Login with myusername, and get this:

Message
Error
• E_NOLOGIN_ACCESS
• E_NOLOGIN_ACCESS

Error message at bottom of page:

Code: Select all

Profile Information
Application afterLoad: 0.000 seconds, 0.23 MB
Application afterInitialise: 0.082 seconds, 4.19 MB
Application afterRoute: 0.097 seconds, 4.85 MB
Application afterDispatch: 0.149 seconds, 7.32 MB
Application afterRender: 0.281 seconds, 13.24 MB
Memory Usage
13967244
37 queries logged
1.	SELECT * 
  FROM jos_session 
  WHERE session_id = 'e10592a543ebeb836cc7c5a95e0424a8'
2.	DELETE 
  FROM jos_session 
  WHERE ( TIME < '1342481268' )
3.	SELECT * 
  FROM jos_session 
  WHERE session_id = 'e10592a543ebeb836cc7c5a95e0424a8'
4.	UPDATE `jos_session` 
  SET `time`='1342482168',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:10:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1342482146;s:18:\"session.timer.last\";i:1342482154;s:17:\"session.timer.now\";i:1342482168;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:13.0) Gecko/20100101 Firefox/13.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:78:\"/home/myserverdir/public_html/mysite/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:16:\"com_mailto.links\";a:2:{s:40:\"80de077c07eb27ff2d8530840432d70d637894f4\";O:8:\"stdClass\":2:{s:4:\"link\";s:162:\"http://www.mysite.com/index.php?option=com_content&view=article&id=73: -natural-body-care-by-native-american-wisdom&catid=25:the-project&Itemid=66\";s:6:\"expiry\";i:1342482146;}s:40:\"9a058fb095eb9d93c2c31f2a842a9f57178711d3\";O:8:\"stdClass\":2:{s:4:\"link\";s:114:\"http://www.mysite.com/index.php?option=com_content&view=article&id=74:about-us&catid=25:the-project&Itemid=67\";s:6:\"expiry\";i:1342482154;}}s:13:\"session.token\";s:32:\"5dd24fa339ade88efb9e4befcdbebf94\";s:17:\"application.queue\";a:2:{i:0;a:2:{s:7:\"message\";N;s:4:\"type\";s:7:\"message\";}i:1;a:2:{s:7:\"message\";s:16:\"E_NOLOGIN_ACCESS\";s:4:\"type\";s:5:\"error\";}}}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"6.00\";vendor_currency|s:3:\"USD\";vmUseGreyBox|s:1:\"0\";vmCartDirection|s:1:\"0\";vmMiniCart|b:0;' 
  WHERE session_id='e10592a543ebeb836cc7c5a95e0424a8'
5.	SELECT * 
  FROM jos_components 
  WHERE parent = 0
6.	SELECT folder AS TYPE, element AS name, params 
  FROM jos_plugins 
  WHERE published >= 1 
  AND access <= 0 
  ORDER BY ordering
7.	CREATE TABLE IF NOT EXISTS `jos_ualog` (
          `id` INT(11) NOT NULL AUTO_INCREMENT,
          `user_id` INT(11) NOT NULL,
          `option` VARCHAR(255) NOT NULL,
          `task` VARCHAR(255) NOT NULL,
          `action_link` text NOT NULL,
          `action_title` text NOT NULL,
          `item_title` VARCHAR(255) NOT NULL,
          `cdate` INT(11) NOT NULL,
          PRIMARY KEY  (`id`))
8.	SELECT id, parent_id, VALUE, name, lft, rgt 
  FROM jos_core_acl_aro_groups 
  WHERE id=23
9.	SELECT name,player_id,ripper_id,postreplace 
  FROM jos_avr_tags
10.	SELECT name,player_id,ripper_id,postreplace 
  FROM jos_avr_tags
11.	SELECT id, gid 
  FROM jos_users 
  WHERE username='Myusername'
12.	SELECT `id`, `password`, `gid` 
  FROM `jos_users` 
  WHERE username='Myusername'
13.	SELECT * 
  FROM jos_users 
  WHERE id = '42'
14.	DELETE 
  FROM jos_session 
  WHERE ( TIME < '1342481268' )
15.	SELECT * 
  FROM jos_session 
  WHERE session_id = '6c9c6f3b6138544ac97616fe868a42fd'
16.	INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) 
  VALUES ( '6c9c6f3b6138544ac97616fe868a42fd','1342482168','','0','1','0' )
17.	SELECT id 
  FROM jos_users 
  WHERE username = 'Myusername' 
  LIMIT 0, 1
18.	SELECT * 
  FROM jos_users 
  WHERE id = '42'
19.	SELECT g.* 
  FROM jos_core_acl_aro_groups AS g 
  INNER JOIN jos_core_acl_groups_aro_map AS gm 
  ON gm.group_id = g.id 
  INNER JOIN jos_core_acl_aro AS ao 
  ON ao.id = gm.aro_id 
  WHERE ao.VALUE='42' 
  ORDER BY g.id
20.	SELECT COUNT(*) 
  FROM jos_core_acl_aro_groups AS g1 
  LEFT JOIN jos_core_acl_aro_groups AS g2 
  ON (g1.lft > g2.lft 
  AND g1.lft < g2.rgt) 
  WHERE g1.name = '' 
  AND g2.id = 0
21.	SELECT m.*, c.`option` AS component 
  FROM jos_menu AS m 
  LEFT JOIN jos_components AS c 
  ON m.componentid = c.id 
  WHERE m.published = 1 
  ORDER BY m.sublevel, m.parent, m.ordering
22.	SELECT template 
  FROM jos_templates_menu 
  WHERE client_id = 0 
  AND (menuid = 0 OR menuid = 66) 
  ORDER BY menuid DESC 
  LIMIT 0, 1
23.	SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid 
  LEFT JOIN jos_sections AS s 
  ON s.id = cc.SECTION 
  AND s.scope = "content" 
  LEFT JOIN jos_users AS u 
  ON u.id = a.created_by 
  LEFT JOIN jos_groups AS g 
  ON a.access = g.id 
  WHERE a.id = 73 
  AND (  ( a.created_by = 0 )    OR  ( a.state = 1 
  AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-07-16 23:42:48' ) 
  AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-07-16 23:42:48' )   )    OR  ( a.state = -1 )  )
24.	UPDATE jos_content 
  SET hits = ( hits + 1 ) 
  WHERE id='73'
25.	SELECT g.* 
  FROM jos_core_acl_aro_groups AS g 
  INNER JOIN jos_core_acl_groups_aro_map AS gm 
  ON gm.group_id = g.id 
  INNER JOIN jos_core_acl_aro AS ao 
  ON ao.id = gm.aro_id 
  WHERE ao.VALUE='62' 
  ORDER BY g.id
26.	SELECT id, title, module, POSITION, content, showtitle, control, params 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.published = 1 
  AND m.access <= 0 
  AND m.client_id = 0 
  AND ( mm.menuid = 66 OR mm.menuid = 0 ) 
  ORDER BY POSITION, ordering
27.	SELECT group_id,group_name,group_level 
  FROM `jos_vm_auth_group` 
  ORDER BY group_level
28.	SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount 
                
  FROM `jos_vm_shopper_group` 
  WHERE jos_vm_shopper_group.vendor_id='1' 
  AND `default`='1'
29.	SELECT `name` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `id` =29
30.	SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                        vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
                                        vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
                                        vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                
  FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                
  LEFT JOIN jos_vm_state s 
  ON (v.vendor_state=s.state_2_code 
  AND s.country_id=c.country_id)
                                
  WHERE `v`.`vendor_id`=1
                                
  AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
31.	SELECT id, params 
  FROM jos_menu 
  WHERE link='index.php?option=com_virtuemart' 
  AND published=1
32.	SELECT id 
  FROM jos_menu 
  WHERE link='index.php?option=com_virtuemart' 
  AND published=1
33.	SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                
  FROM jos_vm_category, jos_vm_category_xref 
  WHERE jos_vm_category.category_publish='Y' 
  AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id 
  ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
34.	SELECT group_id,group_name,group_level 
  FROM `jos_vm_auth_group` 
  ORDER BY group_level
35.	SELECT published 
  FROM jos_modules 
  WHERE module='mod_virtuemart_cart'
36.	SELECT m.* 
  FROM jos_menu AS m 
  WHERE menutype='topmenu' 
  AND published = 1 
  AND access <= 0 
  ORDER BY ordering
37.	SELECT catid 
  FROM jos_content 
  WHERE id = 73
4 legacy queries logged
1.	SELECT `lft`, `rgt` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `name`='Public Frontend'
2.	SELECT g1.id, g1.name, COUNT(g2.name) AS level

  FROM jos_core_acl_aro_groups AS g1

  INNER JOIN jos_core_acl_aro_groups AS g2 
  ON g1.lft BETWEEN g2.lft 
  AND g2.rgt

  WHERE g1.lft BETWEEN 3 
  AND 12

  GROUP BY g1.name

  ORDER BY g1.lft
3.	SELECT `lft`, `rgt` 
  FROM `jos_core_acl_aro_groups` 
  WHERE `name`='Public Backend'
4.	SELECT g1.id, g1.name, COUNT(g2.name) AS level

  FROM jos_core_acl_aro_groups AS g1

  INNER JOIN jos_core_acl_aro_groups AS g2 
  ON g1.lft BETWEEN g2.lft 
  AND g2.rgt

  WHERE g1.lft BETWEEN 13 
  AND 20

  GROUP BY g1.name

  ORDER BY g1.lft
Language Files Loaded
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.ini 1
•	/home/myserverdir/public_html/mysite/administrator/language/en-GB/en-GB.plg_system_modulesanywhere.ini 1
•	/home/myserverdir/public_html/mysite/administrator/language/en-GB/en-GB.plg_content_avreloaded.ini 1
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.plg_system_debug.ini 1
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.com_content.ini 1
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.plg_content_pagebreak.ini 1
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.tpl_natura_plazza.ini 
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_mainmenu.ini 1
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_virtuemart_cart.ini 
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_virtuemart.ini 
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_virtuemart_login.ini 
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_mailchimp.ini 1
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_smoothgallery.ini 1
•	/home/myserverdir/public_html/mysite/language/en-GB/en-GB.mod_exmenu-j15.ini 
Untranslated Strings Diagnostic
None
Untranslated Strings Designer
None
What exactly do I need to do to fix this please?

Thanks in advance.

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Tue Jul 17, 2012 10:40 pm
by dpacadmin
Are you using the Joomla login or an added extension's login? Are you using a security extension that may be effecting the login? I find that if I log out and try to log back in, in the same browser session, that I sometimes have issues, usually just retrying the login fixes it.

Try flushing the Joomla cache and do a check-in. Try deleting your browser's temp Internet files and any cookies from your site. Try running the Post Assistant on your site to see if it finds any issues with your server, post back the results.

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Mon Dec 10, 2012 7:20 am
by swese44
thefaro wrote:OK guys, I think I found the solution for everyone's issue here in this thread. I have just fixed my database. Follow these simple steps and everything should be back to normal.

Note: You must have your users in the jos_users table in order to fix the issue. If you have lost your users entirely within the (jos_users table) SQL, this will not help you.

Step 1 - Back up the following SQL tables:
jos_users
jos_core_acl_aro
jos_core_acl_aro_groups
jos_core_acl_aro_map
jos_core_acl_aro_sections
jos_core_acl_groups_aro_map

Step 2 - Delete each row in the jos_core_acl_aro table. Do so by scrolling below all of the rows displayed and clicking "Check All" and then the "X" button.

Step 3 - Run the following SQL code in your database by copying/pasting the code in the SQL tab.
Per Yngve Berg wrote:

Code: Select all

insert into  jos_core_acl_aro (section_value, value, name) select 'users', id, name from jos_users; 
All of your users from jos_users should now appear in the jos_core_acl_aro table.

Step 4 - Delete each row in the jos_core_acl_groups_aro_map table. Do so by scrolling below all of the rows displayed and clicking "Check All" and then the "X" button.

Step 5 - Run the following SQL code in your database by copying/pasting the code in the SQL tab.
Per Yngve Berg wrote:

Code: Select all

insert into  jos_core_acl_groups_aro_map (group_id, aro_id) select '18', id from jos_core_acl_aro; 
All of your users from the jos_core_acl_aro table should be synced with the jos_core_acl_groups_aro_map table.

Step 6 - Cry tears of joy.

Now, to grant rights to those who need them, simply access the jos_core_acl_aro_groups table. Take note of the id column. That is the number you will be replacing some group ids with in the jos_core_acl_aro_groups table. Make certain to change the correct user. The aro_id is the same as the id listed in the jos_core_acl_aro table.

Hope this helps a ton (^__^). I know I feel relieved that this nightmare is over for meh.


Thank you! My user tables somehow got corrupted on a Joomla 1.5 site with almost 70,000 users. This process sorted it out.

If anybody else has this problem, you may need to follow the SQL instructions on this page to create a new super administrator user so you can log in and set your previous user account back to super administrator:
http://docs.joomla.org/How_do_you_recov ... n_password

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Thu Aug 25, 2016 9:37 pm
by Nzhome
I finally FIXED it !!! I had this problem many times over the years, I run one of the worlds heaviest sites using joomla. This problem never goes away, I have thousands of users registering every month, and I get at least 1 user a month with this problem.

E_NOLOGIN_ACCESS fix.

missing 18 in the groupid in jos_user
and missing jos_core_acl_groups_aro_map record for same group id, but get the id from jos_core_acl_aro


For creating new user accounts by script you need to execute three queries. If any of these records are missing you get a E_NOLOGIN_ACCESS error.

1) insert into jos_users (id,name,username,email,password,usertype,block,sendEmail,gid,registerDate,lastvisitDate) values (NULL,'name','username','email','password','Registered','0','0','18','date','date2')

2) insert into jos_core_acl_aro (id,section_value,value,name) values (NULL, 'users', '(insertid of the above query)', 'name')

3) insert into jos_core_acl_groups_aro_map (group_id,section_value,aro_id) values (18, '', '(insertid of the above query)')

Re: E_NOLOGIN_ACCESS for login after 1.0.12 to 1.5 Stable

Posted: Mon Dec 19, 2016 10:43 am
by Glory66
I just had this issue as well. I am planning on doing a migration for a client, so I decided to do a test run on my localhost (with fresh 1.0 and 1.5 installs) today and see how difficult it would really be. I was FINALLY successful with my admin login after an hour of ripping my hair out.