On one of our website I am all of a sudden getting error while approving the link. If the link is rejected, then it works just fine, however while approving the link it gives arros as below, does anyone know what is going on?
Unable to validate link: 14538. Reason: Failed to execute query: 'UPDATE lsql_Links SET isPopular = ? , Keywords = ? , Status = ? , ExpiryDate = ? , Editor_Note = ? , Mod_Date = ? , ExpiryNotify = ? ,.............. about 30 more link properties .......................... Votes = ? , WHERE ID = ?' Reason: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' ExpiryDate = 2147483647 , Editor_Note = , Mod_Date = 2005 , E
Also this is on version 2.2.0 (yes I have to do the upgrades). What could be causing this? as this was working just fine till yesterday.
Thanks for the help.
Vishal
-------------------------------------------------------
Unable to validate link: 14538. Reason: Failed to execute query: 'UPDATE lsql_Links SET isPopular = ? , Keywords = ? , Status = ? , ExpiryDate = ? , Editor_Note = ? , Mod_Date = ? , ExpiryNotify = ? ,.............. about 30 more link properties .......................... Votes = ? , WHERE ID = ?' Reason: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' ExpiryDate = 2147483647 , Editor_Note = , Mod_Date = 2005 , E
Also this is on version 2.2.0 (yes I have to do the upgrades). What could be causing this? as this was working just fine till yesterday.
Thanks for the help.
Vishal
-------------------------------------------------------