SitemapXML v.2

[jwaynehinkle]

Ok so it appears that I have got everything working here except for the products sitemap, and the categories site map, which kind of sucks as that is the majority of my store, I do have alot of products and a lot of categories, I am not sure why it gives blank page on these 2 particular sitemaps but the rest of them work just fine, any help would be greatly apreciated, as we have recently redone our store and need to submit new sitemaps to everyone due to the amount of url changes, and increase in products that we have added.

[jwaynehinkle]

Think I have figured out what the issue is for some reason on the larger files it is not adding the "</urlset>" line of code at the end of the file? Does this mean that it is not generating the entire file because I possibly have to many links? or lines of code in the file? I am not sure exactly why it is not doing this, but just to double check and make sure that I have it installed correctly I have gone through and uninstalled the mod, removed all existing files, and re installed it twice, I am getting the same results, is there any way to force it to make a new sitemap after it hits so many lines, or hits so many URLS, I know in the description it says that it is either supposed to do it once the file gets to be either 50k URLs, or 10MB, however I am not seeing it do either one... any help would be awesome!

[a_berezin]

Hi,

Think I have figured out what the issue is for some reason on the larger files it is not adding the "</urlset>" line of code at the end of the file? Does this mean that it is not generating the entire file because I possibly have to many links?

The absence of a closing tag </urlset> suggests that the script was not completed. Look at the error logs in the cache.
If you need help - can you give access to FTP, I'll see where the error is.

[kitcorsa]

I have this when creating sitemaps.... has been working fine for ages

2008 MySQL client ran out of memory
in:
[ SELECT uri FROM ceon_uri_mappings WHERE main_page = 'product_info' AND associated_db_id = '1294' AND language_id = '1' AND current_uri = '1' LIMIT 1;]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = '1ca2fbd7dc8c2849bf4b6788953ada29']

[a_berezin]

Hi,

I have this when creating sitemaps.... has been working fine for ages

2008 MySQL client ran out of memory
in:
[ SELECT uri FROM ceon_uri_mappings WHERE main_page = 'product_info' AND associated_db_id = '1294' AND language_id = '1' AND current_uri = '1' LIMIT 1;]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = '1ca2fbd7dc8c2849bf4b6788953ada29']

Version Zen-Cart?
Version PHP?
Version mySQL?

[kitcorsa]

1.5.1
php 5.3.21 with 1024M memory limit
mysql api 5.1.70

private VPS

[kitcorsa]

I have also done a complete install and re-install of the plugin with no joy

[kitcorsa]

hosts say "It seems that mysql does not have enough memory to store the entire query result.
Please make sure that your query is correct. More information about this issue you can find
on the following pages:

https://dev.mysql.com/doc/refman/5.0...of-memory.html
http://forums.mysql.com/read.php?37,94800,190727
"

was working till a thursday last week

also..... why does this say version 2 when plugin shows version 3.2.12 19.09.2013 8:06:18

[kitcorsa]

now getting

2008 MySQL client ran out of memory
in:
[select p.products_id, p.master_categories_id from products p where p.products_id = '2550' limit 1]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = 'c1f75a5c986ca156d9017e72cbad4830']

[DivaVocals]

also..... why does this say version 2 when plugin shows version 3.2.12 19.09.2013 8:06:18

Because....
The support thread was created LONG AGO (when v2 was released)