[sqlite] Why does this sql error

[Tom Shaw]

I use the following sql

INSERT INTO malware (file, location, md5, size, sig, sig_name, cnt, 
clam_result, date_found, date_removed, ref) VALUES 
('Setup.exe-IRAD0n', '/Users/tshaw/malware/Setup.exe-IRAD0n', 
'1186b3a97de73f924dcfb12cba0bb1bf', 15360, '', '', 1, 
'/Users/tshaw/virus_archive/Setup.exe-IRAD0n: Worm.Koobface-20 FOUND 
', 1243947206, 1243947206, NULL);

and get the following error

Error!: SQLSTATE[HY000]: General error: 1 near ",": syntax error code:HY000

This occur whenever I try to do a second insert with a unique 
variable which is fine but why the error message above and not a 
message about duplicate uniques?

TIA,

Tom

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users