OpenCart Community

In my error logs I keep getting
PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/www/ronsattic.co.uk/system/database/mysql.php on line 50

Any ideas ?

This happens when?

showing 1 to 2 times a day

That is an issue with your hosting company so you need to contact them. It might be they are resetting the mysql server, though normally that doesn't happen twice a day.

That was my though as had this happen now for the last couple of months but my hosting company after taking this up with them more than a few times say they do not have any problems there end

3 times in error log yesterday showing
PHP Notice: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM `language` WHERE status = '1' in /home/www/ronsattic.co.uk/system/database/mysql.php on line 50

Okay, allow me to tie some things together here, now that I have tardily looked among virtually concurrent ongoing posts in plural threads by one author.

If I understand what I'm seeing, then:

(a) on the one hand, 2013 Mar 18 Mon 3:38 am [pst], at
http://forum.opencart.com/viewtopic.php ... 51#p390852
you have disappearing servers;

(b) on the other hand, 2013 Mar 19 Tue 5:18 am [pst], at
http://forum.opencart.com/viewtopic.php ... 36#p391150
you have disappearing Products;

(c) and those were already preceded by disappearing images, ungenerated mail, and a carnivorous sandbox.
[edit, dated crossferernces added:]
2012 Feb 28 Tue 3:53 pm pst at
http://forum.opencart.com/viewtopic.php?f=161&t=54638
2013 Mar 13 Wed 6:23 am pst at
http://forum.opencart.com/viewtopic.php ... 31#p389638
2013 Mar 13 Wed 8:43 am pst at
http://forum.opencart.com/viewtopic.php ... 51#p389672

Accordingly, you've already splintered an array of problems (they are not "issues") concerning one failing OC installation on one failing server where either or both of the OC installation (not OC itself) and server is or are somehow even inherently dysfunctional. At this juncture I would guess that it's both, and that not one of those problems reflects a "bug" of any sort, kind, type, degree, or extent in OC itself.

On disappearing servers, the entire server seems to be bogged down, perhaps by too many server customers on too few drives or whatever, so see the relevant part of this:
http://forum.opencart.com/viewtopic.php ... 20#p391324
which is relevant to two differing contexts between
http://forum.opencart.com/viewtopic.php?f=19&t=97520 (server momentarily flooded)
and
http://forum.opencart.com/viewtopic.php?f=161&t=97986 (server flooded and bubbling bubbles).

Then either issue the commands yourself or ask the server staff to issue the commands, or, from what appears probably insurmountable, find a new server, the one you're trying to use is floodable and flooded.

On disappearing Products themselves and product images, and on ungenerated mail, those evidently owe in no small part to the server.

On the carnivorous sandbox, never mind, test for real, the Sandbox doesn't work, never did, never will.

On PayPal processing, tying to it is very often not particularly easy to make settle down completely, and you must make certain that all of these jibe perfectly (that means proofread everything; several times; BECAUSE you are dealing with machine-readable syntax and punctuation, which if wrong will cause your server or PayPal's server or both to dump a nullity right on the spot): (a) your very type of PayPal account; (b) your PayPal account settings; (c) all of your cart settings (no matter which cart software), here including (d) your OC's own usually version-specific .php files for PayPal, and (e) your OC admin panel's settings for those .php files and PayPal alternatives.

At the moment (right now), your http://http://www.ronsattic.co.uk/ won't even load.

it is down to your host to set the number of concurrent connections to the db. these connections should be dropped automatically when a certain number has been reached. opencart is set to drop the connection after each page load but that setting is still dependent if your host allows this.

this is completely out of opencarts hands!this is a setting that needs to be changed on your host! if your on shared hosting it might be some one elses site that causing the issue.

last time i had this issue i had to move to a dedicated server because the number of people hitting my site in 1 hour went above 1,500

do not post this crap here again! we can not help you! your hosting is the issue!

Thank you. Request lock.

Hello, I know this was a while ago but i just ran into the same issue and I contacted my hosting provider and the increased 'wait_timeout' for Mysql. It seems to have fixed the issue and I am no longer getting the errors.

I hope this helps someone else who stumbles across this thread.