Wrong timestamps in MySQL database

[ekiboy69]

Hello,

We have a strange problem with ZM database. We have a lot of pictures taken that have correct timestamp in the image. The faulty date in the database is however always the same: 1969-12-31 16:00:00.

This seems to be related to Unix epoch. Is it possible that these faulty timestamps are generated due to an error?

This issue really bugs me because there is valuable data in these pictures and I am not able to sort them at all because the IDs seem to be reused when old events are deleted from the database.

[ekiboy69]

Hi again,

There's also another rather peculiar thing: ZM shows negative durations for some events. For example -1.20 second.

[forhire]

I'm seeing this issue also. I had supposed it was caused by my very slow Axis 200+ camera but I'm not sure. 565 of 573 events have the wrong date.