SitemapXML v.2

[denialdesign]

Never mind I fixed it. There are 2 "admin" directories in this site for some reason and I'd uploaded to the wrong one.

[kitcorsa]

I have searched and tried all the fixes people have mentioned but have just started getting the following error after over a year of perfect opperation.... could be because ive now added more products to my site ... but cant find a fix

[01-Jun-2014 09:53:57 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_type from products where products_id = '5388' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120
[01-Jun-2014 09:53:57 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = '3a359e814b29dc3a564aeef9d' in /home/public_html/includes/classes/db/mysql/query_factory.php on line 120

plenty of people have mentioned this before and people have said its a host issue etc but i believe this is something else for me as i have a VPS with over 16gb of ram (only 10% used during normal operation) and plently of disk space (only 8% used of my 40gb of space). I have full root access through my cpanel WHM etc and have the php memory_limit set to -1 (have tried all kinds of settings in here no no effect) can anyone give me any pointers incase im missing something

[diamond1]

you can only create a sitemap index instead of creating sitemap, sitemap sitemap categories and products, if feasible a single file that incorporates the products and categories. I only have 25 categories and 300 products, I think it's better to have a single google site map.

[a_berezin]

I think it's better to have a single google site map.

Possible. It is easy to check - write such a plugin.

[diamond1]

Thanks

Is there something ready, I do not know program.

Sincerely

[DivaVocals]

Thanks

Is there something ready, I do not know program.

Sincerely

no.. but if this something you need/want and do not have the skill set to create it yourself you may have to hire an developer to create it for you..

[a_berezin]

I do not know program.

You can manually do it. Or use a third party service. If you can afford to spend on it's own time.

[diamond1]

Do you know someone who can do it? I do not cost much?

[saderogba]

I am using the latest version of SitemapXML. The issue I am having is that sitemapproducts.xml is not generated completely, I have about 18k products, the file ends around 1k. Please any idea on how to resolve this issue? Thanks.

[a_berezin]

I am using the latest version of SitemapXML. The issue I am having is that sitemapproducts.xml is not generated completely, I have about 18k products, the file ends around 1k. Please any idea on how to resolve this issue? Thanks.

One of two options: either the memory is not enough or time restrictions. In directory cach/logs there are any messages?