Post by webfeetdesign » Mon Apr 30, 2018 9:14 pm

Hi've received this error notice when I click on a page on my website:

Any help with what this means would be great!

Notice: mysql_query(): send of 51 bytes failed with errno=32 Broken pipe in /home/moette/public_html/oc1/system/database/mysql.php on line 22Warning: Error while sending QUERY packet. PID=9789 in /home/moette/public_html/oc1/system/database/mysql.php on line 22Notice: Error: MySQL server has gone away

Error No: 2006

SELECT * FROM `oc_language` WHERE status = ‘1’ in /home/moette/public_html/oc1/system/database/mysql.php on line 50

Active Member

Posts

Joined
Fri Feb 05, 2010 1:28 am
Location - Dubai

Post by IP_CAM » Tue May 01, 2018 5:36 am

Well, you should have changed your both config.php settings to mysqli
for some time already, and your hoster now possibly just disabled mysql from
further function. And you will love it, OC is much faster than ever before, because of this.

Code: Select all

// DB
define('DB_DRIVER', 'mysqli');
But that's just a Guess...
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by webfeetdesign » Tue May 01, 2018 1:34 pm

Thanks for that Ernie, really appreciate it. I've changed that in both config files (replace mysql with mysqli). I'll wait and see if there are any more problems to determine if that was the cause of the problem.

The other errors that have been noted in the log file are:

| 12533 | moette_alex | localhost | moette_oc-upgrade-2017 | Query | 369 | Creating sort index | SELECT c.category_id, COUNT(p2c.category_id) AS products_ |unt, GROUP_CONCAT(p2c.product_id) AS ids
| 12589 | moette_alex | localhost | moette_oc-upgrade-2017 | Query | 267 | Creating sort index | SELECT c.category_id, COUNT(p2c.category_id) AS products_ |unt, GROUP_CONCAT(p2c.product_id) AS ids
| 12706 | moette_alex | localhost | moette_oc-upgrade-2017 | Query | 149 | Creating sort index | SELECT c.category_id, COUNT(p2c.category_id) AS products_ |unt, GROUP_CONCAT(p2c.product_id) AS ids
| 12719 | moette_alex | localhost | moette_oc-upgrade-2017 | Query | 132 | Creating sort index | SELECT c.category_id, COUNT(p2c.category_id) AS products_ |unt, GROUP_CONCAT(p2c.product_id) AS ids
| 12777 | moette_alex | localhost | moette_oc-upgrade-2017 | Query | 76 | Creating sort index | SELECT c.category_id, COUNT(p2c.category_id) AS products_ |unt, GROUP_CONCAT(p2c.product_id) AS ids
| 12810 | moette_alex | localhost | moette_oc-upgrade-2017 | Query | 41 | Creating sort index | SELECT c.category_id, COUNT(p2c.category_id) AS products_ |unt, GROUP_CONCAT(p2c.product_id) AS ids
| 12827 | moette_alex | localhost | moette_oc-upgrade-2017 | Query | 19 | Creating sort index | SELECT c.category_id, COUNT(p2c.category_id) AS products_ |unt, GROUP_CONCAT(p2c.product_id) AS ids

I have no idea what that means though :(

Active Member

Posts

Joined
Fri Feb 05, 2010 1:28 am
Location - Dubai

Post by victorj » Wed May 02, 2018 6:23 am

Did you tell the whole story, is thsi a error just out off the bleu or after you did a upgrade.
if you did a upgrade from wich version to wich version,

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by webfeetdesign » Wed May 02, 2018 2:01 pm

No this just happened out of the blue. I have not upgraded.

Active Member

Posts

Joined
Fri Feb 05, 2010 1:28 am
Location - Dubai

Post by victorj » Wed May 02, 2018 2:29 pm

Dus not Read your first post entirely.
The answer is there at the end.
MySQL has gone away.
Mening your server had a SQL problem.
Either your SQL server has problems or your site is hitting the boundery of limits set by your hoster.
In Both cases contact your hoster to solve this.

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland
Who is online

Users browsing this forum: No registered users and 291 guests