Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2009
    Posts
    368
    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,571
    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.

  3. #3
    Join Date
    Aug 2009
    Posts
    368
    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
    16,719
    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...

 

 

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