Re: mysql_query returns 1 but mysql_errno is 0

[Rick James]

> Query returned 1 but errno is 0

Please provide all the statements (in PHP?) between the INSERT and the fetching of errno. Keep in mind that errno is cleared by certain operations -- I want to see if you issued one of the things that would have cleared it.

In your first example (2 similar inserts from thread 0), I see one timestamp that is different. If you want that updated, then consider INSERT...ON DUPLICATE KEY UPDATE...