Page 1 of 1
Posted: 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.
Posted: 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.
Posted: 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?
Posted: 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.
Posted: 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.
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.
Posted: Sun Nov 22, 2020 7:14 am
Perhaps a warning should be coded into the web interface somewhere prominent.
Posted: 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.