Sitemap error in 5.4

[FSGDAG]

I just went and checked Google Webmaster Tools and found some errors in my sitemap. Upon looking to see what the errors were, I'm seeing the following :

Sitemap errors and warnings
Line Status Details
Details 5507 Invalid date
An invalid date was found. Please fix the date or formatting before resubmitting. Help Help
Parent tag:
Tag:
Value:
Problem detected on: url
lastmod
1969-12-31
Nov 21, 2008

Any idea on what might be causing this??? I haven't changed anything and I'm just now starting to notice this.

[Bruceper]

If you imported a database the date would show 0000-00-00 00:00:00

You'll just need to do a search and replace on both Date and on Last Updated and then resubmit.

[CEC]

I'm receiving the same error, for the same date (1969-12-31), FSGDAG. Were you able to resolve as per Bruceper's note? I'm still not clear on what might be causing this?

[FSGDAG]

I wish I could say that I found the fix... Unfortunately, doing a "Find Replace" in the Admin Panel, under idx_link for date, updated, and last_updated finds 0 queries.

I'm not really sure what to do either. I dont think Bruce is back yet but once he is, I was going to look into it further

[CEC]

Actually, my site was just set up by IndexU on the custom side of things. I wasn't having the problem until the recent work, which involved upgrading the script from 5.4 to 1.21. I'm not saying that the two are associated, though. Not sure I'll hear anything from them over the next several days -- Holiday Season, and all.

Anyway, same date. Must be a default.

[FSGDAG]

Mine came about out of no where. Everything was running fine for a while and then Google started showing the errors in the sitemap file. I dont think it has anything to do with your custom work being done, but then again, who knows

Hopefully we'll get it resolved shortly

[irvan]

i got 9000 link with 1969-12-31, but all fixed using phpmyadmin.
use this SQL form
1. search row where have value 1969-12-31 or 00:00:00
SELECT * FROM `idx_link` WHERE `last_updated` = 0000-00-00 00:00:00

make sure they showing all row, where have value 0000-00-00 00:00:00
2. UPDATE `yourdatabase`.`idx_link` SET `last_updated` = '2008-12-25 02:10:23' WHERE `idx_link` = 0000-00-00 00:00:00

done.

Semoga membantu.

[FSGDAG]

Irvan...

Would you mind giving someone like me, an extremely simple minded person, some more detailed instructions on how to do this?

I went into phpMyAdmin, selected my database, then used both the search and query tabs at the top. I tried running the "SELECT" command you have in step 1, but I dont think I did it right?!?!?

Any additional help is greatly appreciated!

[irvan]

add my yahoo mes at cavanuexmaulana@yahoo.com. i can help you step by step.

[FSGDAG]

Thanks bro... I'll have to add you later tonight... Its Christmas and my wife will rip the cable modem out of the wall if she finds me spending any length of time on the computer this morning and afternoon

[irvan]

hahaha. ok. merry Christmas to you all.

[Bruceper]

Admin Panel - Database - Find Replace

Select Table idx_link
Select Field date
Find what 0000-00-00 00:00:00
Replace with 2008-01-01 01:01:01

Select Table idx_link
Select Field last_updated
Find what 0000-00-00 00:00:00
Replace with 2008-01-01 01:01:01

If that doesn't work then you need to look and see what the actual date/time says and use that instead of 0000-00-00 00:00:00

[FSGDAG]

Worked perfectly!!! Thanks Bruce!!! GREAT to have you back!!!!!