669 replies to this topic

[princebaskar]

Jack_mcs, on Jan 2 2009, 08:02 PM, said:

A new version has been uploaded. It fixes most of the problems found so far. It may not be necessary but I suggest running the uninstall and install files to reset the pages table (or just empty that one in phpmyadmin). The problem with all of the pages not being counted could have resulted in extra pages being added to that table. It would depend on the setup of the shop so I can't say for sure but it is probably best to clear it.

Jack

Hi Jack, Thanks for the quick reply. Regarding the new version

[Jack_mcs]

jsi, on Jan 2 2009, 04:13 PM, said:

1. When I go to Configuration>SiteMap SEO
I notice you can change the heading text. However it does not support other languages. Is there a fix so it can support more languages? I need to add spanish.

2. Is there a way to add a button to generate a sitemap XML file? sitemap.xml
However, it would be best to not auto send to google. I do advanced SEO manually and its best if I send to google myself after I play with the file. You may want to add a second button to create and send to google for other people if you want but I think its best to keep them separate. Just a generate sitemap.xml file is good enough for me.
What do you think?

Thanx Jack and great work!


P.S.
My site is english/spanish.
I'll give you the spanish translations to this if you want them for others to use. I already translated them. Let me know if you would like this.

1 - Hmm, that is a design problem. I had started to add an extra section to do that but then decided on the settings. Obviously, I didn't think that through. I will add that in the next version.

2 - One of this reasons this contribution was written, as opposed to updating the Dynamic Sitemap, which was also mine, is because someone had added an xml sitemap to it. I said from the beginning that that was a mistake, which it still is, as some are finding out. The problem is that the xml sitemap entries won't match the actual url's if a url rewriter, like Ultimate SEO, is installed. That can cause duplicate content problems with the search engines. And since, I think, the majority of sites use a url rewriter, adding xml code to this contribution would introduce the same problem. The best solution is to install the google sitemap contribution by Chemo (v 1.3).

Thank you for the offer of the translations. Please email them if you like and I will add them to the next version.

Jack

[princebaskar]

Jack_mcs, on Jan 2 2009, 08:02 PM, said:

A new version has been uploaded. It fixes most of the problems found so far. It may not be necessary but I suggest running the uninstall and install files to reset the pages table (or just empty that one in phpmyadmin). The problem with all of the pages not being counted could have resulted in extra pages being added to that table. It would depend on the setup of the shop so I can't say for sure but it is probably best to clear it.

Jack

Hi Jack:

There is any possibility to make the code changes manually from Version 1 to 1.1, without uninstall and reinstall the new version?
I made the two proposed code change for the previous feedbacks in a heavy modified site (that I do not have the expertise yet to manage!).
I need the not documented change (the third one):

- Fixed code in sitemap_seo_page_control.php so the checkboxes are updated correctly.

Thanks!

[Jack_mcs]

The only file changes were to the admin/sitemap_seo_page_control.php and admin/includes/functions/sitemap.php files. You can safely upload those to your installation and the contribution will be updated. Although you may want to note what I said about clearing the one table.

Jack

[jsi]

Jack_mcs, on Jan 2 2009, 06:44 PM, said:

The only file changes were to the admin/sitemap_seo_page_control.php and admin/includes/functions/sitemap.php files. You can safely upload those to your installation and the contribution will be updated. Although you may want to note what I said about clearing the one table.

Jack

This is probably faster. However I didnt really follow the clearing table. How does one do that? phpMyAdmin???

Thanx.


- Regarding the Google XML thing, you're right. Its best to keep them apart. Any thoughts on when the next version is coming out for the translation of titles?

Thanx.

P.S. Will send you the spanish versions tomorrow. Kinda booked at the moment.

[Coopco]

Jack_mcs, on Jan 3 2009, 12:02 PM, said:

A new version has been uploaded. It fixes most of the problems found so far. It may not be necessary but I suggest running the uninstall and install files to reset the pages table (or just empty that one in phpmyadmin). The problem with all of the pages not being counted could have resulted in extra pages being added to that table. It would depend on the setup of the shop so I can't say for sure but it is probably best to clear it.

Jack

Hi Jack

One final problem. In the Box Control page, Boxes Individual Control section, I get this.

When I enter a link via Additional Link Control, and then go to the Boxes Individual Control, the Alternate Name and Anchor Text do not retain edits made when I hit update and the changes are not reflected in the sitemap. Also the Sort defaults to 0 after I hit update and the changes are not reflected in the sitemap.

Everything works in the Page Control page.

[Coopco]

Coopco, on Jan 3 2009, 05:33 PM, said:

