Google SitemapAdmin

[wccomp]

When I goto create the file this is what I'm getting

Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started

Save path - "/home/wccomput/public_html/"
Base URL - "http://wccomputers.sashbox.net/"

Processing file: /home/wccomput/public_html/sitemapproducts.xml OK! Written 1700 records, 349474 bytes
Generated Google Product Sitemap Successfully - http://wccomputers.sashbox.net/sitemapproducts.xml


Fatal error: Maximum execution time of 30 seconds exceeded in /home/wccomput/public_html/googlesitemap.php on line 347


Anyone have any ideas whats wrong? I've followed all the instructions.

Thanks

[AlphaLion]

Hi,
Just wondering, how long does this sitemap generation usually take?
This is my first time using this.

So far, this is all I get:
----------------------------------------------------------------------------------
Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started

Save path - "/var/www/html/"
Base URL - "http://www.alphalion.com/"

----------------------------------------------------------------------------------

It's been a good 30 minutes or so.
I have about 3500 products.

Thanks

[AlphaLion]

OK,
This mod isn't working on that site (see previous post).
However, I installed it on a sub-domain and it is working fine there.
I get no error message or any other indication of a problem, other than the fact that no sitemaps are generated, on my primary domain.

Any help with this would be appreciated.

Thanks

[adnimas5]

I have Google site map gernerator contribution installed in several of my stores. They all work great, except one store that I have located in a 2nd level directory. (www.mydomain/store).

i tried different methods to trick google to work with the generated sitmapindex.xml. Nothing succeeded.

Has anyone else encoutered this? Any input?

Thank you,
Sam

[vampke]

When trying to install this mod i get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'),'), (NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FR' at line 1
in:
[INSERT INTO zenconfiguration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'), (NULL, 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'), (NULL, 'Lastmod tag format', 'GOOGLE_SITEMAP_LASTMOD_FORMAT', 'date', 'Lastmod tag format:
date - Complete date: YYYY-MM-DD (eg 1997-07-16)
full - Complete date plus hours, minutes and seconds: YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array('date', 'full'),'), (NULL, 'Category priority', 'GOOGLE_SITEMAP_CAT_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL), (NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 5, NOW(), NULL, NULL), (NULL, 'Use Google Sitemaps Stylesheet', 'GOOGLE_SITEMAP_USE_XSL', 'true', 'Google Sitemaps Stylesheet gss.xsl', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'XML directory', 'GOOGLE_SITEMAP_XML_FS_DIRECTORY', '', 'Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.', @configuration_group_id, 7, NOW(), NULL, NULL), (NULL, 'EZPages Header', 'GOOGLE_SITEMAP_EZPAGES_HEADER', 'true', 'Use EZPages Header links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'EZPages Sidebox', 'GOOGLE_SITEMAP_EZPAGES_SIDEBOX', 'true', 'Use EZPages Sidebox links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'EZPages Footer', 'GOOGLE_SITEMAP_EZPAGES_FOOTER', 'true', 'Use EZPages Footer links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'EZPages changefreq', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_FREQ', 'weekly', 'How frequently the EZPages pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array('always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),'), (NULL, 'EZPages priority', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_PRIOR', '0.5', 'The default priority of the EZPages URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

who can help?

[enderandrew]

Where might I find the latest version and it is compatible with 1.3.7?

[ericny]

Where might I find the latest version and it is compatible with 1.3.7?

http://www.zen-cart.com/index.php?ma...roducts_id=544

[ericny]

Thank you for a great contribution.

I downloaded the latest version from
http://www.zen-cart.com/index.php?ma...roducts_id=544


I almost got it working for me (google gave me sitemap status OK). I used install_googlesitemap.php to install. However I still have the following issues.
1. I can see Admin->Configuration->Google XML Sitemap but I cannot
see Admin->Tools->Google however I am able to generate sitemap files by
typing www.mysite.com\googlesitemap.php in the browser.

2. I changed permissions to 777 for sitemap*.xml files but when I click
on the link after the sitemap files have been generated i get:
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
The system cannot locate the object specified."

3. From security perspective is it safe to leave googlesitemap.php in the URL that anyone can execute from the browser?

4. Can i use the same sitemap files and load them into Yahoo, MSN etc.?

Your suggestions are appreciated.

[kelvyn]

Thank you for a great contribution.

I almost got it working for me (google gave me sitemap status OK). I used install_googlesitemap.php to install. However I still have the following issues.
1. I cannot see admin > Tools > Google

There is no admin > Tools > Google! It's
Admin->Tools->Google XML Sitemap

2. I changed permissions to 777 for sitemap*.xml files but when I click
on the link after the sitemap files have been generated i get:
"The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
The system cannot locate the object specified."

Well, that's because you're not supposed to see it! It's not for human eyes - you need to go to http://www.google.com/webmasters/tools/sitemaps as per the instructions, and make the account and verify your site.

3. From security perspective is it safe to leave googlesitemap.php in the URL that anyone can execute from the browser?

Don't see why not - all it does is generate the map. The worst that could happen is that if you have a HUGE store and someone kept clicking it, it might put the server under a bit of load. But then they could do that by clicking "all products" a lot, too!

4. Can i use the same sitemap files and load them into Yahoo, MSN etc.?

Forget about MSN, it accounts for <3% of anything. As for Yahoo, I thought it only understood urllist.txt lists, however it seems that it is now supports xml sitemaps.

[ericny]

I was able to get it to work and submit to Google.
Thank you everyone.

It looks like yahoo now understands sitemap.xml. It can be submitted at the following link

[FONT=Helv]https://siteexplorer.search.yahoo.com/submit
[/FONT]