Forum for questions and support relating to the 1.25.x releases only.
- Posts: 163
- Joined: Fri Oct 22, 2010 11:21 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
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]
Who is online
Users browsing this forum: No registered users and 4 guests