fancydressqueen Posted July 19, 2011 Share Posted July 19, 2011 I just tried to load my website http://www.otleyrunfancydress.co.uk and got the following error:Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/*****/public_html/classes/MySQL.php on line 34Link to database cannot be established.I have replaced **** where my home directory is.Any ideas how I fix it please? Link to comment Share on other sites More sharing options...
tomerg3 Posted July 19, 2011 Share Posted July 19, 2011 Looks like you host may restrict the number of concurrent connections the site can open to the database.What version of PS are you using (ALWAYS START A POST WITH THIS)Was it working fine before?Are you getting many visitors to the site/?Did you check with your host about this? Link to comment Share on other sites More sharing options...
fancydressqueen Posted July 19, 2011 Author Share Posted July 19, 2011 Sorry, im using PS version 1.4.3It worked fine till about an hour ago.I am in contact with my host now but they are taking their time responding, though someone else on here might have had the same issue. Link to comment Share on other sites More sharing options...
tomerg3 Posted July 19, 2011 Share Posted July 19, 2011 Unless you got a real boost in traffic, or installed a 3rd party module in the last hour, I would say it's related to your host.If you're on a shared host, someone else may be abusing the database and making it inaccessible to others. 1 Link to comment Share on other sites More sharing options...
fancydressqueen Posted July 19, 2011 Author Share Posted July 19, 2011 Sadly I think neither are the case. Im on a VPN and haven't installed any additional modules in the last few days.I did however click on the carts link under the customers tab and tried to click on the most recent cart (was an unpaid cart that was for a very high value). Could this have triggered something? Can I empty the cart list as it is up to around 15k, which I presume isn't good for my database. Link to comment Share on other sites More sharing options...
tomerg3 Posted July 19, 2011 Share Posted July 19, 2011 that should have nothing to do with this, I would try to get more info from the host. Link to comment Share on other sites More sharing options...
fancydressqueen Posted July 19, 2011 Author Share Posted July 19, 2011 Just waiting for a new response from them now. Usually they are pretty quick, just hope this isn't a bad sign that they can't find a solution. Link to comment Share on other sites More sharing options...
fancydressqueen Posted July 19, 2011 Author Share Posted July 19, 2011 Ive just checked the disk space usage section of my site via cpanel and the /cache section of prestashop is massive. It seems to have happened very recently, could this be an issue?UPDATEJust been updated by my host. They told me that a large amount of requests caused the stopage in service. Here are a few examples of the errors:+--------+-------+-----------+-------------+---------+-------+--------------+------------------------------------------------------------------------------------------------------+| Id | User | Host | db | Command | Time | State | Info || 166099 | **** | localhost | **** | Query | 11106 | Sending data | SELECT MAX(c.`date_add`) AS last_visit FROM `ps_guest` g LEFT JOIN `ps_connections` c ON c.id_gu || 166124 | **** | localhost | **** | Query | 11027 | Locked | UPDATE `ps_guest` SET `id_operating_system` = '2',`id_web_browser` = '0',`id_customer` = '0',`javasc || 166130 | **** | localhost | **** | Query | 10996 | Locked | INSERT INTO `ps_guest` (`id_operating_system`,`id_web_browser`,`id_customer`,`javascript`,`screen_re || 166148 | **** | localhost | **** | Query | 10874 | Locked | INSERT INTO `ps_guest` (`id_operating_system`,`id_web_browser`,`id_customer`,`javascript`,`screen_re || 166160 | **** | localhost | **** | Query | 10818 | Locked | INSERT INTO `ps_guest` (`id_operating_system`,`id_web_browser`,`id_customer`,`javascript`,`screen_re || 166169 | **** | localhost | **** | Query | 10778 | Locked | INSERT INTO `ps_guest` (`id_operating_system`,`id_web_browser`,`id_customer`,`javascript`,`screen_re |I have edited out the user and database names with ***'s.Also they have confirmed that my '/home/****/public_html/cache/cachefs/’ directory has increased in size to 7.2 gig. Can anyone recommend what can be deleted to drastically lower that number please.Thank you. Link to comment Share on other sites More sharing options...
tomerg3 Posted July 19, 2011 Share Posted July 19, 2011 That's the connections database, data gets inserted there when a new visitors comes to the site, it's possible that someone if accessing your site repeatedly which is causing the overload. Link to comment Share on other sites More sharing options...
fancydressqueen Posted July 20, 2011 Author Share Posted July 20, 2011 Any ideas how I safely empty the cache folder without destroying my website please? Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts