I think I should think of giving up

I have a whole host of problems and all I have done is a complete backup upload.

Quote:

---

[07-Oct-2015 14:26:29 Europe/London] #1 mysqli_query() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/classes/db/mysql/query_factory.php:43]
#2 queryFactory->query() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/classes/db/mysql/query_factory.php:254]
#3 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/functions/functions_lookups.php:522]
#4 zen_get_info_page() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_modules_upcoming_products.php:25]
#5 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_modules_upcoming_products.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/upcoming_products.php:62]
#6 include(/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/upcoming_products.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_index_categories.php:113]
#7 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_index_categories.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/pages/index/main_template_vars.php:219]
#8 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/pages/index/main_template_vars.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/carlisle_fresh/common/tpl_main_page.php:214]
#9 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/carlisle_fresh/common/tpl_main_page.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/index.php:97]

[07-Oct-2015 14:26:29 Europe/London] PHP Warning: mysqli_query(): MySQL server has gone away in /homepages/20/d503465712/htdocs/shops/ecs/includes/classes/db/mysql/query_factory.php on line 43
[07-Oct-2015 14:26:29 Europe/London] #1 mysqli_query() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/classes/db/mysql/query_factory.php:43]
#2 queryFactory->query() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/classes/db/mysql/query_factory.php:254]
#3 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/functions/functions_lookups.php:522]
#4 zen_get_info_page() called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_modules_upcoming_products.php:25]
#5 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_modules_upcoming_products.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/upcoming_products.php:62]
#6 include(/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/upcoming_products.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_index_categories.php:113]
#7 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/template_default/templates/tpl_index_categories.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/pages/index/main_template_vars.php:219]
#8 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/modules/pages/index/main_template_vars.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/carlisle_fresh/common/tpl_main_page.php:214]
#9 require(/homepages/20/d503465712/htdocs/shops/ecs/includes/templates/carlisle_fresh/common/tpl_main_page.php) called at [/homepages/20/d503465712/htdocs/shops/ecs/index.php:97]

[07-Oct-2015 14:26:29 Europe/London] PHP Warning: mysqli_query(): Error reading result set's header in /homepages/20/d503465712/htdocs/shops/ecs/includes/classes/db/mysql/query_factory.php on line 43

---

The log though appears to address the mysql server... Was that what received the backup or was the file server the recipient?

Just the files. I have been having loads of problems. I think I will dump this shop and again, start from scratch. I think I am overloading the shop with too many plugin's and they are working against each other.

Quote:

---

Originally Posted by adb34

Just the files. I have been having loads of problems. I think I will dump this shop and again, start from scratch. I think I am overloading the shop with too many plugin's and they are working against each other.

---

Can't say that I see that as a possibility from the information provided above... While I am no judge of uk hosts, it may help others provide feedback if you identify with whom your store is hosted... Otherwise, yes shuld only install what is needed to operate the store and make profit, should also do some independent testing before modifying the live store, should install one plugin at a time to keep things sorted (or be willing to troubleshoot the myriad issues that might ensue), further, "wiping it all out" (which I think has been dscussed before) doesn't necessarily resolve or identify the central issue/cause and that should be identifiied first.

What was the reason for restoring the files this most recent time?

I will trouble shoot with this store. Yes you are right to do testing on a back site but I do not have the space available to test, so I will use this one as my test bed. I have started another site which will only have plugin's installed that work with this site. So in a way, I have a live test shop

FWIW, I've seen a bunch of sites (ZC 1.5.3, ZC 1.5.4) that are periodically receiving the "MySQL server has gone away" message. I haven't been able (yet) to find a root cause.

@adb34, who's your hosting company? And PHP version?

Quote:

---

Originally Posted by lat9

FWIW, I've seen a bunch of sites (ZC 1.5.3, ZC 1.5.4) that are periodically receiving the "MySQL server has gone away" message. I haven't been able (yet) to find a root cause.

---

Hmmm ... @lat9, any idea whether it's common to a particular hosting company? or PHP version?

The only time I've see this "MySQL server has gone away" recently is on shared hosts that are overloaded with too many sites on one server. Commonly found on GoDaddy and Dreamhost and the Hostgator/Bluehost(Endurance conglomerate). And in these cases it's a problem that can only be fixed by the hosting company.

DrByte, I've seen it on 1&1 (shared server) and on a couple of other sites (one's a dedicated server on vps.net). I can't speak to the vps.net site, but my personal sites on 1&1 (which have gone from Zen Cart 1.3.8a->1.3.9->1.5.0->1.5.1->1.5.4) never received this error on their pre-v1.5.4 incantations (i.e. using mysql_* instead of mysqli_* functions).

I've occasionally seen this on one of my client's sites (maybe once every 3 - 6 months). 95% of the time it coincided with a MySQL (or complete) server restart. 4% of the time the host reported they suspended other accounts for abuse (or excessive resource use). The other 1% of the time the host has not provided an answer (and I could not duplicate the error on demand).

I also did not see this when using mysql_* on the same hosting provider. Perhaps mysqli_* is a little more aggressive with dead / idle link cleanup?

OK my host is 1 and 1

PHP = 5.5