Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Error in Validating links (admin panel)

May 17, 2006, 10:53 PM
netnow
User (56 posts)
netnow's avatar
May 17, 2006, 10:53 PM
Post #1 of 12
Views: 951
Shortcut
Quote Reply
Error in Validating links (admin panel)
I am getting an error when trying to validate links:
    Unable to validate link, 3: Failed to execute query: 'UPDATE glinks_Links SET Contact_Name = ? , isPopular = ? , Status = ? , Contact_Email = ? , ExpiryDate = ? , Mod_Date = ? , ExpiryNotify = ? , Title = ? , Votes = ? , Add_Date = ? , isChanged = ? , Date_Checked = ? , Hits = ? , URL = ? , ExpiryCounted = ? , LongDescription = ? , displaynumber = ? , Rating = ? , isNew = ? , LinkOwner = ? , isValidated = ? , Description = ? , Timestmp = NOW() WHERE ID = ?': Incorrect datetime value: '' for column 'Date_Checked' at row 1
    ANyone knows why this might be happening?
    I am using windows server 2003 with activeperl and mysql

      Jason Bishop

      May 18, 2006, 1:06 PM
      netnow
      User (56 posts)
      netnow's avatar
      May 18, 2006, 1:06 PM
      Post #2 of 12
      Views: 934
      Shortcut
      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      anyone?
      Jason Bishop

      May 19, 2006, 11:34 AM
      Andy
      Veteran / Moderator (17298 posts)
      Andy's avatar
      May 19, 2006, 11:34 AM
      Post #3 of 12
      Views: 928
      Shortcut
      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      Hi,

      Have you changed anything in your Database > Links > Properties area? Try doing a Database > Links > Properties > Resync, and see if that helps.

      Cheers

      Andy (mod)
      andy@ultranerds.co.uk

      IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
      Want to give me something back for my help? Please see my Amazon Wish List
      GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
      Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
      Compare our different Plugin packages *new* Free CSS Templates
      May 19, 2006, 12:30 PM
      netnow
      User (56 posts)
      netnow's avatar
      May 19, 2006, 12:30 PM
      Post #4 of 12
      Views: 926
      Shortcut
      Quote Reply
      Re: [Andy] Error in Validating links (admin panel) In reply to
      Andy,

      Thanks for your response, however that did not work. This is a new installtion on windows dedicated server 2003 with Active Perl 5.8

      ANyone have this trouble? What else could it be?
      Jason Bishop

      May 19, 2006, 12:49 PM
      Andy
      Veteran / Moderator (17298 posts)
      Andy's avatar
      May 19, 2006, 12:49 PM
      Post #5 of 12
      Views: 925
      Shortcut
      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      Hi,

      Mmm.. afraid I've never really seen that error before :/ (was worth a try what I suggested, as that sometimes sorts problems out <G>).

      Sorry I can't be more help.

      Cheers

      Andy (mod)
      andy@ultranerds.co.uk

      IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
      Want to give me something back for my help? Please see my Amazon Wish List
      GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
      Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
      Compare our different Plugin packages *new* Free CSS Templates
      May 19, 2006, 6:50 PM
      brewt
      Staff (4066 posts)
      brewt's avatar
      May 19, 2006, 6:50 PM
      Post #6 of 12
      Views: 921
      Shortcut
      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      If you send me admin panel access, I can take a look at it for you.

      Adrian
      Jun 25, 2007, 7:24 AM
      netnow777
      Novice (12 posts)
      Jun 25, 2007, 7:24 AM
      Post #7 of 12
      Views: 847
      Shortcut
      Quote Reply
      Re: [brewt] Error in Validating links (admin panel) In reply to
      I am getting this error again, WHat do i need to do?
      Jun 27, 2007, 6:16 PM
      brewt
      Staff (4066 posts)
      brewt's avatar
      Jun 27, 2007, 6:16 PM
      Post #8 of 12
      Views: 834
      Shortcut
      Quote Reply
      Re: [netnow777] Error in Validating links (admin panel) In reply to
      I've fixed it on your install. The problem is with MySQL on Windows, where it doesn't set a default for the DATETIME column, whereas it does in *nix. I've put in a fix in the code so that it shouldn't happen in the future.

      Adrian
      Jun 27, 2007, 7:12 PM
      netnow
      User (56 posts)
      netnow's avatar
      Jun 27, 2007, 7:12 PM
      Post #9 of 12
      Views: 831
      Shortcut
      Quote Reply
      Re: [brewt] Error in Validating links (admin panel) In reply to
      Hi,

      I am also getting an error "Incorrect date" value for Newest Link, I tried adding the "default vaule" fix but it did not work for Category / Properties/ Newest Link
      Jason Bishop

      Jun 27, 2007, 7:37 PM
      brewt
      Staff (4066 posts)
      brewt's avatar
      Jun 27, 2007, 7:37 PM
      Post #10 of 12
      Views: 827
      Shortcut
      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      Try it now.

      Adrian
      Jun 27, 2007, 10:09 PM
      netnow
      User (56 posts)
      netnow's avatar
      Jun 27, 2007, 10:09 PM
      Post #11 of 12
      Views: 822
      Shortcut
      Quote Reply
      Re: [brewt] Error in Validating links (admin panel) In reply to
      Thank you very much

      I do have one question when i tried to change the default it did not work and when you did it, it worked, What was i doing wrong
      Jason Bishop

      Jun 27, 2007, 10:19 PM
      brewt
      Staff (4066 posts)
      brewt's avatar
      Jun 27, 2007, 10:19 PM
      Post #12 of 12
      Views: 821
      Shortcut
      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      Changing the default affects new categories that are created, but not the existing ones. I had to change the existing categories.

      Adrian