Results 1 to 13 of 13

Thread: Sitemap error in 5.4

  1. #1
    Join Date
    May 2007
    Location
    NJ, United States
    Posts
    1,651

    Default Sitemap error in 5.4

    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.
    FSGDAG | IndexU Hosting | Owner
    Website | NiceCoder Script Hosting and More! | Web4URL is For Sale!
    Follow Us On Twitter | FaceBook Profile | YouTube Videos

  2. #2
    Join Date
    Jun 2002
    Location
    Winnipeg Canada
    Posts
    4,913

    Default

    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.

  3. #3
    Join Date
    Apr 2006
    Posts
    447

    Default

    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?

  4. #4
    Join Date
    May 2007
    Location
    NJ, United States
    Posts
    1,651

    Default

    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
    FSGDAG | IndexU Hosting | Owner
    Website | NiceCoder Script Hosting and More! | Web4URL is For Sale!
    Follow Us On Twitter | FaceBook Profile | YouTube Videos

  5. #5
    Join Date
    Apr 2006
    Posts
    447

    Default

    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.
    Last edited by CEC; 12-24-2008 at 12:16 AM.

  6. #6
    Join Date
    May 2007
    Location
    NJ, United States
    Posts
    1,651

    Default

    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
    FSGDAG | IndexU Hosting | Owner
    Website | NiceCoder Script Hosting and More! | Web4URL is For Sale!
    Follow Us On Twitter | FaceBook Profile | YouTube Videos

  7. #7
    Join Date
    May 2007
    Location
    Pontianak City
    Posts
    27

    Default

    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.
    The Greatest Of Our Strength and Weakness, is Our HOPE

  8. #8
    Join Date
    May 2007
    Location
    NJ, United States
    Posts
    1,651

    Default

    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!
    FSGDAG | IndexU Hosting | Owner
    Website | NiceCoder Script Hosting and More! | Web4URL is For Sale!
    Follow Us On Twitter | FaceBook Profile | YouTube Videos

  9. #9
    Join Date
    May 2007
    Location
    Pontianak City
    Posts
    27

    Default

    add my yahoo mes at cavanuexmaulana@yahoo.com. i can help you step by step.
    The Greatest Of Our Strength and Weakness, is Our HOPE

  10. #10
    Join Date
    May 2007
    Location
    NJ, United States
    Posts
    1,651

    Default

    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
    FSGDAG | IndexU Hosting | Owner
    Website | NiceCoder Script Hosting and More! | Web4URL is For Sale!
    Follow Us On Twitter | FaceBook Profile | YouTube Videos

  11. #11
    Join Date
    May 2007
    Location
    Pontianak City
    Posts
    27

    Default

    hahaha. ok. merry Christmas to you all.
    The Greatest Of Our Strength and Weakness, is Our HOPE

  12. #12
    Join Date
    Jun 2002
    Location
    Winnipeg Canada
    Posts
    4,913

    Default

    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

  13. #13
    Join Date
    May 2007
    Location
    NJ, United States
    Posts
    1,651

    Default

    Worked perfectly!!! Thanks Bruce!!! GREAT to have you back!!!!!
    FSGDAG | IndexU Hosting | Owner
    Website | NiceCoder Script Hosting and More! | Web4URL is For Sale!
    Follow Us On Twitter | FaceBook Profile | YouTube Videos

Similar Threads

  1. Sitemap error
    By Mitchell in forum INDEXU DELUXE v1.x
    Replies: 13
    Last Post: 09-17-2008, 03:08 AM
  2. Sitemap Error Help
    By hermit36 in forum INDEXU DELUXE v1.x
    Replies: 4
    Last Post: 05-21-2008, 05:28 PM
  3. Sitemap error
    By franconov in forum v5.x
    Replies: 12
    Last Post: 04-02-2008, 04:27 AM
  4. AGAIN :: Sitemap Error
    By webwerx in forum v5.x
    Replies: 6
    Last Post: 06-22-2006, 12:39 AM
  5. Google Sitemap error
    By lexpression in forum v5.x
    Replies: 9
    Last Post: 04-14-2006, 07:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •