delete of bogus events

jameswilson · Post by **jameswilson** » Mon Jun 05, 2006 6:57 pm

Hi, i have an issue that occurs after a db error,
As zma cant create the events properly due to corruption, it cant save any images, and thus tries to create a new entry. On fixing the db all returns to normal but i have a lot of db entried of 0 durration and name of new event

961 Events - 1 - 2 3 6 13 27 39 > View All Close

Refresh ShowFilterWindow Show Timeline

Id(^) Name Monitor Cause Time Duration Frames Alarm
Frames Total
Score Avg.
Score Max.
Score Thumbnail
40177 New Event Cam_2 Continuous 06/03 21:49:38 0.00 0 0 0
40178 New Event Cam_1 Continuous 06/03 21:49:39 0.00 0 0 0
40179 New Event Cam_7 Continuous 06/03 21:49:41 0.00 0 0 0
40180 New Event Cam_8 Continuous 06/03 21:49:41 0.00 0 0 0
40181 New Event Cam_3 Continuous 06/03 21:49:43 0.00 0 0 0
40182 New Event Cam_2 Continuous 06/03 21:49:45 0.00 0 0 0
40183 New Event Cam_1 Continuous 06/03 21:49:45 0.00 0 0 0
40184 New Event Cam_4 Continuous 06/03 21:49:48 0.00 0 0 0
40185 New Event Cam_7 Continuous 06/03 21:49:57 0.00 0 0 0
40186 New Event Cam_8 Continuous 06/03 21:49:57 0.00 0 0 0
40187 New Event Cam_3 Continuous 06/03 21:49:59 0.00 0 0 0
40188 New Event Cam_2 Continuous 06/03 21:50:01 0.00 0 0 0
40189 New Event Cam_1 Continuous 06/03 21:50:01 0.00 0 0 0
40190 New Event Cam_4 Continuous 06/03 21:50:04 0.00 0 0 0
40191 New Event Cam_7 Continuous 06/03 21:50:06 0.00 0 0 0
40192 New Event Cam_8 Continuous 06/03 21:50:07 0.00 0 0 0
40193 New Event Cam_3 Continuous 06/03 21:50:12 0.00 0 0 0
40194 New Event Cam_2 Continuous 06/03 21:50:17 0.00 0 0 0
40195 New Event Cam_1 Continuous 06/03 21:50:17 0.00 0 0 0
40196 New Event Cam_4 Continuous 06/03 21:50:21 0.00 0 0 0
40197 New Event Cam_7 Continuous 06/03 21:50:22 0.00 0 0 0
40198 New Event Cam_8 Continuous 06/03 21:50:22 0.00 0 0 0
40199 New Event Cam_3 Continuous 06/03 21:50:35 0.00 0 0 0
40200 New Event Cam_4 Continuous 06/03 21:50:42 0.00 0 0 0
40201 New Event Cam_2 Continuous 06/03 21:50:42 0.00 0 0 0

Id hoped that zmaudit would clearthese away as there would be no images to connect with, but it doesnt so i set a filter to audo delete anything with a 0 duration. Unfortunaltly this doesnt work either. I assume this is because zmadut and the filters think that they are new events as they have never ended, and i have to manually delete them. Is there any way to automatically delete all these errors?