zmfilter ERR Can't execute filter 'SELECT E.Id,#012

Forum for questions and support relating to the 1.30.x releases only.
Locked
XabiX
Posts: 13
Joined: Thu Feb 02, 2017 4:31 pm

zmfilter ERR Can't execute filter 'SELECT E.Id,#012

Post by XabiX »

Hello,

i do get this error message when my filter is executed:

Code: Select all

Feb  5 14:29:06 SERVER zmfilter[6229]: ERR [Can't execute filter 'SELECT E.Id,#012                          E.MonitorId,#012                          M.Name as MonitorName,#012                          M.DefaultRate,#012                          M.DefaultScale,#012                          E.Name,#012                          E.Cause,#012                          E.Notes,#012                          E.StartTime,#012                          unix_timestamp(E.StartTime) as Time,#012                          E.Length,#012                          E.Frames,#012                          E.AlarmFrames,#012                          E.TotScore,#012                          E.AvgScore,#012                          E.MaxScore,#012                          E.Archived,#012                          E.Videoed,#012                          E.Uploaded,#012                          E.Emailed,#012                          E.Messaged,#012                          E.Executed#012                   FROM Events as E#012                   INNER JOIN Monitors as M on M.Id = E.MonitorId#012         where not isnull(E.EndTime) and ( E.Length = 00:00:00 ) order by E.Id asc', ignoring: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':00:00 ) order by E.Id asc' at line 25]
I tried changing the length from '00:00:00' to 00:00:00 and with \: but always the same. Basically I just want to delete events with a null duration. Not sure why they get recorded though but at least I wanted to clean those.

Any idea of the right config to get this working? and potentially of what is causing null duration events?

Merci
Xavier
Attachments
filter.png
filter.png (50.57 KiB) Viewed 8180 times
XabiX
Posts: 13
Joined: Thu Feb 02, 2017 4:31 pm

Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012

Post by XabiX »

Here is an example of what I am seeing.I assume I can tweak ZM to have one event per hour? What are these events based on? If the duration is 00 does it mean like that during x number of minutes not detection was done (Cameras with VBR) so nothing has been recorded since the previous file? That seems strange to me.
zm.png
zm.png (297.48 KiB) Viewed 8176 times
User avatar
knight-of-ni
Posts: 2404
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012

Post by knight-of-ni »

Duration should be simply "0" w/o quotes.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
User avatar
knight-of-ni
Posts: 2404
Joined: Thu Oct 18, 2007 1:55 pm
Location: Shiloh, IL

Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012

Post by knight-of-ni »

Oh, and a common reason for null events are an inability to write to the disk. Is the disk full? Are the right permissions set? Is the disk slow/failing? You need to look in your log for clues.
Visit my blog for ZoneMinder related projects using the Raspberry Pi, Orange Pi, Odroid, and the ESP8266
All of these can be found at https://zoneminder.blogspot.com/
XabiX
Posts: 13
Joined: Thu Feb 02, 2017 4:31 pm

Re: zmfilter ERR Can't execute filter 'SELECT E.Id,#012

Post by XabiX »

Hi Knnniggett

1/ Thanks this was the issue, now I see:
Feb 5 21:08:16 SERVER zmfilter[12641]: INF [Scanning for events using filter '_TempFilter1486325295']

2/ As the previous, screenshot the disks correctly accessible (it was a 69% and now is at 96%). I do have the other filter "PurgeWhenFull" kicking at 95% with the oldest 100 events to be deleted so normally the disk is never full.

3/ As per the log, I did put as documented in the wiki (http://zoneminder.readthedocs.io/en/sta ... ogging.png) but the file in /var/log/zm is empty and I don't have logs in the web page (even it is orange). I do believe I may have an issue there but I was thinking this was stored in the db rather than the file. At least I do get the logs in syslog correctly and don't see anything strange. Should I be looking at another place?

Code: Select all

Feb  5 21:11:51 SERVER zmaudit[12940]: INF [Filesystem event '5/86' does not exist in database]
Feb  5 21:11:51 SERVER zmaudit[12940]: INF [deleting]
Feb  5 21:11:51 SERVER zmaudit[12940]: INF [Filesystem event '5/90' does not exist in database]
Feb  5 21:11:51 SERVER zmaudit[12940]: INF [deleting]
Feb  5 21:11:51 SERVER zmaudit[12940]: INF [Filesystem event '5/4323' does not exist in database]
Feb  5 21:11:51 SERVER zmaudit[12940]: INF [deleting]
Feb  5 21:11:52 SERVER zmaudit[12940]: INF [Filesystem event '7/89' does not exist in database]
Feb  5 21:11:52 SERVER zmaudit[12940]: INF [deleting]
Feb  5 21:11:52 SERVER zmaudit[12940]: INF [Filesystem event '7/4322' does not exist in database]
Feb  5 21:11:52 SERVER zmaudit[12940]: INF [deleting]
Feb  5 21:11:53 SERVER zmaudit[12940]: INF [Filesystem event '7/85' does not exist in database]
Feb  5 21:11:53 SERVER zmaudit[12940]: INF [deleting]
Feb  5 21:11:53 SERVER zmaudit[12940]: INF [Filesystem event '7/4319' does not exist in database]
Feb  5 21:11:53 SERVER zmaudit[12940]: INF [deleting]
Feb  5 21:12:01 SERVER zma_m5[10922]: INF [Devant HD: 45000 - Analysing at 24.39 fps]
Feb  5 21:12:01 SERVER zma_m6[10926]: INF [Cote HD: 45000 - Analysing at 24.39 fps]
Feb  5 21:12:02 SERVER zma_m7[10931]: INF [Derriere HD: 45000 - Analysing at 25.00 fps]
Feb  5 21:12:22 SERVER zmc_m7[12926]: INF [Derriere HD: 503000 - Capturing at 25.00 fps]
Feb  5 21:12:23 SERVER zmc_m5[12898]: INF [Devant HD: 503000 - Capturing at 25.00 fps]
Feb  5 21:12:24 SERVER zmc_m6[12911]: INF [Cote HD: 503000 - Capturing at 25.00 fps]
Feb  5 21:12:35 SERVER zmc_m3[12891]: INF [Derriere: 302000 - Capturing at 15.15 fps]
Feb  5 21:12:37 SERVER zmc_m1[12879]: INF [Devant: 302000 - Capturing at 14.93 fps]
Feb  5 21:12:37 SERVER zmc_m2[12885]: INF [Cote: 302000 - Capturing at 15.15 fps]
Feb  5 21:12:41 SERVER zma_m5[10922]: INF [Devant HD: 46000 - Analysing at 25.00 fps]
Feb  5 21:12:41 SERVER zma_m6[10926]: INF [Cote HD: 46000 - Analysing at 25.00 fps]
Feb  5 21:12:43 SERVER zma_m7[10931]: INF [Derriere HD: 46000 - Analysing at 24.39 fps]
Feb  5 21:13:03 SERVER zmc_m7[12926]: INF [Derriere HD: 504000 - Capturing at 25.00 fps]
Feb  5 21:13:03 SERVER zmc_m5[12898]: INF [Devant HD: 504000 - Capturing at 25.00 fps]
Feb  5 21:13:04 SERVER zmc_m6[12911]: INF [Cote HD: 504000 - Capturing at 25.00 fps]
Feb  5 21:13:21 SERVER zma_m5[10922]: INF [Devant HD: 47000 - Analysing at 25.00 fps]
Feb  5 21:13:21 SERVER zma_m6[10926]: INF [Cote HD: 47000 - Analysing at 25.00 fps]
Feb  5 21:13:23 SERVER zma_m7[10931]: INF [Derriere HD: 47000 - Analysing at 25.00 fps]
Feb  5 21:13:42 SERVER zmc_m3[12891]: INF [Derriere: 303000 - Capturing at 14.93 fps]
Feb  5 21:13:42 SERVER zmc_m7[12926]: INF [Derriere HD: 505000 - Capturing at 25.00 fps]
Feb  5 21:13:43 SERVER zmc_m5[12898]: INF [Devant HD: 505000 - Capturing at 25.00 fps]
Feb  5 21:13:44 SERVER zmc_m1[12879]: INF [Devant: 303000 - Capturing at 14.93 fps]
Feb  5 21:13:44 SERVER zmc_m2[12885]: INF [Cote: 303000 - Capturing at 14.93 fps]
Feb  5 21:13:44 SERVER zmc_m6[12911]: INF [Cote HD: 505000 - Capturing at 25.00 fps]
Feb  5 21:14:01 SERVER zma_m5[10922]: INF [Devant HD: 48000 - Analysing at 25.00 fps]
Feb  5 21:14:01 SERVER zma_m6[10926]: INF [Cote HD: 48000 - Analysing at 25.00 fps]
Feb  5 21:14:03 SERVER zma_m7[10931]: INF [Derriere HD: 48000 - Analysing at 25.00 fps]
Feb  5 21:14:22 SERVER zmc_m7[12926]: INF [Derriere HD: 506000 - Capturing at 25.00 fps]
Feb  5 21:14:23 SERVER zmc_m5[12898]: INF [Devant HD: 506000 - Capturing at 25.00 fps]
Feb  5 21:14:24 SERVER zmc_m6[12911]: INF [Cote HD: 506000 - Capturing at 25.00 fps]
Feb  5 21:14:41 SERVER zma_m6[10926]: INF [Cote HD: 49000 - Analysing at 25.00 fps]
Feb  5 21:14:41 SERVER zma_m5[10922]: INF [Devant HD: 49000 - Analysing at 25.00 fps]
Feb  5 21:14:43 SERVER zma_m7[10931]: INF [Derriere HD: 49000 - Analysing at 25.00 fps]
Feb  5 21:14:49 SERVER zmc_m3[12891]: INF [Derriere: 304000 - Capturing at 14.93 fps]
Feb  5 21:14:50 SERVER zmc_m1[12879]: INF [Devant: 304000 - Capturing at 15.15 fps]
Feb  5 21:14:51 SERVER zmc_m2[12885]: INF [Cote: 304000 - Capturing at 14.93 fps]
Feb  5 21:15:02 SERVER zmc_m7[12926]: INF [Derriere HD: 507000 - Capturing at 25.00 fps]
Feb  5 21:15:03 SERVER zmc_m5[12898]: INF [Devant HD: 507000 - Capturing at 25.00 fps]
Feb  5 21:15:04 SERVER zmc_m6[12911]: INF [Cote HD: 507000 - Capturing at 25.00 fps]
Feb  5 21:15:21 SERVER zma_m6[10926]: INF [Cote HD: 50000 - Analysing at 25.00 fps]
Feb  5 21:15:21 SERVER zma_m5[10922]: INF [Devant HD: 50000 - Analysing at 25.00 fps]
Feb  5 21:15:24 SERVER zma_m7[10931]: INF [Derriere HD: 50000 - Analysing at 25.00 fps]
MERCI
XabiX

PS: I have opened this other thread (maybe on the wrong section) and I don't have much luck with insights. Anyway idea at least on Question 1?
viewtopic.php?f=14&t=25790
Locked