SitemapXML v.2

1.5.1
php 5.3.21 with 1024M memory limit
mysql api 5.1.70

private VPS

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

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/en/out-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

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']

kitcorsa:

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)

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/en/out-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']

TRULY this sounds like a SERVER issue since the error occurs on DIFFERENT queries seemingly at random.. I would say this sounds a lot more like a SERVER issue than an issue with either this or the Ceon URI module..

OTHERWISE..

Many more people would be reporting this SAME issue for both modules.. On the contrary, your issue seems specific to your site/server/host..

If MyDomain-com is submitted to search engines through SitemapXML (ver 326), would www MyDomain-com/MyBlog be submitted as well?

Can MyDomain-com/MyBlog be manually added to SitemapXML?

Hi,

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']

I don't know and don't understand :(

Hi,

Kevin205:

If MyDomain-com is submitted to search engines through SitemapXML (ver 326), would www MyDomain-com/MyBlog be submitted as well?
No

Kevin205:

Can MyDomain-com/MyBlog be manually added to SitemapXML?
This issue was discussed here. See discussion - there was some solution.

Kevin205:

If MyDomain-com is submitted to search engines through SitemapXML (ver 326), would www MyDomain-com/MyBlog be submitted as well?

Can MyDomain-com/MyBlog be manually added to SitemapXML?

I use this WordPress plugin for sitemaps: http://www.arnebrachhold.de/redir/sitemap-home/. I like it because it has a "Additional Pages" section to add additional URLs for inclusion in the XML site map. If I have both a WordPress blog and a Zen Cart store, I will add the following URLs to the "Additional Pages" section:

• http://yourdomain.com/index.php?main_page=site_map
• http://yourdomain.com/index.php?main_page=products_all

This gets all my store links added to to the XML sitemap without having to manually add the entire store.. It has been working just fine for me.. (your mileage may vary :smile:)

a_berezin:

Hi,

This issue was discussed here. See discussion - there was some solution.

I have been looking, but I couldn't find it. I would appreciate if you would lead me to it. Thank you.

DivaVocals:

I use this WordPress plugin for sitemaps: http://www.arnebrachhold.de/redir/sitemap-home/. I like it because it has a "Additional Pages" section to add additional URLs for inclusion in the XML site map. If I have both a WordPress blog and a Zen Cart store, I will add the following URLs to the "Additional Pages" section:

• http://yourdomain.com/index.php?main_page=site_map

• http://yourdomain.com/index.php?main_page=products_all

This gets all my store links added to to the XML sitemap without having to manually add the entire store.. It has been working just fine for me.. (your mileage may vary :smile:)

I would look into it. Thank you DivaVocals.

Kevin205:

I would look into it. Thank you DivaVocals.

you're welcome.. It's a SIMPLE and doable solution IMHO.. I should add that when I do this I DO NOT install this module.. I use ONLY the WordPress plugin so that I am only submitting ONE sitemap..

DivaVocals:

you're welcome.. It's a SIMPLE and doable solution IMHO.. I should add that when I do this I DO NOT install this module.. I use ONLY the WordPress plugin so that I am only submitting ONE sitemap..

Go it. Thanks.

a_berezin:

Hi,

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.

Sorry for delayed response I have been super busy this week adding more products and such into my site, I would rather not give access to my live site, however I do have a duplicate dev site w/o customer or order information in it that is 100% the same other than the customer/order information that I am getting the same results on that I could give you access too, how do I go about getting you FTP access and what is the time frame where you would need to be in there I will have to create you an account, and then get your IP you will be connecting from so I can add it to the list of allowed IP's via FTP for however long you need it and then for whatever day range you might be able to get to it at.

Thanks for all your help it is truly appreciated!

jwaynehinkle:

how do I go about getting you FTP access and what is the time frame where you would need to be in there I will have to create you an account, and then get your IP you will be connecting from so I can add it to the list of allowed IP's via FTP for however long you need it and then for whatever day range you might be able to get to it at.
I can do your troubles when I have free time. I hope that next week. How much of this will take time, I don't know.

Ok fare enough, do I just PM you the info? also I am assuming you will also need access to the admin panel, I will get you a login, just PM whenever you have time to have a look and I can make sure you are able to login via FTP and to the admin panel :)

Thanks again for your help it is much appreciated!

jwaynehinkle:

Ok fare enough, do I just PM you the info? also I am assuming you will also need access to the admin panel, I will get you a login, just PM whenever you have time to have a look and I can make sure you are able to login via FTP and to the admin panel :)
Yes, of course via PM.

a_berezin:

Hi,

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.

Andrew did you ever find the solution to this error and a fix.. Thank You

PHP Warning: fopen(/home/xxxxxxxxx/public_html/sitemap/sitemapcategories.xml): failed to open stream: No such file or directory in /home/xxxxxxxxx/public_html/includes/classes/sitemapxml.php on line 740

countrycharm:

Andrew did you ever find the solution to this error and a fix.. Thank You

PHP Warning: fopen(/home/xxxxxxxxx/public_html/sitemap/sitemapcategories.xml): failed to open stream: No such file or directory in /home/xxxxxxxxx/public_html/includes/classes/sitemapxml.php on line 740

My bad somehow a folder got uploaded in the wrong place. Works nicely.