HDD Full and PurgeWhenFull not working.

[rmflagg]

So my hard drive is now full even though I had PurgeWhenFull running, with the percent trigger set at 90%.

I have adjusted the filter so that it triggers when the percent full goes above 80%, but I can execute the filter(greyed out) and if I Submit it to test, I get this error: "SQL-ERR dbFetchAll no result, statement was 'SELECT E.Id,E.MonitorId,M.Name AS MonitorName,M.DefaultScale,E.Name,E.Width,E.Height,E.Cause,E.Notes,E.StartTime,E.Length,E.Frames,E.AlarmFrames,E.TotScore,E.AvgScore,E.MaxScore,E.Archived FROM Monitors AS M INNER JOIN Events AS E on (M.Id = E.MonitorId) WHERE 1 and ( E.Archived = '0' and 100 >= '80' ) ORDER BY E.Id asc limit 0, 250'"

Does anyone know what this means(other than the obvious that there is a problem!

[rmflagg]

*BUMP* and another question.

Can anyone help me with deleting entries manually?!? With the HDD full, my system is useless. I wish I knew why the PurgeWhenFull filter didn't work, but that's not as important as getting my system back up and running.

Thanks,
RMFlagg

[bbunge]

The easy way is to reinstall the OS and start over.
It looks like you may have a memory issue with MySQL. You can stop zoneminder and delete the images manually with rm but, depending on the size of your hard drive it could take a while. It took me the better part of a day to delete 1.5 TB of images. So, doing a fresh install of Linux may be your best bet. Oh, you did not say which Linux distro you were using and which version of Zoneminder you installed...

bb