query_factory.php on line 46 errors when upgrade from 150 to 151

[lhungil]

... one error log:

[09-Nov-2013 06:21:22 America/New_York] PHP Fatal error: 2006:MySQL server has gone away :: ...

The highlighted section in red is the error message being returned. This is quite a bit different from the other error messages listed in this thread....

The error message your query is showing typically means the connection to the MySQL server was disconnected by the server while Zen Cart was loading a page... Or PHP could not (re)initiate a connection to the MySQL server (while a page was loading)... Zen Cart typically re-tries the connection a few times before giving up...

Just to be on the safe side, double check the settings you have in both of your "configure.php" files and make sure they match the correct username, password, database, and server address for MySQL. If these are of you will constantly see such messages in the Zen Cat debug logs.

When this error is occurring intermittently with Zen Cart... The fix is usually a call to the hosting company. They can look into exactly what was causing the issue (with their HTTP server / PHP talking to their MySQL server). In some cases (after looking into the issues) I've had hosting providers report anything from needing to "restart" the server, they needed to adjust some settings for the MySQL server, they had another "shared account" hogging the CPU, were dealing with some current "attacks" against their servers, or they were working to address some issues with their servers / network...

I'd be leery of a hosting provider who could not help solve the issue... Or one where the issue intermittently keeps happening after it has been "fixed"... I've not yet had to ever call more than once about this type of issue in a one year time frame... And on most providers have never even run into this issue occurring on a regular basis while running Zen Cart).

If this is on your own installation of WAMP, LAMP, MAMP, etc... Make sure you have configured MySQL with a large enough setting for "max_allowed_packet". You can read more about other possible causes here.

Others may be able to shed additional light, but if this is happening on a hosted server.... The hosting provider will have access to additional logs and data helpful in determining what is happening.

[twi]

Thanks again Andrew. You come to my rescue again. I will check the setting on both of my configure.php files to see if they are off or not with the setting.
If not then I will contact to host to look into this.

Thanks again.

[twi]

The highlighted section in red is the error message being returned. This is quite a bit different from the other error messages listed in this thread....

The error message your query is showing typically means the connection to the MySQL server was disconnected by the server while Zen Cart was loading a page... Or PHP could not (re)initiate a connection to the MySQL server (while a page was loading)... Zen Cart typically re-tries the connection a few times before giving up...

Just to be on the safe side, double check the settings you have in both of your "configure.php" files and make sure they match the correct username, password, database, and server address for MySQL. If these are of you will constantly see such messages in the Zen Cat debug logs.

When this error is occurring intermittently with Zen Cart... The fix is usually a call to the hosting company. They can look into exactly what was causing the issue (with their HTTP server / PHP talking to their MySQL server). In some cases (after looking into the issues) I've had hosting providers report anything from needing to "restart" the server, they needed to adjust some settings for the MySQL server, they had another "shared account" hogging the CPU, were dealing with some current "attacks" against their servers, or they were working to address some issues with their servers / network...

I'd be leery of a hosting provider who could not help solve the issue... Or one where the issue intermittently keeps happening after it has been "fixed"... I've not yet had to ever call more than once about this type of issue in a one year time frame... And on most providers have never even run into this issue occurring on a regular basis while running Zen Cart).

If this is on your own installation of WAMP, LAMP, MAMP, etc... Make sure you have configured MySQL with a large enough setting for "max_allowed_packet". You can read more about other possible causes here.

Others may be able to shed additional light, but if this is happening on a hosted server.... The hosting provider will have access to additional logs and data helpful in determining what is happening.

Checked the settings on both configure.php files. both have identical configurations. I will contact the host concerning this issue and see if they can fix it.

Also, Could it have something to do with the files involved in My multisite module? Please see below. Correct me if I am wrong. Based on my deductive reasoning, this might not be the problem. Otherwise the site might create the error all the time other than intermittently.

// Define the MULTISITE V1.0 parameters BY 2mk
// NOTE:: PER INSTALLATION INSRUCTION STEP 14 OF MULTISITE V1.0
include_once('includes/config_sites/sites_switch.php');

[lhungil]

Checked the settings on both configure.php files. both have identical configurations. I will contact the host concerning this issue and see if they can fix it.

Also, Could it have something to do with the files involved in My multisite module? ...

Not sure as I do not use that module... If the module was causing similiar issues I'd except to see a fair amount of messages here on the forums... But you never know... Hopefully your host can look at the date/time when the error message is reported and help track down why PHP is intermittently reporting it lost the connection to MySQL (and Zen Cart's code to retry the request ran into the same problem)...

[twi]

Not sure as I do not use that module... If the module was causing similiar issues I'd except to see a fair amount of messages here on the forums... But you never know... Hopefully your host can look at the date/time when the error message is reported and help track down why PHP is intermittently reporting it lost the connection to MySQL (and Zen Cart's code to retry the request ran into the same problem)...

