Google SitemapAdmin

[kbalona]

OK, I added 'zen_' to the table names before I ran the patch. I then ran it through phpmyadmin, and it said " Your SQL query has been executed successfully". But still no Google Sitemap Admin link in Admin>Tools! When I try running the modified SQL through the Zencart Install SQL Patches function, it says:

1146 Table 'edgeande_zc2.zen_zen_configuration' doesn't exist
in:
[DELETE FROM zen_zen_configuration WHERE configuration_group_id = @configuration_group_id;]
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.

It's trying to add the prefix double! Yet when I run the SQL patch unmodified, it can't find the tables.

[Pixxi]

If you run the SQL through admin->tools->install SQL patches it should add the 'zen_' prefix automatically to the table names in the SQL.

... you've already manually put the prefix in the SQL, so you will get it twice if you run the patch through admin ...

If the patch ran successfully via phpMyAdmin, then you should find the entries in your configuration and configuration_group tables in your database - in other words, the SQL has worked.

Check that you've uploaded all the files in the mod to the right places on your site.

[kbalona]

... you've already manually put the prefix in the SQL, so you will get it twice if you run the patch through admin ...

But when I don't enter the prefix manually, it can't find the table. I've tried every possible thing, it seems, and it still doesn't work. I've downloaded & uploaded for the third time, tried numerous modifications to the SQL patch, but still doesn't show up in admin>tools. When I add the 'zen_' prefix to all the configuration areas except the DELETE FROM sections, and run it through the Admin Install SQL Patches, it will process 8 statements but come back with this error:

ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration_group does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_configuration does not exist. CHECK PREFIXES!

But they DO exist! I can see them in PHPMyAdmin!

[Pixxi]

You're getting two different things mixed up:

1. The SQL puts the options in the database tables that show up under admin->configuration->google xml sitemap - from what you've said, you've run the SQL successfully via phpMyAdmin.

If the 'Google Sitemap XML' link appears under admin->configuration, then forget the SQL now, that's done.

2. IIRC, the sitemap link in the tools menu is generated from the files being in the correct folders on your server - make sure you have all the files from the mod in the correct folders, especially admin/includes/boxes/extra_boxes/googlesitemap_tools_dhtml.php.

[kbalona]

Well, all the files are present, that I can tell. The thing is, what I've gathered from previous posts in the thread, people that had this same problem hadn't installed the SQL patch. That's why I thought it must be that. Also, the link in admin>configuration showed up before I did anything to the DB. I'm totally stumped.

[Pixxi]

Do you have the 'Admin Levels' or 'Admin Profiles' mod installed?

[kbalona]

No. Neither of them.
I did finally generate the sitemap by running googlesitemap.php from cpanel's File Manager. I set up the cron task, too. so maybe I'll just have to do it that way.

[kbalona]

LOL! I figured out what my problem was, and it makes me look totally stupid. I have a renamed Zencart admin folder, so the files from GSA Admin folder weren't going in. I copied them over to the renamed Zen admin, and now I have the link in >Tools.

[Alex Clarke]

Excellent!

Glad you got things working. :)

[magicpants]

Thanks for the contrib, Andrew.

I've been using this for a while, but my shop is in a folder: http://mysite.com/catalog

So, I had to place these files in the folder, rather than the root -- and register with google webmaster tools with the folder included, instead of our normal web address http://mysite.com

I'd prefer to move these files to my root -- any way to solve this?