purge when full

Forum for questions and support relating to the 1.25.x releases only.
Post Reply
Posts: 163
Joined: Fri Oct 22, 2010 11:21 am

purge when full

Post by tibetfreedom » 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 )'
purge.tiff (73.31 KiB) Viewed 1004 times

Posts: 478
Joined: Mon Mar 25, 2013 12:34 pm

Re: purge when full

Post by mikb » 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]

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests