Support

Admin Tools

#17091 Other users can't log in . . . 500 - An error has occurred

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Wednesday, 14 August 2013 10:34 CDT

nukemedia
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? YES
Have I searched the tickets before posting? YES
Have I read the documentation before posting (which pages?)? Lots!!
Joomla! version: 2.5.14
PHP version: 5.3.2
MySQL version: 5.1.41-3ubuntu12.10
Host: http://newcentcorp.onlinedemosite.co.uk
Admin Tools version: 2.5.6

Description of my issue:

Hi, my original superuser logs in without issue, however, any other users give me this error:

500 - An error has occurred

My client needs to make changes to the site, I haven't been able to resolve this problem, it makes no difference if I make them a superuser, I have also reverted my .htaccess and changed my WAF Configuration. Disabled editing backend users' properties option and set it to No.

Really stuck, help appreciated!

Mat.

nicholas
Akeeba Staff
Manager
Let's make sure that the problem is indeed caused by Admin Tools. In order to do so, try the following:

1. Try setting the Error Reporting level in your Global Configuration to "None". Many errors are caused by harmless PHP Notices and Warnings being output to the browser, breaking anything which requires HTTP header manipulation such as Joomla!'s session management, AJAX calls and download systems.

2. Try to replicate the issue after disabling the "System - Admin Tools" plugin. If you can still replicate the issue, it is not caused by Admin Tools. Disabling that plugin means that Admin Tools code (including the Web Application Firewall) is not running on your site.

3. If you suspect an issue with the .htaccess file, replace its contents with the contents of the stock htaccess.txt file shipped with every version of Joomla!. If you are on GoDaddy please wait for 1-30 minutes for the changes to be effective. Then, retry loading the problem page. If you can still reproduce the error, then it is not caused by .htaccess Maker.

If doing any of the above resulted in the issue still occurring, it's not related with Admin Tools and I can't help you. If doing any of the above did stop the issue from occurring, we'll have to do some troubleshooting.

First go to Admin Tools, Web Application Firewall, Configure WAF. Make sure "Log security exceptions" is set to Yes; if it's not, set it to Yes and click on Save. Now try reproducing your issue. Immediately after that, please go to Admin Tools, Web Application Firewall, Security Exceptions Log and go to the last page. The last log entry should have the date and time of when the issue occurred. Please copy the Reason and Target URL here so that I can help you.

If, however, you do not see a log entry, or the Date and/or IP address do not match your last access, this problem is not caused by Admin Tools' WAF. In this case, you will have to do some .htaccess troubleshooting. You may need to read the general .htaccess troubleshooting page, as well as the page on finding out necessary .htaccess exceptions.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

nukemedia
Thanks, I'll go through these to try and work it out, great response!

nukemedia
OK, I did all of that and it didn't work, so I guess it's not Akeeba tools... If you have any ideas I'd appreciate your expert input but I understand that it's not really your problem...

Thanks again,

Mat.

nukemedia
Seems I can make new superusers and that works, but managers etc don't.... odd

nicholas
Akeeba Staff
Manager
Did you recently upgrade from Joomla! 2.5.11 or earlier to 2.5.14?

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

nukemedia
Yes . . .

nicholas
Akeeba Staff
Manager
All right, join the club. There is an issue that happens when your #__assets table is broken. Due to a bug in Joomla! up to 2.5.13 your site would load even with a broken #__assets table. That bug also caused a huge performance issue so it was fixed. And that's when sites with broken #__assets table stopped working properly. I've been there, our site was one of the affected :(

Temporary solution: edit the #__assets table, find the Root Asset node and set lft=0 (now it's lft=1).

Proper solution: subscribe to ACLManager.net and use ACL Manager to fix your assets table. If that doesn't work Sander will provide you with support in fixing any remaining issues with your assets table.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

nukemedia
Wow, thanks for your help! Is there any problem with using the temporary solution? i.e. security?

nicholas
Akeeba Staff
Manager
Even though I have not found any issues with the temporary solution I am aware that it's fixing the symptoms, not the problem. I cannot guarantee that it doesn't cause some unforeseen issue with a future version of Joomla!.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

nukemedia
OK, well I appreciate the help, big fan of the Akeeba tools by the way so I'll always be a customer!

Thanks a lot.

Mat.

nicholas
Akeeba Staff
Manager
You're welcome!

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!