SitemapXML v.2

[lindasdd]

As an experienced mod installer (I try everything under the sun) I ran into two install problems - both of which were my own (PEBKAC).

1. First I tried installing the sql file even though I'm not using 1.5 (wow, I know.)
2. Second I have the really old former version of this program installed. On my initial attempts to upgrade I didn't realize the Admin screens have new names - even though in the readme the new names are indicated.

Just thought those errors might help some others having the same frustrations.

Once I corrected my own errors this module installed beautifully. I'm actually quite impressed by how hands off this is considering the files it creates - all it actually required was an FTP of files.

-lindasdd

[Thannaree]

Hello,

I am trying and upgrade from version 2-1-0.

I've uploaded all files to my store directory.

When I hit the "Upgrade SitemapXML SQL" link under Tools > Sitemap XML, a blank page appears and nothing seems to happen.

Can someone please advise?

Thank you.

[a_berezin]

Hi,

Hello,

I am trying and upgrade from version 2-1-0.

I've uploaded all files to my store directory.

When I hit the "Upgrade SitemapXML SQL" link under Tools > Sitemap XML, a blank page appears and nothing seems to happen.

Can someone please advise?

Thank you.

1. Zen-Cart version?
2. Check files /cache/myDEBUG-*.log

[Thannaree]

1. Zen-Cart version?

v1.3.9h


2. Check files /cache/myDEBUG-*.log

PHP Warning: require_once(includes/classes/ext_modules.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in /MYADMIN/sitemapxml.php on line 122

[03-Oct-2011 01:56:00] PHP Fatal error: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/classes/ext_modules.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /MYADMIN/sitemapxml.php on line 122

[a_berezin]

PHP Warning: require_once(includes/classes/ext_modules.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in /MYADMIN/sitemapxml.php on line 122

This is the answer to your question - you did not download all files.

[Thannaree]

This is the answer to your question - you did not download all files.

Ah! I indeed did not upload a couple of files. Thanks a lot a_berezin!

I have 2 extra questions:
1) the sitemap.xml file is empty, is that normal? by the way is that file at all necessary?
2) I can see the si​tem​api​nde​x.x​ml under google webmaster tools. Am I to submit anything else there manually?

[a_berezin]

1) the sitemap.xml file is empty, is that normal? by the way is that file at all necessary?

If you use si​tem​api​nde​x.x​ml as sitemap index file - you also can delete sitemap.xml file.

2) I can see the si​tem​api​nde​x.x​ml under google webmaster tools. Am I to submit anything else there manually?

No. Nothing more to do in Google does not need.

You can add an entry Sitemap to the file robots.txt - http://www.sitemaps.org/protocol.php#submit_robots

[Thannaree]

If you use si​tem​api​nde​x.x​ml as sitemap index file - you also can delete sitemap.xml file.

No. Nothing more to do in Google does not need.

You can add an entry Sitemap to the file robots.txt - http://www.sitemaps.org/protocol.php#submit_robots

The si​tem​api​nde​x.x​ml appears to be the main sitemap. I've deleted sitemap.xml and indicated sitemapindex.xml as the sitemap in robots.txt.

Many thanks again for your help a_berezin!

[enzo-ita]

Hi,
after installing when I run in admin tools, I get this message
#####################################################################
SiteMapXML (3.0.3 27.08.2011 13:11)

Categories Sitemap

File http://www.acquatua.it/sitemapcategories.xml. Written 17 items (3318 bytes), Filesize: 3327 bytes
Total: files 1, items 17 (3327 bytes), execution time 0:0.0105, db queries 58, db queries time 0:0.0048.
Ezpages Sitemap

1146 Table 'acquatua_zenen.ezpages_content' doesn't exist
in:
[SELECT p.toc_chapter FROM ezpages p LEFT JOIN ezpages_content pt ON (p.pages_id = pt.pages_id) WHERE alt_url_external = '' AND ( (status_header = 1 AND header_sort_order > 0) OR (status_sidebox = 1 AND sidebox_sort_order > 0) OR (status_footer = 1 AND footer_sort_order > 0) ) AND status_toc != 0 AND pt.languages_id IN (2) GROUP BY toc_chapter]
#############################################################
I do not understand why that table is not there.
What should I do to correct this?
thanks
enzo

[josh.lapin]

Hi,
after installing when I run in admin tools, I get this message
#####################################################################
SiteMapXML (3.0.3 27.08.2011 13:11)

Categories Sitemap

File http://www.acquatua.it/sitemapcategories.xml. Written 17 items (3318 bytes), Filesize: 3327 bytes
Total: files 1, items 17 (3327 bytes), execution time 0:0.0105, db queries 58, db queries time 0:0.0048.
Ezpages Sitemap

1146 Table 'acquatua_zenen.ezpages_content' doesn't exist
in:
[SELECT p.toc_chapter FROM ezpages p LEFT JOIN ezpages_content pt ON (p.pages_id = pt.pages_id) WHERE alt_url_external = '' AND ( (status_header = 1 AND header_sort_order > 0) OR (status_sidebox = 1 AND sidebox_sort_order > 0) OR (status_footer = 1 AND footer_sort_order > 0) ) AND status_toc != 0 AND pt.languages_id IN (2) GROUP BY toc_chapter]
#############################################################
I do not understand why that table is not there.
What should I do to correct this?
thanks
enzo

thats weird, everyone swears it works perfectly right out of the gate but yet there is a support thread 30 pages long!