Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    355
    Plugin Contributions
    0

    Default Out of Memory errors with CeonURIMappingHREFLinkBuilder and sitemap rebuilding

    I noticed many out of memory errors files on my log directory:

    ----- This was produced when I tried to regenerate sitelinks:


    [31-Jan-2017 15:30:28xxxx/xxxxxx] Request URI: /myshop/index.php?main_page=sitemapxml&rebuild=yes&ping=yes&, IP address: xx.xx.xx.xx
    #1 mysqli_query() called at [/home/mypath/public_html/myshop/includes/classes/db/mysql/query_factory.php:45]
    #2 queryFactory->query() called at [/home/mypath/public_html/myshop/includes/classes/db/mysql/query_factory.php:257]
    #3 queryFactory->Execute() called at [/home/mypath/public_html/myshop/includes/functions/functions_categories.php:204]
    #4 zen_get_product_path() called at [/home/mypath/public_html/myshop/includes/classes/class.CeonURIMappingHREFLinkBuilder.php:274]
    #5 CeonURIMappingHREFLinkBuilder->buildHREFLink() called at [/home/mypath/public_html/myshop/includes/functions/html_output.php:49]
    #6 zen_href_link() called at [/home/mypath/public_html/myshop/includes/classes/sitemapxml.php:219]
    #7 zen_SiteMapXML->writeItem() called at [/home/mypath/public_html/myshop/includes/modules/pages/sitemapxml/sitemapxml_products.php:102]
    #8 include(/home/mypath/public_html/myshop/includes/modules/pages/sitemapxml/sitemapxml_products.php) called at [/home/mypath/public_html/myshop/includes/templates/template_default/sitemapxml/tpl_main_page.php:21]
    #9 require(/home/mypath/public_html/myshop/includes/templates/template_default/sitemapxml/tpl_main_page.php) called at [/home/mypath/public_html/myshop/index.php:97]

    [31-Jan-2017 15:30:28xxxx/xxxxxx] PHP Warning: mysqli_query(): (HY000/2008): Out of memory in /home/mypath/public_html/myshop/includes/classes/db/mysql/query_factory.php on line 45
    [31-Jan-2017 15:30:28xxxx/xxxxxx] Request URI: /myshop/index.php?main_page=sitemapxml&rebuild=yes&ping=yes&, IP address: xx.xx.xx.xx
    #1 trigger_error() called at [/home/mypath/public_html/myshop/includes/classes/db/mysql/query_factory.php:167]
    #2 queryFactory->show_error() called at [/home/mypath/public_html/myshop/includes/classes/db/mysql/query_factory.php:139]
    #3 queryFactory->set_error() called at [/home/mypath/public_html/myshop/includes/classes/db/mysql/query_factory.php:266]
    #4 queryFactory->Execute() called at [/home/mypath/public_html/myshop/includes/functions/functions_categories.php:204]
    #5 zen_get_product_path() called at [/home/mypath/public_html/myshop/includes/classes/class.CeonURIMappingHREFLinkBuilder.php:274]
    #6 CeonURIMappingHREFLinkBuilder->buildHREFLink() called at [/home/mypath/public_html/myshop/includes/functions/html_output.php:49]
    #7 zen_href_link() called at [/home/mypath/public_html/myshop/includes/classes/sitemapxml.php:219]
    #8 zen_SiteMapXML->writeItem() called at [/home/mypath/public_html/myshop/includes/modules/pages/sitemapxml/sitemapxml_products.php:102]
    #9 include(/home/mypath/public_html/myshop/includes/modules/pages/sitemapxml/sitemapxml_products.php) called at [/home/mypath/public_html/myshop/includes/templates/template_default/sitemapxml/tpl_main_page.php:21]
    #10 require(/home/mypath/public_html/myshop/includes/templates/template_default/sitemapxml/tpl_main_page.php) called at [/home/mypath/public_html/myshop/index.php:97]

    [31-Jan-2017 15:30:28xxxx/xxxxxx] PHP Fatal error: 2008:Out of memory :: select p.products_id, p.master_categories_id
    from products p
    where p.products_id = '13446' limit 1 ==> (as called by) /home/mypath/public_html/myshop/includes/functions/functions_categories.php on line 204 <== in /home/mypath/public_html/myshop/includes/classes/db/mysql/query_factory.php on line 167
    [31-Jan-2017 15:30:28xxxx/xxxxxx] PHP Fatal error: Out of memory (allocated 11272192) (tried to allocate 8068 bytes) in Unknown on line 0


    Can you please give me some hints where to start in order to solve it ?

    thx

    ZC 1.5.5
    PHP Version 5.4.45
    Apache Version 2.2.31

  2. #2
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,606
    Plugin Contributions
    1

    Default Re: Out of Memory errors with CeonURIMappingHREFLinkBuilder and sitemap rebuilding

    Provide your Hoster with the same error info and ask if they will increase Server PHP Memory limit.
    The learning is in the doing.

    Potent Products

  3. #3
    Join Date
    Aug 2009
    Posts
    355
    Plugin Contributions
    0

    Default Re: Out of Memory errors with CeonURIMappingHREFLinkBuilder and sitemap rebuilding

    Problem solved by upgrading to php 5.6 from php 5.4

    thx

  4. #4
    Join Date
    Jul 2012
    Posts
    14,858
    Plugin Contributions
    17

    Default Re: Out of Memory errors with CeonURIMappingHREFLinkBuilder and sitemap rebuilding

    Quote Originally Posted by solo_400 View Post
    Problem solved by upgrading to php 5.6 from php 5.4

    thx
    The version of both plugins that were involved, what was/were their source? I understand that the CEON part has been updated at least in github, I'm curious (though don't recall seeing any such reported issues) of if that was the version used/obtained or if still using an older version of the software? (Some updates were considered necessary to support/further use with ZC 1.5.5, some because of deprecated PHP features, etc..)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

 

 

Similar Threads

  1. v139h PHP Out of memory errors
    By jgold723 in forum General Questions
    Replies: 14
    Last Post: 9 Jul 2014, 06:14 PM
  2. v151 XML-Sitemap Keeps failing Allowed memory size of bytes exhausted
    By kapsolas in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 9 Jun 2014, 09:56 PM
  3. v150 [Done v1.5.2] Memory Leak with PHP 5.4 and Zen v1.5.0RC1
    By Kamino84 in forum Bug Reports
    Replies: 9
    Last Post: 3 Nov 2013, 11:34 PM
  4. Im out of memory?
    By lizar5- in forum General Questions
    Replies: 6
    Last Post: 5 Dec 2009, 07:15 PM
  5. Database Memory errors?
    By mes7000 in forum General Questions
    Replies: 4
    Last Post: 11 Nov 2008, 03:58 PM

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