ZoneMinder Forums

Posted: **Thu May 01, 2014 11:16 am**

sorry this is really stupid but can someone post a default purge when full config ? i want to purge after 65%

i am getting this...

Code: Select all

SQL-ERR 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and E.Archived = 0 )' at line 1', statement was 'select count(E.Id) as EventCount from Monitors as M inner join Events as E on (M.Id = E.MonitorId) where 1 and ( 86 >= 65% and E.Archived = 0 )'

Posted: **Thu May 01, 2014 6:51 pm**

That error message looks horrid, you certainly shouldn't see that, no matter what you tried as config!

At a guess, looking at the SQL error, have you literally put "65%" in the box in your config? Try just "65" (no %), you might be confusing MySQL. Look at the comparison bit of the SQL statement at the end.

As a guide, mine says :-

Archived Status, equal to, Unarchived Only
and, Disk Percent, greater than or equal to, 95

Sort by, ID, Asc, Limit to first, 50, results only
Delete all matches [Tick]

ZoneMinder Forums

purge when full

purge when full

Re: purge when full