Page 1 of 1

Wrong timestamps in MySQL database

Posted: Sat Jul 10, 2004 5:51 pm
by 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.

There are also negative durations

Posted: Sat Jul 10, 2004 7:35 pm
by ekiboy69
Hi again,

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

Posted: Wed Jul 14, 2004 11:51 pm
by 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.