Post by ronsattic » Mon Mar 18, 2013 7:38 pm

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 ?

Newbie

Posts

Joined
Wed Feb 29, 2012 7:47 am


Post by i2Paq » Mon Mar 18, 2013 8:31 pm

This happens when?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by ronsattic » Tue Mar 19, 2013 1:16 am

showing 1 to 2 times a day

Newbie

Posts

Joined
Wed Feb 29, 2012 7:47 am


Post by labeshops » Tue Mar 19, 2013 1:32 am

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.

Running Opencart v3.0.3.2 with multi-stores and the default template from https://www.labeshops.com which has links to all my stores.


User avatar
Expert Member

Posts

Joined
Thu Aug 04, 2011 4:41 am
Location - Florida, USA

Post by ronsattic » Tue Mar 19, 2013 7:34 am

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

Newbie

Posts

Joined
Wed Feb 29, 2012 7:47 am


Post by ronsattic » Tue Mar 19, 2013 9:20 pm

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

Newbie

Posts

Joined
Wed Feb 29, 2012 7:47 am


Post by butte » Thu Mar 21, 2013 12:01 pm

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.
Last edited by butte on Fri Mar 22, 2013 10:30 am, edited 1 time in total.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Daniel » Thu Mar 21, 2013 3:49 pm

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!

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by butte » Fri Mar 22, 2013 10:30 am

Thank you. Request lock.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by digitaltag » Wed Feb 10, 2016 11:34 pm

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.

Newbie

Posts

Joined
Thu Aug 02, 2012 8:07 pm
Who is online

Users browsing this forum: No registered users and 39 guests