Zen Cart Logo
Forums / All Other Contributions/Addons / Google SitemapAdmin

Google SitemapAdmin

Views: 229,048

Results 361 to 380 of 842
27 May 2007, 22:42
#361
wccomp avatar

wccomp

New Zenner

Join Date:
May 2007
Location:
Little Rock, AR.
Posts:
58
Plugin Contributions:
0

Google SitemapAdmin

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

30 May 2007, 20:21
#362
alphalion avatar

alphalion

New Zenner

Join Date:
Sep 2006
Posts:
19
Plugin Contributions:
0

Re: Google SitemapAdmin

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

30 May 2007, 23:44
#363
alphalion avatar

alphalion

New Zenner

Join Date:
Sep 2006
Posts:
19
Plugin Contributions:
0

Re: Google SitemapAdmin

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

31 May 2007, 05:09
#364
adnimas5 avatar

adnimas5

Zen Follower

Join Date:
Dec 2005
Posts:
117
Plugin Contributions:
0

Re: Google SitemapAdmin

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

05 Jun 2007, 12:18
#365
vampke avatar

vampke

New Zenner

Join Date:
May 2007
Posts:
4
Plugin Contributions:
0

Re: Google SitemapAdmin

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?

05 Jun 2007, 13:22
#366
enderandrew avatar

enderandrew

New Zenner

Join Date:
Jun 2007
Posts:
46
Plugin Contributions:
0

Re: Google SitemapAdmin

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

12 Jun 2007, 05:31
#368
ericny avatar

ericny

Zen Follower

Join Date:
Jan 2007
Posts:
100
Plugin Contributions:
0

Re: Google SitemapAdmin

Thank you for a great contribution.

I downloaded the latest version from
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_60&products_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.

20 Jun 2007, 20:07
#369
ericny avatar

ericny

Zen Follower

Join Date:
Jan 2007
Posts:
100
Plugin Contributions:
0

Re: Google SitemapAdmin

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

https://siteexplorer.search.yahoo.com/submit

21 Jun 2007, 07:56
#370
a_berezin avatar

a_berezin

Deceased

Join Date:
Aug 2004
Location:
Saint Petersburg, Russia
Posts:
1,782
Plugin Contributions:
5

Re: Google SitemapAdmin

ericny:

  1. 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."
    Check up presence of a file gss.xsl in root directory.

kelvyn:

that's because you're not supposed to see it! It's not for human eyes
Again speak that itself do not know. Specially for human eyes the table of styles gss.xsl was added.

ericny:

It looks like yahoo now understands sitemap.xml.
Yes. I already spoke about it almost year back. See http://www.zen-cart.com/forum/showpost.php?p=295950&postcount=137
ericny:

It can be submitted at the following link

https://siteexplorer.search.yahoo.com/submit

Ok, I add link to the Yahoo! Ping service. Wait when will be updated download area.

22 Jun 2007, 04:59
#371
ericny avatar

ericny

Zen Follower

Join Date:
Jan 2007
Posts:
100
Plugin Contributions:
0

Re: Google SitemapAdmin

a_berezin:

Check up presence of a file gss.xsl in root directory.

I do not have gss.xsl in my root directory. Where can I get one? What is it supposed to contain?

If it is a generic file can someone e-mail it to me please?

22 Jun 2007, 05:47
#372
a_berezin avatar

a_berezin

Deceased

Join Date:
Aug 2004
Location:
Saint Petersburg, Russia
Posts:
1,782
Plugin Contributions:
5

Re: Google SitemapAdmin

gss.xsl is a part of Google SitemapAdmin contribution.

26 Jun 2007, 03:25
#373
ericny avatar

ericny

Zen Follower

Join Date:
Jan 2007
Posts:
100
Plugin Contributions:
0

Re: Google SitemapAdmin

a_berezin:

gss.xsl is a part of Google SitemapAdmin contribution.

WORKS! Thank you :)

26 Jun 2007, 07:06
#374
a_berezin avatar

a_berezin

Deceased

Join Date:
Aug 2004
Location:
Saint Petersburg, Russia
Posts:
1,782
Plugin Contributions:
5

Re: Google SitemapAdmin

v. 1.3.12 21.06.2007

  1. Add links to Yahoo!.
27 Jun 2007, 13:21
#375
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google SitemapAdmin

a_berezin:

v. 1.3.12 21.06.2007

  1. Add links to Yahoo!.

Thanks for the update. The Udate SQL is generating the following error:

**MySQL said:

#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 '' at line 8**

28 Jun 2007, 06:34
#376
a_berezin avatar

a_berezin

Deceased

Join Date:
Aug 2004
Location:
Saint Petersburg, Russia
Posts:
1,782
Plugin Contributions:
5

Re: Google SitemapAdmin

Sorry. Don't use update_1_3_12.sql patch!!!! :blush:

28 Jun 2007, 19:41
#377
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google SitemapAdmin

a_berezin:

Sorry. Don't use update_1_3_12.sql patch!!!! :blush:

Andrew, thanks for the response. Which file is generated for Yahoo site explorer? Currently I am using a urllist.txt that I manually create from your google froogle mod but I'd like the option to automate the generation of Yahoo site explorer. Can you please give some info on how this is suppose to work with Yahoo site explorer?

Thanks!

28 Jun 2007, 22:36
#378
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google SitemapAdmin

kelvyn:

Yahoo SiteExplorer uses exactly the same files as Google - it's all standardised. You don't need urllist.txt any more

See this blog entry for details

Thanks Kelvyn! So do I replace my urllist.txt with sitemapindex.xml?

28 Jun 2007, 22:52
#379
blessisaacola avatar

blessisaacola

Totally Zenned

Join Date:
Feb 2004
Location:
Georgia, USA
Posts:
1,875
Plugin Contributions:
1

Re: Google SitemapAdmin

kelvyn:

I'd suggest following that blog post, becuase what you need to do is see how to put the sitemapindex into robots.txt for a start, and also you'll need to make a login for Yahoo so you can add and track how your site is being spidered - pretty much the same as Google Webmasters does.

Actually, I already have the information for Google, Yahoo and MSN in my robot.txt.

Google Sitemap requires an index sitemap to use to identify the list and Yahoo explorer also requires a file if you're using site explorer. I was basically asking a simple question of which file to put in accounts I have been using with Yahoo for months.

Google is smart enough to read my sitemapindex.xml and go from there to grab the category, product and ezpages xml file. I am not sure how Yahoo Explorer works which is why I was asking.

The robot.txt instruction is different from how Yahoo Site Explorer and Google Sitemap works. Although, both methods are after the same information, it never hurts to give different ways for search engine to find information.

05 Jul 2007, 17:52
#380
storybook avatar

storybook

New Zenner

Join Date:
Jun 2007
Location:
Wagener, SC
Posts:
27
Plugin Contributions:
0

Re: Google SitemapAdmin

Ok, I guess this will be a newbie question, but I've read everything I can find on this mod, and I can't find my answer...

I have v1.3.12 of this mod, and a pretty fresh install of Zen 1.3.7

The install instructions for the Sitemap mod reference, in step #2, a file called googleanalytics.sql. This file does not exist in the mod package.

Am I missing something???

StoryBook