Thanks. I will have to see what the host say and shed some light on the topic if they give me a answer to this.

[twi]

Not sure as I do not use that module... If the module was causing similiar issues I'd except to see a fair amount of messages here on the forums... But you never know... Hopefully your host can look at the date/time when the error message is reported and help track down why PHP is intermittently reporting it lost the connection to MySQL (and Zen Cart's code to retry the request ran into the same problem)...

This is what they have to say on the situation:

Sorry about your MySQL issue. I don't see the error on the site. This error can happen when you have to many connections to the database. Please make sure you are closing the database connections quickly, instead of leaving them open for read/writes. If you have any questions regarding this Service Request, you can chat directly with our Technical Support team by clicking on the following link: http://ts.chatwithsupport.net

I am puzzled at what is given as a explanation. Does he mean me logging in to the database using phpMyAdmin ? Or he is the puzzled one?

[lhungil]

Means the hosting provider LIMITS how many connections one can have open to the MySQL server... Sounds like they are more taking a "stab" in the dark then actually monitoring the server (and looking at logs) to determine the cause... I'd "think" long and hard about looking at a new hosting provider...

Zen Cart can end up with many connections open at one time depending upon how many requests to view the site / admin are happening at the same time (and if the hosting provider's systems / communications between PHP and MySQL are slow). The usual "fix" is just switching providers...

You can TRY the following change (so you can tell your provider your script does manually close connections)... Keep in mind I have not tested this on a production site, so if you make the change you may want to watch your site closely... And if the warnings go away (for at least a month) please let us all know!

Add the following function (shown in red) to the end of the query_factory class:

  function __destruct() {
    $this->close();
  }
}

class queryFactoryResult {

[DivaVocals]

Means the hosting provider LIMITS how many connections one can have open to the MySQL server... Sounds like they are more taking a "stab" in the dark then actually monitoring the server (and looking at logs) to determine the cause... I'd "think" long and hard about looking at a new hosting provider...

Zen Cart can end up with many connections open at one time depending upon how many requests to view the site / admin are happening at the same time (and if the hosting provider's systems / communications between PHP and MySQL are slow). The usual "fix" is just switching providers...

I would agree with this.. I once had a client with a similar issue, and the host used to tell her this was the issue and all but refused to check their server logs to determine the cause.. the "fix" was to change hosts..

Here's the funny thing, one day AFTER we switched hosts, I got a "follow-up" call from the old hosting provider informing me that they had "solved" the problem.. They informed me that they had been "monitoring" my client's site performance and were happy to report that the site's load time had improved and was no longer showing signs of the performance issues we were reporting.. I very calmly told the poor tech guy that I was not surprised about the improved performance given that my client was no longer hosting her site with them.. I could almost hear his jaw hit his desk..

[twi]

Means the hosting provider LIMITS how many connections one can have open to the MySQL server... Sounds like they are more taking a "stab" in the dark then actually monitoring the server (and looking at logs) to determine the cause... I'd "think" long and hard about looking at a new hosting provider...

Zen Cart can end up with many connections open at one time depending upon how many requests to view the site / admin are happening at the same time (and if the hosting provider's systems / communications between PHP and MySQL are slow). The usual "fix" is just switching providers...

You can TRY the following change (so you can tell your provider your script does manually close connections)... Keep in mind I have not tested this on a production site, so if you make the change you may want to watch your site closely... And if the warnings go away (for at least a month) please let us all know!

Add the following function (shown in red) to the end of the query_factory class:

http://www.zen-cart.com/images/smilies/bigups.gif

  function __destruct() {
    $this->close();
  }
}

class queryFactoryResult {

Thanks. so I always thought it was a problem with my install. in fact it is a problem at the hosting side due to limitations. A few months ago I was going to switch host when I had the problem with paypal module on the day I took my fully tested site online. The problem persisted an entire week. But somehow someone else with the same problem contacted my host (and his host, (netsol) and his problems got fixed while mine was also fixed. I will definitely think about switching.

[twi]

I would agree with this.. I once had a client with a similar issue, and the host used to tell her this was the issue and all but refused to check their server logs to determine the cause.. the "fix" was to change hosts..

Here's the funny thing, one day AFTER we switched hosts, I got a "follow-up" call from the old hosting provider informing me that they had "solved" the problem.. They informed me that they had been "monitoring" my client's site performance and were happy to report that the site's load time had improved and was no longer showing signs of the performance issues we were reporting.. I very calmly told the poor tech guy that I was not surprised about the improved performance given that my client was no longer hosting her site with them.. I could almost hear his jaw hit his desk..

Thanks for shedding more light on the situation. I am actually really fed up with my current host. Most of the responses seems nothing but patronization instead of really looking and checking for a solution. I am not surprise on the incident you are telling us here. It's just confirmed my suspicion that they (some hosts) just give you an answer for the sake of giving an answer.