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
  • [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
  • [phpBB3] Chinese language support
    Hi, i bought magic seo for phpbb because it says that it supports a wide range of alphabets and UTF-8, however i found that it doesn't. I'm preparing a website in Chinese and all forums having a...
    by iwsmike
  • [WP2PS] Yoast SEO plugin
    Thanks for your support installing the PS-WP integration. However there is some errors when PS-WP integration is activated. 1. Error generating sitemap with Yoas SEO plugin (it disappears when...
    by argidomin
Join our support forum » Pre-Sales Questions »
Featured Testimonials

Thank you so much for getting it setup!

Jonathan, the owner of Foster's Point

We are glad with our business relationship with the folks at Inveostore.com. They are very knowledgeable and speed of support is second to none. They have also gone the extra mile to assist us in writing codes to make other urls to have the nicely formed urls. Kudos to all the team at Inveo and keep up the good work. Looking forward...

Issac, the owner of Clevershoppers.com

More Testimonials »