SitemapXML v.2

I currently have SiteMapXML v 2.1.0 30.04.2009
whats the best way to uprade to the latest version?

I installed it,but when i creat xml files,it said have error for set LANGUAGES,because i deleted one of all language(chinese) files in include folder.
So have error when it creat mainpage ,but it can creat sitemapcategories.xml.why?
And please help me to fix this error.
Thanks
My site http://www.gueston.com
error in
1054 Unknown column 'SITEMAPXML_HOMEPAGE_ORDERBY' in 'order clause'
SELECT * FROM languages l WHERE l.languages_id IN (2,1) ORDER BY SITEMAPXML_HOMEPAGE_ORDERBY]

Using Zen v1.3.9h. Using sitemap XML v 3.0.3 27.08.2011 13:11.

The module works great. Thanks. One problem, in stores above 300,000 products, the mod seems to stop after generating 6 sitemapproducts files. It will generate 000 through 006.

Is there a setting to generate above six files, 300,000 products. We have several stores with more than 300,000 products.

Thanks in advance.

I can never understand why threads become clogged with rubbish like the above? Zen Cart is a free script, with a lot of great developers offering their work for free too, work which involves time and effort, thought and patience, these developers also visit the forums on a regular basis (it seems some never leave lol) offering advice on their own mods and also other issues people may have. No doubt in your quest to find the answer you will recognise a few of the usernames in this thread alone.

The developers offer a support thread for reporting bugs in their code and assistance in installing, if however you have additional mods installed, have a custom template or just an alternative quirk in your site for one reason or another which means that a tried and tested module is not working, i do sincerely believe this is nobody else's problem - it's certainly not the developers.

However you will find most developers will happily give up their time (usually for free if it is a common bug or an issue which proves to be useful in the next upgrade of the module) to sort these issues via the support thread - again for free.

Yet despite all of this, when someone who has installed a free copy of Zen Cart, gotten free advice from the supporting forums and installed a free module, on the occasion where a developer doesn't have time to help, cannot replicate the issue or simply does not know the answer... all gratitude goes out the window and the very mention of the commercial forum for additional assistance sends shockwaves.

bonnit:

I can never understand why threads become clogged with rubbish like the above? Zen Cart is a free script, with a lot of great developers offering their work for free too, work which involves time and effort, thought and patience, these developers also visit the forums on a regular basis (it seems some never leave lol) offering advice on their own mods and also other issues people may have. No doubt in your quest to find the answer you will recognise a few of the usernames in this thread alone.

The developers offer a support thread for reporting bugs in their code and assistance in installing, if however you have additional mods installed, have a custom template or just an alternative quirk in your site for one reason or another which means that a tried and tested module is not working, i do sincerely believe this is nobody else's problem - it's certainly not the developers.

However you will find most developers will happily give up their time (usually for free if it is a common bug or an issue which proves to be useful in the next upgrade of the module) to sort these issues via the support thread - again for free.

Yet despite all of this, when someone who has installed a free copy of Zen Cart, gotten free advice from the supporting forums and installed a free module, on the occasion where a developer doesn't have time to help, cannot replicate the issue or simply does not know the answer... all gratitude goes out the window and the very mention of the commercial forum for additional assistance sends shockwaves.

How true, how true this is. If people would be just a little more thankful.

glennfish:

...

You now have a complete store site map.

Enjoy.

Thank you very much - that was easy!

Did you mean table products_to_categories though?

shags38:

Your reply to my query 15 September 2011 - I never offered to pay you - the response indicates that fixing installation problems can be done via a commercial help wanted forum. That post was extremely helpful to me, a user of your mod that had issues, very helpful indeed.

Old 15th September 2011, 07:33 PM #739
a_berezin
Totally Zenned

Join Date: Aug 2004
Location: Saint-Petersburg, Russia
Posts: 1,384

Default Re: How do I get SitemapXML v.2 to work ?
http://www.zen-cart.com/forum/showpo...7&postcount=10
Quote:
Originally Posted by swguy View Post
Fee for service cart maintenance is an important part of the ecosystem. When people report bugs in my contribution, I fix them, but when they report installation difficulties, I direct them to the Commercial Help Wanted forum.
##############################___
Good luck,
Andrew

Now I understand why you can not handle this very primitive setup. You read one thing, but your head is quite another. I sent you to a commercial forum. Where I suggested you do something for money?

Once more:
I have no business with such people. Not for money, not for free.

michellewardley:

