Thread

This question may be related to a resolved thread.

Hi all,

I’ve noticed a lot of posts about this but non seem to be exactly the same. This issue has just come out of the blue.

EE v2.1.3 Build: 20101220 - I haven’t upgraded/updated at all recently

PHP 5.2.17 (which I noticed was the version of php that people had issues following an update to Media Temples Grid service)

Not using MSM

Symptoms

Page just hangs when trying to login to admin account (other accounts work fine)

Fixes tried

Config.php changes found here (cleared all browser caches etc etc)
I have contacted the hosting company (not Media Temple by the way) and apparently they have made no changes to the server environment apart from upgrading cPanel

I haven’t tried upgrade EE yet, I wanted to hold off as I noticed some people were getting this issue as a result of updating.

Any ideas?

hi TheBlackHole,

Page just hangs when trying to login to admin account (other accounts work fine)

To confirm. The page doesn’t refresh or return a blank page?

Do you have any add-ons installed. Like NSM updater?

Have you tried a different browser?

Hi John,

No, literally nothing happens. However, when I go to the front end of the site it says I’m logged in. I tried numerous browsers to no avail.

I downloaded the full site and managed to get logged in on a local copy after a few minutes of hanging. Each page load once logged in took a few minutes to load. I disabled NSM Addon updater and the CP was fine. I had an issue on another site where NSM addon updater was making the CP really slow (which apparently can be a ‘bad’ cache file but I had deleted them all) but never caused a login issue. I am on with the Newism guys at the moment, as I’m finding the addon updater unusable.

What made you mention Addon updater? Has this caused similar issues?

Cheers

The live site still has the issue, keep getting this error sometimes…

A Database Error Occurred
Error Number: 2006

MySQL server has gone away

SELECT LOWER(module_name) AS name FROM (`exp_modules`) ORDER BY `module_name`

Filename: libraries/Cp.php

Line Number: 822

The mysql error means you’ve lost the connection with your database.  i.e., the db went down.  It’s not entirely impossible connections stacked up while waiting for the login process to clear.  But mostly it just means your db went down.

And if superadmins and only superadmins are getting really slow page loads across the board in the CP?  It is really likely due to an add-on trying to check back home for a version update.  I’ve seen it go away after removing html_strop plugin and disabling NSM updater plugin is definitely a good first step.  But basically- any addon that makes a call back for version info could be causing it.

What happens- it makes the call off site ‘What’s the latest version’- the site it calls to is down/no longer exist/whatever.  It never responds.  The check sits there waiting for a response that’s never going to come.  It will eventually time out and hopefully continue on its way.  But yes- the result is very slow loading.  (Note- probably w/caching could also cause this if it’s having trouble making/clearing the cached version info.)

Which is a long way of saying- if it’s all over the CP and it’s only the superadmins?  Start looking at third party add-ons that may be doing version checks by pinging off site.  Updating is a good idea- but unlikely to have any effect on this one way or another- it’s third party code doing the checks.

That help narrow things down and get the slowdown resolved?

Thanks Robin,

Managed to isolate it to NSM Addon updater. Looks like a lot of people are having this issue from what I can see.

I’ve spoke to NSM and they have recommend disabling it full stop till the next release.

The following SQL statement should remove the accessory if you are unable to access the CP, (you may need to adjust the query if your table prefix is different to the standard ‘exp_’).

As with anything of this nature make sure you back up your database before trying it

DELETE FROM `exp_accessories` WHERE `class` = 'Nsm_addon_updater_acc' LIMIT 1

Cheers

Thanks for the confirmation and details, TheBlackHole.  And gave the crew a ‘heads up’ on looking for that addon first.  Also- appreciate the sql!

Run into any other issues, just let us know.