Admin area login times out and causes a max connection error that kills both sides of the site.

[wildvettes]

I was in today and created a sale. I went back to edit the sale and it just kept trying to load, load, load. Then I get this message.

 

Warning: mysqli_connect() [function.mysqli-connect]: (42000/1203): User wildvettes already has more than 'max_user_connections' active connections in /hermes/bosoraweb076/b2864/ipg.wvperformancecom/catalog/includes/functions/database.php on line 20
Unable to connect to database server!

 

The home page loads extremely quickly, and if you click on anything else it takes forever to load.

 

I get the same error on the admin side. The following error has also started popping up in my listings at the very bottom.

 

 

Warning: fread() [function.fread]: Length parameter must be greater than 0 in /hermes/bosoraweb076/b2864/ipg.wvperformancecom/catalog/includes/functions/cache.php on line 60

 

 

 

I haven't added any add-ons. No new settings or products. I unfortunately don't have a recent backup of my database and my site. If I load the old one I will lose about 20 hours of product loading. 

 

 

I have the cache enabled but cannot access the admin area to try turning it off. I have also been unable to locate where the cache is by default. I know it is some tmp file, but can't find it. Could this all be a cache error?

 

 

 

 

 

My host responded with this. 

 

I have tried accessing the website and currently it is working fine. A script is not closing the MySQL connection after accessing the database. Please make sure that you close the connection immediately after accessing the database using mysql_close() command from your scripts. This should resolve the issue and the website should work fine. 

We are in the process of updating the PHP version. In the latest version, some functions such as MySQLi are not supported which is the reason you are seeing the warning message. Once the PHP version update is completed on our servers, the functions such as MySQLi should work. Until that, I suggest that you use PHP version 5.3 or 5.2 so that website works fine. You can change PHP version at: https://www.ipage.com/controlpanel/cgiManagement/phpplus.html. 

If you have any further questions, please update the Support Console. 

 

 

 

 

I tried PHP 5.2 and 5.3 and got exactly the same results. Is this an issue with a virus? A host issue? I just don't see how the site could just randomly break. My last 2.2 store broke the same way too without warning and I had to start all over because I couldn't figure out what was broken and restoring from backups didn't fix the issue.

 

Can a host server upgrade break my site?

[wildvettes]

I don't know if this is related or not, but it was definitely weird. Randomly when accessing my FTP I found my admin and site Application_top had the permissions changed from 644 to 411.

[Jack_mcs]

To answer your last question first, yes, an update on the server can definitely break your shop. You don't mention the version of oscommerce you are using so that leaves a gray area in the answer. But this problem can be caused by a number of things. The max connections error is saying the servers connection limit is being reached.

 

First check the configure file for admin and make sure the STORE_SESSIONS setting is set to MySQL. If the problem is still there and is not constant, then it is probably a problem with data skimmers hitting the site. By constant, I mean can't get into admin now but you can six hours from now.

 

The next thing to do is to edit the database in your control panel and turn of the cache, gzip and cookies options in the configuration table. If you are not sure of your shops version be sure you are using php 5.3.