SitemapXML v.2

[ckosloff]

The remote server's sitemapcategories.xml does not have <lastmod></lastmod> tags.

Hey Juxi, long time no see.
I do have those tags in my remote sitemapcategories.xml.
So check all you know what to check: corrupt files, etc.

[JuxiZoza]

It has been a long time and is nice of you to remember.
I search for an occasional answer and lurk for awhile.
But, I just don't have available the 6-8 hrs a day I use to spend on the forum.

After much checking and testing, I found the problem.

I update all tables using SQL statements. I don't enter fields where the default is acceptable; have even changed a few field defaults to reduce the data I have to maintain. Normally, I don't bother entering data for "date_added" or "last_modified" and accept the NULL default value. Except for products; because I use that information on some pages.

I use IIS for local server and naturally the remote server is Apache.

When I installed sitemapXML on local server to test, I saw that "Last modification date" was 2001-01-01 for sitemapcategories.xml.

I changed my SQL statement and added today, in yyyyy-mm-dd format, to the last_modified field; date_added field was still empty (NULL).
Local category report looked fine.

However, same PHP files and data produces different reports on an Apache server.

• If both date_added and last_modified are NULL, sitemapcategories.xml contains no tags or data for "Last modification date".
• If data is entered into last_modified field only, as I did, the sitemapcategories.xml still contains no tags or data for "Last modification date".
• Data MUST be present in the date_added field for "Last modification date" information to appear in the XML report.
• If both fields contain date, the later date is used.

These results where found using phpMyAdmin on local and remote server and deleting and adding different date combinations in the category tables.

The way the program is now written,
IIS will supply a date of 2001-01-01 if null and you only need data in the last_modified field.
Apache says NULL means NULL and requires data in the date_added field to work at all.

Remember, I use SQL statements and can create my own problems (and solutions) and ZenCart users who use Admin will never be affected. I may alter my SQL statement to include date_added data ~or~ default date_added to some datetime other than NULL.

As far as the program code;
In sitemapxml_categories.php line 27, I thought it might have failed because "0001-01-01" is out of range for MySQL. Changed to "2003-01-01" and still no joy.

Don't think lines 22 and 27 are getting the job done.
Might be tempted to stick a default "NOW" in there some place.

That's all I came up with.
Now that I understand that date_added field is needed for current code to work on Apache server, I'll take needed action.

Best wishes,
Juxi

[ourcollegetown]

I installed this submission and got it up and running; but it appears that it is incompatible with the Simple SEO mod. Instead of the nice SEO urls that I, and google, use:

http://ourcollegetown.net/art/s-putn...football-print

I get links like:

http://ourcollegetown.net/index.php?...dex&cPath=7_16


Google will not accept a sitemap link that is a redirect. Is there a way to make these two mods play nicely?

[countrycharm]

I installed this submission and got it up and running; but it appears that it is incompatible with the Simple SEO mod. Instead of the nice SEO urls that I, and google, use:

http://ourcollegetown.net/art/s-putn...football-print

I get links like:

http://ourcollegetown.net/index.php?...dex&cPath=7_16


Google will not accept a sitemap link that is a redirect. Is there a way to make these two mods play nicely?

I had the same problem as you. I ask yellow over in the simple seo thread to look at it for me. I don't know what he did but he fix it. I think he is in Japan right now so he has little time to help here on the form right now. You can shoot him a email at his site, maybe he will help you. Email him here
Hope things workout for you.

[ourcollegetown]

I had the same problem as you. I ask yellow over in the simple seo thread to look at it for me. I don't know what he did but he fix it. I think he is in Japan right now so he has little time to help here on the form right now. You can shoot him a email at his site, maybe he will help you. Email him here
Hope things workout for you.

I sent him a message. Do you still have any of your correspondence with him? If so, could you send it to me? I'm sure the same solution applies to both.

[gaffettape]

Ok I used to have SEO URLS but have since turned it off. I then looked at the sitemap and realised it was showing the old seo urls. So I went to admin and clicked the 'STEP 1: Click [HERE] to create / update your site map. ' But nothing has changed in the sitemap, its still showing the old seo urls? any ideas?

Thanks.

[elibaba]

Same question as above, and one more :

1) I am using sitemapxml on a bilingual cart, with Generate language_id for default language = false, and with SEO URLs submittion.
As with the zenners above, my sitemaps are generated with the original url's, not the SEO url's, and google does not like sitemaps that contain 301 redirects.

2) I have ezpages that are only accessible from one ezpage (thoes are articles linked from the main article page)
the main artice page is http://mineralz.biz/page.html?chapter=0&id=1
which links to ezpages like http://mineralz.biz/page.html?chapter=0&id=9

all ezpages BUT those that are linked direclty from the sidebox do not appear in the ezpages sitmap, any idea why ?

[countrycharm]

I sent him a message. Do you still have any of your correspondence with him? If so, could you send it to me? I'm sure the same solution applies to both.

I gave him my ftp details to my sever so no I really don't have any correspondence with him except he said it was fixed and sure enough it was. I don't know if he fixed something in the sitemap or in the simple seo add on to get it to work like it should, Sorry

[new2u]

So nothing on the ?&language=en still being included even though it is off? this is causing a lot of duplicates which is not good. Is anyone there?

[new2u]

Got it! It appears you have to manually delete the sitemap.xml and then recreate it for the toggle language to work. no need to uninstall reinstall