Google SitemapAdmin

Greetings

I have had Google Sitemap up and functioning [on 2 sites] for several weeks, THANKS for a great product!!!

• Today I installed the Admin Patch and the XSS patch on [BOTH SERVERS]. bulklights.com AND liberty-flag.com.
• I changed the admin folder on [BOTH SERVERS] and made the appropriate config.php changes.
  The bulklights.com Sitemap works GREAT!
  The liberty-flag.com Sitemap opens the popup window and times out with a resulting -

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

Save path - "/home/content/l/i/b/libflag/html/"
Base URL - "http://www.liberty-flag.com/"
and nothing more. I renamed the old sitemapindex.xml and the other .xml files and tried running it again to no availe.

The only other difference between the two sites is that on liberty-flag.com I tried toying with EZ-Pages. I created a page then deleted it.

Any other ideas or clues needed?

Thanks for your help
JOhn ><>

LibertyFlag:

Greetings

I have had Google Sitemap up and functioning [on 2 sites] for several weeks, THANKS for a great product!!!

• Today I installed the Admin Patch and the XSS patch on [BOTH SERVERS]. bulklights.com AND liberty-flag.com.

• I changed the admin folder on [BOTH SERVERS] and made the appropriate config.php changes.The bulklights.com Sitemap works GREAT!

The liberty-flag.com Sitemap opens the popup window and times out with a resulting -

and nothing more. I renamed the old sitemapindex.xml and the other .xml files and tried running it again to no availe.

The only other difference between the two sites is that on liberty-flag.com I tried toying with EZ-Pages. I created a page then deleted it.

When I run from the ie command line I get!
http://www.liberty-flag.com/googlesitemap.php

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

Save path - "/home/content/l/i/b/libflag/html/"
Base URL - "http://www.liberty-flag.com/"

Processing file: /home/content/l/i/b/libflag/html/sitemapproducts.xml OK! Written 2440 records, 492156 bytes
Generated Google Product Sitemap Successfully - http://www.liberty-flag.com/sitemapproducts.xml

Processing file: /home/content/l/i/b/libflag/html/sitemapcategories.xml OK! Written 456 records, 87576 bytes
Generated Google Category Sitemap Successfully - http://www.liberty-flag.com/sitemapcategories.xml

ERROR: Google Category Sitemap Generation FAILED!

Processing file: /home/content/l/i/b/libflag/html/sitemapindex.xml OK! Written 2 records, 606 bytes
Generated Google Sitemap Index Successfully - http://www.liberty-flag.com/sitemapindex.xml

Total Execution Time 1:0.7201

JOhn ><>

pivey:

Well, following to the older forum topic
http://www.zen-cart.com/forum/showthread.php?t=28492&highlight=sitemaps

I have a question regarding this mod.
I have a 3 languages store, so when the sitemap is genarated, links like these accour, displaying the lang ID as well:

.....main_page=product_info&language=GR&products_id=1104
or
....main_page=product_info&language=DE&products_id=2364

Any suggestions?

Dimi
Looks like everything is working fine, using Google Sitemap Generation (v 1.3.7 )
No errors,

I have a question regarding the actual sitemap listing at Google:
since my path is set to the following:
Save path - "/home/"directory"/public_html/"
Base URL - "http://domain.com/" I have had to setup my google webmaster to also reflect this instead of http://WWW.domain.com

all sitemaps paths come up WITHOUT the https://www.domain.com but instead display http://domain.com
will this cause a problem with site ranking or crawlers? how do i change this so that the site BASE URL shows up with http://www.domain.com.

Wolf

Kelvyn,
I am currently using google sitemap 1.3.7 and would like to update to 1.3.12(or the latest). since I already have 1.3.7 installed can I just overwrite the files. I also noticed that in the 1.3.12 file system there are update squl files (2,3 and4). If I was to update do I also install these patches the same way as the install.sql (cut and past)?
Wolf

I got this error trying to install Google Sitemaps.

Fatal error: Call to undefined function zen_get_info_page() in /home/public_html/admin/googlesitemap.php on line 259

This happens when I click on the Google Sitemap link under
Tools.

Hi all,

I tried to install the 1.3.12 version of this mod to my 1.3.7 zen cart and after installing the install.sql patch in my admin, I got this error '8 statements processed. Cannot insert configuration_key "" because it already exists. 1 statements ignored'.

Any help appreciated !

Thanks !
Shirley :)

shirster:

I got this error '8 statements processed. Cannot insert configuration_key "" because it already exists. 1 statements ignored'.

Shirley :)

Shirster, I had the same problem. Uninstall and then re-insert the SQL statements through phpMyAdmin. It went through for me fine and it works - except I get this error when I generate the XML files:

ERROR: Google Category Sitemap Generation FAILED!

The files seem to work okay - though I don't know if it is only writing some of them. And, I don't know if that error is connected to your problem - but try inserting through phpMyAdmin and see how it works for you.

I have instelled this excellent mod, and AFAIK the installation was a success, once I but I find that I seem to have some things duplicated in my Admin>Configuration>Google XML Sitemap. Here is the list of 'variables'
Compress XML File
Products changefreq
Category changefreq
Category priority
EZPages changefreq
EZPages priority
EZPages changefreq
EZPages priority
Lastmod tag format
Products priority
Use Google Sitemaps Stylesheet
Use Google Sitemaps Stylesheet
XML directory
XML directory
EZPages Header
EZPages Sidebox
EZPages Footer
EZPages Header
EZPages Sidebox
EZPages Footer

