Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Error in Validating links (admin panel)

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

      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      anyone?
      Jason Bishop

      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
      Want to give me something back for my help? Please see my Amazon Wish List
      GLinks ULTRA Package | GLinks ULTRA Package PRO
      Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
      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

      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
      Want to give me something back for my help? Please see my Amazon Wish List
      GLinks ULTRA Package | GLinks ULTRA Package PRO
      Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
      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
      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?
      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
      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

      Quote Reply
      Re: [netnow] Error in Validating links (admin panel) In reply to
      Try it now.

      Adrian
      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

      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