I currently have SiteMapXML v 2.1.0 30.04.2009
whats the best way to uprade to the latest version?
Download, copy files to cart, in admin goto Tools - Sitemap XML and click upgrade.

sstawski:

Using Zen v1.3.9h. Using sitemap XML v 3.0.3 27.08.2011 13:11.

The module works great. Thanks. One problem, in stores above 300,000 products, the mod seems to stop after generating 6 sitemapproducts files. It will generate 000 through 006.

Is there a setting to generate above six files, 300,000 products. We have several stores with more than 300,000 products.
I think that simply does not have time because of time limits on the server.
Check the error messages in directory /cache .

Hi,

countrycharm:

How true, how true this is. If people would be just a little more thankful.
The good news is that most people are normal, thankful.

gueston:

I installed it,but when i creat xml files,it said have error for set LANGUAGES,because i deleted one of all language(chinese) files in include folder.
So have error when it creat mainpage ,but it can creat sitemapcategories.xml.why?
And please help me to fix this error.
Thanks
My site http://www.gueston.com
error in
1054 Unknown column 'SITEMAPXML_HOMEPAGE_ORDERBY' in 'order clause'
SELECT * FROM languages l WHERE l.languages_id IN (2,1) ORDER BY SITEMAPXML_HOMEPAGE_ORDERBY]

It seems that you have not finished installing the module.
Go to admin Tools - Sitemap XML - what do you see?

Hello,
I upgraded from an older version of Sitemap XML and now when I go to https://www.site.com/sitemapindex.xml I get the following:
Error loading stylesheet: A network error occurred loading an XSLT stylesheet:

How I can fix?

Thank you,

Hi,

belaze:

Hello,
I upgraded from an older version of Sitemap XML and now when I go to https://www.site.com/sitemapindex.xml I get the following:
Error loading stylesheet: A network error occurred loading an XSLT stylesheet:

How I can fix?

Thank you,

Check your .htaccess file

a_berezin:

For Zen-Cart version 1.3.9f and earlier. Edit includes/.htaccess:
Find
<FilesMatch "..(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF)$">
Replace by
<FilesMatch "..(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF|xsl|XSL)$">

@a_berezin

I have my site online see https://www.airlinersbuyweb.com, now it's time
to get high rankings at google. So I started with Sitemap.

On the forum I found this :

I have Sitemap XML - v 3.0.3 27.08.2011 13:11
ZenCart - v1.3.9h

Where can i find that version, I downloaded :
sitemapxml__formerly_google_sitemap_2-1-0.zip an dI am using v1.3.9h from this version the url's are'nt working anymore ?
and I like to know can we change the php files so it's writes a file (or more) to disk, to being uploaded later to Google and others.

regards,

ceesdk

a_berezin:

Hi,

Check your .htaccess file

Hi,
I should check the .htaccess file in what location?
Also what should I do to the file?

Thanks

belaze:

Hi,
I should check the .htaccess file in what location?
Also what should I do to the file?

Thanks
Once more:
a_berezin:

For Zen-Cart version 1.3.9f and earlier. Edit** includes/.htaccess**:
Find
<FilesMatch "..(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF)$">
Replace by
<FilesMatch "..(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF|xsl|XSL)$">

ceesdk:

@a_berezin

I have my site online see https://www.airlinersbuyweb.com, now it's time
to get high rankings at google. So I started with Sitemap.

On the forum I found this :

Where can i find that version, I downloaded :
sitemapxml__formerly_google_sitemap_2-1-0.zip an dI am using v1.3.9h from this version the url's are'nt working anymore ?
and I like to know can we change the php files so it's writes a file (or more) to disk, to being uploaded later to Google and others.

regards,

ceesdk
Download SitemapXML (formerly "Google Sitemap").

a_berezin:

Download SitemapXML (formerly "Google Sitemap").

Hello,

Is this for version 1.3.9h, because i am getting an error upgrading the database with install-sitemapxml.sql.

The error is : ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!

regards,

ceesdk:

Hello,

Is this for version 1.3.9h, because i am getting an error upgrading the database with install-sitemapxml.sql.

The error is : ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!

regards,

Why You don't read readme???

2. For Zen-Cart 1.5.x. Run install-sitemapxml.sql
   If you are using 1.3.9h, why are you trying to install install-sitemapxml.sql???

a_berezin:

Why You don't read readme???

If you are using 1.3.9h, why are you trying to install install-sitemapxml.sql???

Because i understand from an earlier message that it was also for 1.3.9h !