| Invalid SQL: INSERT INTO Error -
05-02-2006, 03:24 PM
I had to re-attach the database after MySQL was removed when uninstalling a piece of software but now I get the following error message at the top of the home page.
Invalid SQL: INSERT INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('637a8ec43326eda5fab863098d79c71f', '62.3.230.37', '1139153169', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET', '', '40', '0', '1139153169', '0'); (Incorrect integer value: '' for column 'isloggedin' at row 1)
I installed MySQL v5 though I was on v4.0x previously and although everything else seems to be fine with the backend I am not sure why this message is appearing.
Any ideas? |