I don't suppose the duplication really matters, and I don't know whether this question has been asked before, but for the sake of tidiness, could anyone please instruct me as to how I might eliminate this problem?

I have a few questions:

1. Is this the right one: http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_60&products_id=544
2. Will this work with the Ultiamte URL addon?(Using both find_path and mod_rewrite)
3. Assuming both of those are yesses do I need to install all of the SQL patches, or just the install one?

Please, does anyone know if this will work with the Ultimate URL addon?

Hi

I purchase a site map for my whole sites and install it, I need to uninstall the site map mod I got from here.
How do I install it? And there is any file was override I need to modify or change while doing this uninstalls?

Thank you

magicpants:

It went through for me fine and it works - except I get this error when I generate the XML files:

ERROR: Google Category Sitemap Generation FAILED!

The files seem to work okay - though I don't know if it is only writing some of them.
Are you certain you created sitemapcategories.xml and set proper write permissions on the file before attempting to generate the feed?

Woody

blag:

I have instelled this excellent mod, and AFAIK the installation was a success, once I but I find that I seem to have some things duplicated in my Admin>Configuration>Google XML Sitemap. Here is the list of 'variables'

I don't suppose the duplication really matters, and I don't know whether this question has been asked before, but for the sake of tidiness, could anyone please instruct me as to how I might eliminate this problem?

Easiest would be to run the uninstall.sql (included the mod zip archive). Then run install.sql again.

If that does not work you can track down the relevant entries in the configuration table in your ZC database via phpymyadmin and delete each manually.

You might want to document your various mod settings before doing this.

And I recommend first backing up ... of course.

Woody

motti:

Hi

I purchase a site map for my whole sites and install it, I need to uninstall the site map mod I got from here. How do I install it? And there is any file was override I need to modify or change while doing this uninstalls?

Uninstall with uninstall.sql that comes with the mod. Then remove the mod files you uploaded. No core Zen Cart files are altered when installing this mod.

Note the Google Sitemap module for Zen Cart which we are referring to in this thread and other sitemaps are different animals. This mod just uploads your info to Google so Google has more info on what to crawl on your site (and also generates helpful webmaster related suggestions about your sites on your domain).

The sitemap application you purchased likely just generates a sitemap file for your entire domain which then you post a link on your sites pages. It likely has no overlap with Google Sitemap.

Can you provide a URL to the program you purchased?

Note Zen Cart also comes with it's own built-in sitemap functionality, which you can also disable but I don't recommend.

It's all just spider food!

Good luck.

Woody

Hi

This is the link http://www.xml-sitemaps.com/

Let me know what you think, i will wait on the un install

Thank you and Night

motti:

This is the link http://www.xml-sitemaps.com/
Let me know what you think, i will wait on the un install

This is off-topic for this thread. With that said I just don't see the big advantage.

Besides generating a sitemap for and pinging Google, the product does the same for Yahoo and Ask. It is inexpensive and you do get free support and only pay a little more for installation.

But it is not Zen Cart specific and it is unclear if some or all of your shop product pages, category pages and other shop pages will be included in the various feeds generated.

Woody

Woodymon:

Easiest would be to run the uninstall.sql (included the mod zip archive). Then run install.sql again.

If that does not work you can track down the relevant entries in the configuration table in your ZC database via phpymyadmin and delete each manually.

You might want to document your various mod settings before doing this.

And I recommend first backing up ... of course.

Woody
Woodymon

Thanks for the help. I couldn't delete the entries using the uninstall.sql file - said it couldn't find the configuration_groups table. So I used phpMyAdmin and (taking a deep breath and closing my eyes, crossing my fingers, stroking my lucky rabbit's foot etc.) deleted the entries in the relevant tables and then used the install patches just to run the install.sql file. I realised that I had previously also run all of the update sql files, hence, presumably, the duplication.

Hi Woodymon
I took your advice, and I keep it, You are 100 % right

Thank you for stoping me

Hi

After long long day, I change my directory so I don’t have the /store in it, and I am able to use this mod ( any one like to buy $20.00 site map for a ?0.01) :smile:

Can some one direct me to where I saw what files should be in the Disallow in the Robots.txt

Thanks

blag:

Woodymon

Thanks for the help. I couldn't delete the entries using the uninstall.sql file - said it couldn't find the configuration_groups table. So I used phpMyAdmin and (taking a deep breath and closing my eyes, crossing my fingers, stroking my lucky rabbit's foot etc.) deleted the entries in the relevant tables and then used the install patches just to run the install.sql file. I realised that I had previously also run all of the update sql files, hence, presumably, the duplication.

It is likely you have a prefix (e.g. zen_) on your db tablenames and thus uploading the uninstall.sql through Zen Cart's sqlpatch tool did not work for you. In these cases try pasting the sql code into the sqlpatch tool edit box.

It's strange that you would have duplicate entries (table records) with the exact same parameters (fields) in your related db tables. When running a SQL statement which would duplicate pre-existing records in a table, by default MySQL should report back the record already exists, and not update the table with those particular records.

But if doubt and you are having issues (and you know what you are doing) phpmyadmin is the way to go.

Woody