Page 1 of 1


Posted: Fri Nov 20, 2020 9:56 am
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.

Re: Purgewhenfull

Posted: Fri Nov 20, 2020 4:39 pm
by Magic919
Might be just that version. You’ll see similar errors if you look down this part of the forum.

Re: Purgewhenfull

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

Re: Purgewhenfull

Posted: Sat Nov 21, 2020 7:27 am
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.

Re: Purgewhenfull

Posted: Sat Nov 21, 2020 7:10 pm
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.

Purgewhenfull proper setup: ... 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 ( 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.

Re: Purgewhenfull

Posted: Sun Nov 22, 2020 7:14 am
by Magic919
Perhaps a warning should be coded into the web interface somewhere prominent.

Re: Purgewhenfull

Posted: Mon Nov 23, 2020 1:28 am
by ynn
Thank you so much for all the comments and instructions, I really appreciate it, I have follow all the instruction from this ... 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.