Google SitemapAdmin

[blag]

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.

[motti]

[FONT=Times New Roman]Hi Woodymon[/FONT]
[FONT=Times New Roman]I took your advice, and I keep it, You are 100 % right [/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Thank you for stoping me [/FONT]

[motti]

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)

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

Thanks

[Woodymon]

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

[blag]

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

Woodymon

I tried using the sqlpatch tool, and that reported errors about missing tables: it even reported the correct database name, prefix and table, but reported the table as missing. In fact as far as I coul tell all was correct, but sql patch wasn't happy about something!!!

[lindasdd]

I was able to load this mod, but when I click: STEP 1: Click [HERE] to create / update your site map.


I only get a blank popup.

-lindasdd

[milobloom]

Can anyone help me with this??

I think I have everything configured right....
I 777'ed the xml files.
Ran the generator:

Processing file: /home/*****/public_html/sitemapproducts.xml OK! Written 1596 records, 335410 bytes
Generated Google Product Sitemap Successfully - http://www.********.com/sitemapproducts.xml

However when I go to look at the file it says:

Google Sitemap http://www.*********.com/sitemapproducts.xml
Number of sitemaps in this Google sitemap index: 0

So it doesnt show any links...

But then I edit the file... And I see the links are there!



What do i do???

[Woodymon]

So it doesn't show any links...
But then I edit the file... And I see the links are there!
What do i do???

I don't understand what is meant by this. What is "it"? When do you see the file does not "show any links"? How would you not know without opening the file in a text editor?

By default the mod should generate four (4) XML files. The index file is:
sitemapindex.xml

And the other three:
sitemapproducts.xml
sitemapcategories.xml
sitemapezpages.xml

(the last file depends on your settings in ZC Admin > Configuration > Google XML Sitemap)

Be sure you have 777 perms on all four files when you are generating them (then recommend turning off write bit when done generating).

The mod should throw an error for each of the four files when you try to generate without the correct perms.

Note, if you did not upload the four xml files from the mod distribution then you have to physically create each xml file (empty file) in a text editor and upload, before the initial sitemap generation.

Hope some of this helps.

Woody

[milobloom]

I have the xml files set to 777
I also made the files blank.

I re ran and tried to recreate the xml files.
It says they are fine. even shows the product counts:

http://www.nothingbutcostumes.com/googlesitemap.php

but when i click on the next link ( to see the products )
it doesn't look like they are written to.

http://www.nothingbutcostumes.com/sitemapproducts.xml

Strange....

[milobloom]

So whats stranger...

If I go in and edit my
http://www.nothingbutcostumes.com/sitemapproducts.xml

and i see lines like this:

<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=7980</loc>
<lastmod>2007-07-05</lastmod>
<changefreq>weekly</changefreq>
<priority>1.00</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=8334</loc>
<lastmod>2007-06-29</lastmod>
<changefreq>weekly</changefreq>
<priority>0.53</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=7783</loc>
<lastmod>2007-07-05</lastmod>
<changefreq>weekly</changefreq>
<priority>0.40</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=975</loc>
<lastmod>2006-07-27</lastmod>
<changefreq>weekly</changefreq>
<priority>0.39</priority>
</url>
<url>
<loc>http://www.nothingbutcostumes.com/index.php?main_page=product_info&amp;products_id=8553</loc>
<lastmod>2007-07-12</lastmod>
<changefreq>weekly</changefreq>
<priority>0.34</priority>
</url>

but if i go to:

http://www.nothingbutcostumes.com/sitemapproducts.xml

I dont see any links....