Purgewhenfull

Previous development branch now released as 1.36
Locked
ynn
Posts: 152
Joined: Fri Mar 17, 2006 2:30 am

Purgewhenfull

Post by ynn »

Hi there, anyone has problem with purgewhenfull in new ZM 1.35.10, i have selected the StorageArea with the specific HD, but it seems the DiskPercent gives me error of :

SQL-ERR '42000 1064 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 '>= '95' ) ORDER BY E.Id asc' at line 1', statement was 'SELECT E.*,M.Name AS MonitorName,M.DefaultScale FROM Monitors AS M INNER JOIN Events AS E on (M.Id = E.MonitorId) WHERE 1 AND ( E.Archived = '0' and E.StorageId = '2' and >= '95' ) ORDER BY E.Id asc'

anyonw knows what's the problem

thank you i really appreciate it.
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Purgewhenfull

Post by Magic919 »

Might be just that version. You’ll see similar errors if you look down this part of the forum.
-
ynn
Posts: 152
Joined: Fri Mar 17, 2006 2:30 am

Re: Purgewhenfull

Post by ynn »

thank you so much for you reply, unfortunately i could not find the reference, should i do some update or something to make the purgewhenfull work? any other options?
thankss
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Purgewhenfull

Post by Magic919 »

It’s a risk in the 1.35.x version that people have to manage. I’m on 1.35.12 currently and have updating on hold until I’m ready for another jump (along with the risks and work it may bring).

I would certainly look at updating. If you have a package manager you fully understand it might be possible to have some control over which version you get next. It’s worth scanning the threads in the 1.35 section to see what’s good and bad.
-
User avatar
burger
Posts: 390
Joined: Mon May 11, 2020 4:32 pm

Re: Purgewhenfull

Post by burger »

1.35 is unstable / development. Let's be clear on that, as misinformation is worse than no information.

Most people should use 1.34, the stable release.

Filters: https://wiki.zoneminder.com/Filters
Purgewhenfull proper setup: https://wiki.zoneminder.com/Using_a_ded ... Hard_Drive

I see a lot of posts with people that ask elementary questions about the unstable release. Maybe it would benefit ZM if this is made more clear perhaps on the download page (https://zoneminder.com/downloads/) and or on the home page, sometimes you'll see projects that have a big visible rounded rectangle that says something like "stable release 1.34.##.. Just a thought. I'll add a short note to the debian page on the wiki.
fastest way to test streams:
ffmpeg -i rtsp://<user>:<pass>@<ipaddress>:554/path ./output.mp4 (if terminal only)
ffplay rtsp://<user>:<pass>@<ipaddress>:554/path (gui)
find paths on ispydb or in zm hcl

If you are new to security software, read:
https://wiki.zoneminder.com/Dummies_Guide
Magic919
Posts: 1381
Joined: Wed Sep 18, 2013 6:56 am

Re: Purgewhenfull

Post by Magic919 »

Perhaps a warning should be coded into the web interface somewhere prominent.
-
ynn
Posts: 152
Joined: Fri Mar 17, 2006 2:30 am

Re: Purgewhenfull

Post by ynn »

Thank you so much for all the comments and instructions, I really appreciate it, I have follow all the instruction from this https://wiki.zoneminder.com/Using_a_ded ... Hard_Drive and still got the error.

I have been using ZM for many years, I just wait for the next stable release and redo my system later. Temporarily I will do manual delete for now.

Thank you so much guys.
Locked