Purgewhenfull

Forum for questions and support relating to 1.35.x development only.
Post Reply
ynn
Posts: 152
Joined: Fri Mar 17, 2006 2:30 am

Purgewhenfull

Post by ynn » Fri Nov 20, 2020 9:56 am

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: 220
Joined: Wed Sep 18, 2013 6:56 am

Re: Purgewhenfull

Post by Magic919 » Fri Nov 20, 2020 4:39 pm

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 » Sat Nov 21, 2020 4:11 am

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: 220
Joined: Wed Sep 18, 2013 6:56 am

Re: Purgewhenfull

Post by Magic919 » Sat Nov 21, 2020 7:27 am

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.

burger
Posts: 187
Joined: Mon May 11, 2020 4:32 pm

Re: Purgewhenfull

Post by burger » Sat Nov 21, 2020 7:10 pm

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://<ipaddress>:554/path output.mp4
from terminal, and run through paths on ispydb or in zm hcl

If you are new to cctv, read this:
https://wiki.zoneminder.com/Dummies_Guide

Magic919
Posts: 220
Joined: Wed Sep 18, 2013 6:56 am

Re: Purgewhenfull

Post by Magic919 » Sun Nov 22, 2020 7:14 am

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 » Mon Nov 23, 2020 1:28 am

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests