mysql_query returns 1 but mysql_errno is 0

[Calin Dorohoi]

Hi,

I'll be as brief as possible. MySQL 5.6, C interface. An example of offending query (happens randomly with different ones):

INSERT INTO main_hash_db.main_tbl (sha256, sha1, md5, created, modified, size, ext, path, orig_path) VALUES
(
'0688C46B3662AA2D00218DEF7E60863F7B8B006889E4FB4FF8780600DB5AE60D',
'63BF82052999F829326C8379BA54262838FADF6B',
'3E6229A8CA387A49B759466B3CE7A980',
FROM_UNIXTIME(1363339457),
FROM_UNIXTIME(1254123985),
192673,
'png',
'd:\\test\\out\\0\\06\\88\\C4\\6B\\36\\0688C46B3662AA2D00218DEF7E60863F7B8B006889E4FB4FF8780600DB5AE60D.png',
'c:\\windows\\ActWin8Serv2012\\OEM_VERSION\\FOUNDER\\windows\\Web\\Wallpaper\\Windows\\img0.png'
)



mysq_error() returns 0, mysql_sqlstate(0) returns '00000'. Engine is MyISAM. Other similar queries return success. There is nothing in the .err file. How do I go about this?