Page 1 of 2 12 LastLast
Results 1 to 10 of 19
  1. #1
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default 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.
    [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
    Learning Fast.
    Eden Craft Supplies

  2. #2
    Join Date
    Jul 2012
    Posts
    16,799
    Plugin Contributions
    17

    Default 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?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default 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.
    Learning Fast.
    Eden Craft Supplies

  4. #4
    Join Date
    Jul 2012
    Posts
    16,799
    Plugin Contributions
    17

    Default Re: I think I should think of giving up

    Quote Originally Posted by adb34 View Post
    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?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default 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
    Learning Fast.
    Eden Craft Supplies

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,410
    Plugin Contributions
    94

    Default 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.

  7. #7
    Join Date
    Jan 2004
    Posts
    66,419
    Blog Entries
    7
    Plugin Contributions
    81

    Default Re: I think I should think of giving up

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

    Quote Originally Posted by lat9 View Post
    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.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    13,410
    Plugin Contributions
    94

    Default 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).

  9. #9
    Join Date
    Feb 2012
    Location
    mostly harmless
    Posts
    1,809
    Plugin Contributions
    8

    Default 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?
    The glass is not half full. The glass is not half empty. The glass is simply too big!
    Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
    Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

  10. #10
    Join Date
    Mar 2008
    Location
    Brampton, Cumbria, United Kingdom, United Kingdom
    Posts
    816
    Plugin Contributions
    2

    Default Re: I think I should think of giving up

    OK my host is 1 and 1

    PHP = 5.5
    Learning Fast.
    Eden Craft Supplies

 

 
Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR