Hello,
I'm running the latest version of OpenCart and am running into an error in my logs that occurs far to often. I need to get this resolved because I believe it is showing this error to the end users on a regular basis.
The log is filled with these:
2012-02-22 13:11:52 - PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM language in /home/content/92/8744092/html/system/database/mysql.php on line 49
I have read where I needed to increase the value for mysql.connect_timeout in my php.ini file. I have tried increasing this value all the way to 400 and I still get this error. I have contacted my hosting company (Unfortunately GoDaddy) and they have not been of much assistance.
Any guidance is much appreciated.
Thanks!
Hopefully I won't be teaching you to suck eggs here, but have you tried deploying another, test version of opencart and trying to replicate the error by incrementally installing your various extensions one by one to isolate the issue?
Might help you narrow down where the problem is and aid in your getting assistance?
Just a thought,
Cheers
Might help you narrow down where the problem is and aid in your getting assistance?
Just a thought,
Cheers
Well I have an exact replica of the site running on a development server (WAMP on a home server) and I don't appear to have any issues here. The thing is though, there obviously isn't any traffic on this server, and it appears that this error occurs only when there is site traffic. So, I can test it, but I don't believe the error will occur on the test site.
Also, I am running 25 vQmods, so testing those indivdually will be a nightmare. I will not be able to test on the live site as we cannot take it offline.
I believe I have narrowed the issue down to GoDaddy, but I am not 100% sure and they are no help.
Thanks!
Also, I am running 25 vQmods, so testing those indivdually will be a nightmare. I will not be able to test on the live site as we cannot take it offline.
I believe I have narrowed the issue down to GoDaddy, but I am not 100% sure and they are no help.
Thanks!
GoDaddy actually changed the mysql.connect_timeout value for me from 20 to 40 while I was waiting on hold. It's at 400 now, and I get the error.
Google Sitemap feed is disabled under extensions -> product feeds. This is what you are referring too, correct?
Thanks!
Google Sitemap feed is disabled under extensions -> product feeds. This is what you are referring too, correct?
Thanks!
That's correct. I've seen it cause issues even on good servers. GoDaddy doesn't have a great reputation so it could be other issues too. If disabling the product feed doesn't work see if they provide mysql_slow_queries logs for your account.ktriggs wrote:Google Sitemap feed is disabled under extensions -> product feeds. This is what you are referring too, correct?
-Ryan
I contacted GoDaddy, and they were once again not much help. I do not have access to the mysql_slow_queries logs because I use Shared Hosting (Big mistake, I know). When first implementing this site it was discussed and currently we only get around 5 orders a week MAX, so we figured shared hosting would be fine.
Now, the GoDaddy tech was trying to blame it on the OpenCart code saying it's possible that MySQL connections are being left open, thus reaching the 200 connection limit on the shared hosting. I'm almost to the point where I need to upgrade to a VPS, but I am not sure it will correct my issues. I would have as many MySQL connections as the server can handle rather than be limited to 200 connections with the shared hosting. Thoughts?
Thanks for all of your help so far rph! Nebraskans are one of a kind
Now, the GoDaddy tech was trying to blame it on the OpenCart code saying it's possible that MySQL connections are being left open, thus reaching the 200 connection limit on the shared hosting. I'm almost to the point where I need to upgrade to a VPS, but I am not sure it will correct my issues. I would have as many MySQL connections as the server can handle rather than be limited to 200 connections with the shared hosting. Thoughts?
Thanks for all of your help so far rph! Nebraskans are one of a kind
Most sites that I have seen on godaddy just don't work, they seem ok for a few static pages but if you want to do anything more then forget it. If it is only a small site it should be absolutely fine on shared hosting, but it needs to be a decent service. Before going down the VPS route I would move to a decent host with shared hosting that are able to offer an easy upgrade to VPS if you find you need it.
-
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS
I currently have some of my demo stores on Vidahost and they work quite well (Even installed Magento on there and it positively flew along) and they are very helpful to, but they are UK based.
If you need US based severs then I can't really help, you can try searcing the forum as it is a question that has been asked/answered a few times.
If you need US based severs then I can't really help, you can try searcing the forum as it is a question that has been asked/answered a few times.
-
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS
The problem with GoDaddy is that their mysql databases are not on the same server as the web hosting. In fact, some of their database servers are not even in the same continent (new databases now get created in Australia!). One rule that applies to any eCommerce setup is that it is vital that mysql is on the same server. You will see this a "localhost" in the address details.
I set up opencart originally on Godaddy and before adding any content at-all I was experiencing a wait of up to 30 seconds per page. I switched to Hostpapa, which uses localhost, and the pages now come up instantly.
It's the location of the database that is the killer. An eCommerce system makes many many more database calls than a normal website, and if it has to connect externally each time you will just get bottlenecks and time-outs.
Whichever host you switch to, just make sure it uses localhost before you sign up. Often you can find out by searching their forums for info.
I set up opencart originally on Godaddy and before adding any content at-all I was experiencing a wait of up to 30 seconds per page. I switched to Hostpapa, which uses localhost, and the pages now come up instantly.
It's the location of the database that is the killer. An eCommerce system makes many many more database calls than a normal website, and if it has to connect externally each time you will just get bottlenecks and time-outs.
Whichever host you switch to, just make sure it uses localhost before you sign up. Often you can find out by searching their forums for info.
Shared hosts can still be set up in such a way that you'll get slow query logs. Usually they're in a /tmp folder at the base of your account. It sounds like GoDaddy is just blaming the victim though. I really haven't heard many good things about them.ktriggs wrote:I contacted GoDaddy, and they were once again not much help. I do not have access to the mysql_slow_queries logs because I use Shared Hosting (Big mistake, I know).
-Ryan
I'm also facing the same problem.
I am also using a shared hosting in GoDaddy.
It occurs at least 20-25 times in a day.
Edit:
I disabled the sitemap. I hope this solves my problem.
I am also using a shared hosting in GoDaddy.
It occurs at least 20-25 times in a day.
Edit:
I disabled the sitemap. I hope this solves my problem.
Google Base can also cause it, I believe. Google won't try to scan your site that much in one day though (check the error log timestamps to see if they're separate occasions or happening all at once).
-Ryan
Who is online
Users browsing this forum: No registered users and 61 guests
