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
Re: I think I should think of giving up
The log though appears to address the mysql server... Was that what received the backup or was the file server the recipient?
Re: I think I should think of giving up
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.
Re: I think I should think of giving up
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?
Re: I think I should think of giving up
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
Re: I think I should think of giving up
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.
Re: I think I should think of giving up
@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.
Re: I think I should think of giving up
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).
Re: I think I should think of giving up
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?
Re: I think I should think of giving up
OK my host is 1 and 1
PHP = 5.5
Re: I think I should think of giving up
There may be a myriad of reasons why the error "mysql has gone away" appears. See https://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Re: I think I should think of giving up
The thing is I cannot get FEC to work in checkout as well. No matter what I do, it will not work. I have posted on that thread and all suggestions also do not work.
Re: I think I should think of giving up
Quote:
The thing is I cannot get FEC to work
Really need to know all of the plugins you have loaded
Re: I think I should think of giving up
Quote:
Originally Posted by
kobra
Really need to know all of the plugins you have loaded
I listed the plugin, on the FEC thread
Re: I think I should think of giving up
Quote:
Originally Posted by
adb34
The thing is I cannot get FEC to work in checkout as well. No matter what I do, it will not work. I have posted on that thread and all suggestions also do not work.
I took a lap through the discussion in the FEC forum and 1) would suggest continuing to troubleshoot FEC through that thread, 2) would suggest settingup a temp store, and install just FEC to verify functionality in your test environment, 3) would suggest that you slow down... There have been a few threads where you've had difficulty installing a plugin, to then state that it has been removed to find out that only this part or another was removed not the entire plugin. Now in FEC you've stated that you've removed all code from the orders.php file except the FEC part, well this could cause new errors to be generated. The more things are affected at once, the harder it is to figure out what the problem is. Effectively need to change one thing at a time. This is not to say that a single line in a file be changed, but complete an installation, complete a removal, etc... before testing the current status or checking functionality. Also while writing this I see kobra has posted about needing to know which plugins are installed. This is why when posting about an issue it is recommended to address the items in the posting tips.
Re: I think I should think of giving up
Quote:
Originally Posted by adb34
I listed the plugin, on the FEC thread
I looked back to your post dtd 23 Aug 2015, 09:43 AM and forward from there and did not see where you listed ALL your plugins
Re: I think I should think of giving up
Quote:
Originally Posted by
lhungil
Perhaps mysqli_* is a little more aggressive with dead / idle link cleanup?
It's very possible that hosts haven't tuned their defaults as well as they had with the older mysql stuff. Or the defaults are just stricter and need tweaking where tweaking wasn't needed before. The tweaks could be to both the php.ini (for PHP server side) and the my.cnf (for MySQL server side)
Re: I think I should think of giving up
Any idea as to what those tweaks might be Dr Byte?
Re: I think I should think of giving up
Quote:
Originally Posted by
adb34
PHP Warning: mysqli_query(): MySQL server has gone away
Quote:
Originally Posted by
DrByte
It's very possible that hosts haven't tuned their defaults as well as they had with the older mysql stuff. Or the defaults are just stricter and need tweaking where tweaking wasn't needed before. The tweaks could be to both the php.ini (for PHP server side) and the my.cnf (for MySQL server side)
Quote:
Originally Posted by
lloyd_borrett
Any idea as to what those tweaks might be Dr Byte?
Googling for the error message "MySQL server has gone away" brings up tons of articles suggesting various server-side tweaks:
http://stackoverflow.com/questions/1...large-sql-file
https://dev.mysql.com/doc/refman/5.0/en/gone-away.html
and lots more
Another possibility is that in your Zen Cart site you might have added custom code to prematurely call application_bottom.php or otherwise close the session and/or database connection, in which case simply "not" doing that would be advisable.
And of course using old versions of any ZC code files copied into a newer-version site can cause undesired effects.