Hi Jack

One final problem. In the Box Control page, Boxes Individual Control section, I get this.

When I enter a link via Additional Link Control, and then go to the Boxes Individual Control, the Alternate Name and Anchor Text do not retain edits made when I hit update and the changes are not reflected in the sitemap. Also the Sort defaults to 0 after I hit update and the changes are not reflected in the sitemap.

Everything works in the Page Control page.

Yikes, another problem.

When logged in, only the checked registered pages on Box Control and Pages Control are shown. eg I have logoff.php checked and login.php unchecked, and when logged in log off shows an d log in does not show. A bad example, here is another, I have allprods.php unchecked and it shows on the sitemap when not logged in, but when logged in, it does not show.

[e-peoples]

Jack_mcs, on Jan 3 2009, 02:05 AM, said:

1 - I just uploaded a new version that will fix this problem.

2 - Is Articles Manager enabled in the admin->configuration settings? Does the articles box show up in the Boxes Group Control section? Is it not marked as excluded or registered only?

Jack

Hi Jack,

1 - the problem still exists. Up to the 36th page, everything works well, but then ... nothing. As you see, the 37th page is "products_new.php", and the 36th page is "products_reviews_rewrite.php". For the last pages even the "0" for the sort-order doesn`t exist. Has anyone more than 36pages and tested this?

2 - Found the problem ... forgot to say "true" to "Show products in categories". I don't have "articles manager".

Thanx!
Michael

[cartridgekoning]

hi jack

I installed your module, but if I click on 'sitemap' on my homepage, the error

1146 - Table 'verweij_iU0q1osc.TABLE_ARTICLES' doesn't exist

select a.articles_id, ad.articles_name from TABLE_ARTICLES a left join TABLE_ARTICLES_DESCRIPTION ad on ad.articles_id = a.articles_id where a.articles_status = '1' and ad.language_id = '4'

[TEP STOP]

occures
do you have any idea what I've done wrong?

[e-peoples]

cartridgekoning, on Jan 3 2009, 04:13 PM, said:

hi jack

I installed your module, but if I click on 'sitemap' on my homepage, the error

1146 - Table 'verweij_iU0q1osc.TABLE_ARTICLES' doesn't exist

select a.articles_id, ad.articles_name from TABLE_ARTICLES a left join TABLE_ARTICLES_DESCRIPTION ad on ad.articles_id = a.articles_id where a.articles_status = '1' and ad.language_id = '4'

[TEP STOP]

occures
do you have any idea what I've done wrong?

Hey,

maybe you set "articles manager" to "true" without having integrated the contrib "articles manager"? (http://addons.oscommerce.com/info/1709)
Just an idea!

Best
Michael

[cartridgekoning]

whoops your right XD thank you!

[e-peoples]

Jack_mcs, on Jan 3 2009, 03:44 AM, said:

The only file changes were to the admin/sitemap_seo_page_control.php and admin/includes/functions/sitemap.php files. You can safely upload those to your installation and the contribution will be updated. Although you may want to note what I said about clearing the one table.

Jack

Hey Jack,

in your fix, you included the following tag two times in the first checkbox-field-tag (before the "id" an after). Was this your intention?

<?php echo $pageSettings[$p]['excluded']; ?>

I deleted one, and there was no change!

But I'm still fighting with this prob .. 36th page....

Best
Michael

[e-peoples]

o.k. now I figured out some things, which might show the right direction.

I only use the german language in the shop. The rest, is deleted. So in your SQL-File your default language id is "1" ... English! But this doesn't exists any more!
So your SQL-script seems to put the whole pages into the table "sitemap_seo_pages" with "language_id" "2" (german). So far o.K..
For some reasons, the first 36 files I told you, were also put in with "language_id" "0" ???. But unfortunatelly not all pagenames. ????? Don't know why!
For some reasons, these "language_id" constelations causes trouble.

So I manually (via PHPMyAdmin) put the rest of the pages in the table. Now, all "Zeros" for the sort order are displayed.
But the updated still doesn't work correct.

You have some ideas? Here the "Before" and "After" - Pic!

Best Michael

[img]http://www.kultur-wirtschaft.eu/web2008/catalog/SEO-Sitemap_new.gif[/img]

Edited by e-peoples, 03 January 2009, 17:43.

[Jack_mcs]

jsi, on Jan 2 2009, 11:38 PM, said:

This is probably faster. However I didnt really follow the clearing table. How does one do that? phpMyAdmin???

Thanx.


- Regarding the Google XML thing, you're right. Its best to keep them apart. Any thoughts on when the next version is coming out for the translation of titles?

Thanx.

P.S. Will send you the spanish versions tomorrow. Kinda booked at the moment.

There are threads here on how to use phpmyadmin. It is available in the control panel of your hosting account, most likely.

I don't know when the next version will be.

Jack

[Jack_mcs]

Coopco, on Jan 3 2009, 02:04 AM, said:

Yikes, another problem.

When logged in, only the checked registered pages on Box Control and Pages Control are shown. eg I have logoff.php checked and login.php unchecked, and when logged in log off shows an d log in does not show. A bad example, here is another, I have allprods.php unchecked and it shows on the sitemap when not logged in, but when logged in, it does not show.

Yes, I see this problem. The fix for it is more than I can do quickly here but I will get to it in the next version.

For the Additional Link Control problem in your other post, have you installed the latest version? That should have been fixed with it.

Here is the link to the Google Sitemap contribution I mentioned. I use the last one by Chemo.

Jack

[Jack_mcs]

cartridgekoning, on Jan 3 2009, 10:13 AM, said:

hi jack

I installed your module, but if I click on 'sitemap' on my homepage, the error

1146 - Table 'verweij_iU0q1osc.TABLE_ARTICLES' doesn't exist

select a.articles_id, ad.articles_name from TABLE_ARTICLES a left join TABLE_ARTICLES_DESCRIPTION ad on ad.articles_id = a.articles_id where a.articles_status = '1' and ad.language_id = '4'

[TEP STOP]

occures
do you have any idea what I've done wrong?

It sounds like you don't have the Articles Manager contribution installed but do have that option enabled in the sitemap settings.

Jack

[Jack_mcs]

e-peoples, on Jan 3 2009, 12:40 PM, said:

o.k. now I figured out some things, which might show the right direction.

I only use the german language in the shop. The rest, is deleted. So in your SQL-File your default language id is "1" ... English! But this doesn't exists any more!
So your SQL-script seems to put the whole pages into the table "sitemap_seo_pages" with "language_id" "2" (german). So far o.K..
For some reasons, the first 36 files I told you, were also put in with "language_id" "0" ???. But unfortunatelly not all pagenames. ????? Don't know why!
For some reasons, these "language_id" constelations causes trouble.

So I manually (via PHPMyAdmin) put the rest of the pages in the table. Now, all "Zeros" for the sort order are displayed.
But the updated still doesn't work correct.

Did you clear the pages table as suggested? Do you have other languages declared in admin? The code will fill in the information but it uses the languages from the shop. So if it is writing the wrong language ID, it is either because you have more than one declared or there's a mistake in the code. Please let me know how your languages are setup, i.e., only German and it is ID2, or whatever way it is. I can then duplicate it here to get the same failure.

Jack

[Coopco]

Jack_mcs, on Jan 4 2009, 02:28 PM, said:

Yes, I see this problem. The fix for it is more than I can do quickly here but I will get to it in the next version.

For the Additional Link Control problem in your other post, have you installed the latest version? That should have been fixed with it.

Here is the link to the Google Sitemap contribution I mentioned. I use the last one by Chemo.

Jack

Hi Jack

Yes, I installed the latest version. Will have another play with it and let you know.

Thanks, I did finally find the Google Sitemap, but v1.3 worked on the wamp server but not the web host (fpopen is disallowed), so I used the On The Fly - Fixed problem with Categories, also written by Chemo, with no products in the same location. Worked like a charm.

[e-peoples]

Jack_mcs, on Jan 4 2009, 04:36 AM, said:

Did you clear the pages table as suggested? Do you have other languages declared in admin? The code will fill in the information but it uses the languages from the shop. So if it is writing the wrong language ID, it is either because you have more than one declared or there's a mistake in the code. Please let me know how your languages are setup, i.e., only German and it is ID2, or whatever way it is. I can then duplicate it here to get the same failure.

Jack

I didn`t clear the table yet ... but i´ll do so soon. In Admin there`s only german with ID "2" ... as in the "language"-table in DB.

Thanx again
Michael

[minionsweb]

Nice contrib!

I am however not having issues as related by the others.
The installation was simple
The instructions could use a slight bit of improvement, and some of the features explained a tad better for dopes like me.

I am having an output issue.
If you look at my resultant sitemap and compare it to the category tree the mapping is terrible.
I suspect this is due to a very peculiar tree contrib I am using (which still does not meet my needs!)

So - is this modeled to use a particular categories tree contrib, and or the stock contrib?


Additionally if anyone knows of a expand all subcategories contrib that goes deeper than 3 subs, I would appreciate the heads up.
Especially if it will work with this sitemap!

Corey