Page 1 of 1

[MSU Sitemaps] HTTP request timeout

Posted: Wed Feb 25, 2009 1:53 pm
by Neilleclough
Thanks very much for your help with sitemaps on http://www.ToolTrolley.co.uk last night Jiri - truly appreciated.

I'm still having a problem with the Products sitemap. It looks as though Google is experiencing an HTTP timeout issue when looking at:-

sitemaps.php?showMap=Products

Although there are fewer than 50,000 URLs in that particulare site map, they are all quite lengthy URLs and I suspect the page is timing out before it completes.

Is there a way of splitting the Products sitemap into several smaller ones?

Neil

Re: [MSU Sitemaps] HTTP request timeout

Posted: Wed Feb 25, 2009 1:58 pm
by inveo
Unfortunately there is no solution at this time. The only way how to sort this out is to ask your host for increasing script execution time for sitemaps files or make set_time_limit() function to work.

Re: [MSU Sitemaps] HTTP request timeout

Posted: Thu Feb 26, 2009 9:27 am
by inveo
The other solution I found out during night sleeping is simple and 100% working.

1) Make a one (two, three...) copy of sitemaps/products.php file in same folder (e.g. products1.php)
2)

Alter the following line of first file:

Code: Select all

$result = $db->Execute("SELECT p.products_id, p.products_type, p.products_date_added, p.products_last_modified FROM ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '".$langId."' ORDER BY p.products_id DESC");


to

Code: Select all

$result = $db->Execute("SELECT p.products_id, p.products_type, p.products_date_added, p.products_last_modified FROM ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '".$langId."' ORDER BY p.products_id DESC LIMIT 0,500");


and for second file:

Code: Select all

$result = $db->Execute("SELECT p.products_id, p.products_type, p.products_date_added, p.products_last_modified FROM ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '".$langId."' ORDER BY p.products_id DESC");


to

Code: Select all

$result = $db->Execute("SELECT p.products_id, p.products_type, p.products_date_added, p.products_last_modified FROM ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '".$langId."' ORDER BY p.products_id DESC LIMIT 500,1000");


Where:

1000 represent number of products (records) in database
500 = 1000/2 (2 - is the number of copies products.php file)

I am not sure it is clear, feel free to ask.

Re: [MSU Sitemaps] HTTP request timeout

Posted: Thu Feb 26, 2009 9:42 am
by Neilleclough
Brilliant!!!
Thanks very much indeed Jiri - your help is invaluable.
I'd be struggling without you!

In case anybody else struggles with this, Jiri's first suggestion about increasing the timeout works a treat. You will need a vps account with your hosting company (they won't do it on a shared server). I managed to get mine increased from 30 seconds to 120 seconds which has not only fixed this problem, but also allows to me to do very large uploads using EasyPopulate.

Cart  
(empty)

Cart Check out  »

Prices are tax inclusive.

The VAT rate for your country (US) * is 0,0 % because it is not a member of the European Union (EU).

* Please create an account if your country does not match.

Community feed
  • [Zen Cart] Can't execute Magic SEO URLs sitemaps
    I installed Magic SEO URLs Sitemaps Add-On for ZenCart MSU4.x/MSU5.x 2.0 on my server, when I try to generate sitemaps using: https://www.pechesudv155.owally.com/sitemaps.php I received :...
    by peter@pechesud.com
  • [phpBB3] Sharing users between phpBB / PrestaShop
    Hi i have 2 question 1- prestashop module support phpBB 3.3 ? 2- why we can not login in prestashop and phpbb with same user?
    by zohall
  • [phpBB3] AJAX Userinfo Extension
    Hi! I'm having trouble with this extension: https://www.phpbb.com/customise/db/exte ... _userinfo/ I tried asking support from the author but for no avail, since now. My request for support...
    by Lord Phobos
  • [phpBB3] Upgrade to phpBB 3.2.3
    Hello.. after Upgrade to phpBB 3.2.3 I am getting this message.. How can I solve this issue..? Thank you
    by ingbrzy
  • [phpBB3] URL path changed
    Hello.. I have changed my site path after moving to new hosting and now can not activate SEO module.. new path http://www.miuios.cz/domains/miuios.cz/ could you help me? thank you
    by ingbrzy2
Join our support forum » Pre-Sales Questions »
Featured Testimonials

Magic SEO URLs seem to be having a really positive effect on our ranking and look so much cleaner in the browser than a random set of numbers. The sitemaps have also saved me a lot of time!

Simon, the owner of Beltingonline.com

Skeptical at first as I am with all new purchases that can dramatically effect traffic, but this one comes highly recommended. And not just for the product, the support is second to none and all issues are dealt with politely and efficiently. Top Marks!

Phillip, the owner of Sexy Ladies Fancy Dress Costumes

More Testimonials »