Page 1 of 1

Can't delete filter

Posted: Wed Oct 11, 2017 6:20 pm
by sil3ntcor3
I'm trying to delete several filters I created. When I select the filter and click the delete button, nothing happens and the filter is still present.

Thanks for any help in advance.

Re: Can't delete filter

Posted: Fri Oct 13, 2017 6:26 pm
by rockedge
what are the zoneminder and operating system versions ?

Re: Can't delete filter

Posted: Fri Oct 13, 2017 9:22 pm
by sil3ntcor3
Zoneminder v1.31.1 and Ubuntu 16.04.3 LTS

Re: Can't delete filter

Posted: Sat Oct 14, 2017 1:59 pm
by rockedge
I had this happen with version 1.30.1 but I can not find the notes as to what it was and how to fix it. I will try to duplicate it as I am about to do a new install with the same version of ZM and Ubuntu. See if I can get ZM to fail in the same manner.

Re: Can't delete filter

Posted: Sat Oct 14, 2017 7:55 pm
by sil3ntcor3
Thanks.

Re: Can't delete filter

Posted: Sun Oct 15, 2017 6:58 pm
by rockedge
are you using mariadb or mysql for the database?

Re: Can't delete filter

Posted: Sun Oct 15, 2017 7:34 pm
by sil3ntcor3
MySQL

Re: Can't delete filter

Posted: Mon Oct 16, 2017 2:12 am
by rockedge
I have not been able to duplicate the error but I used mariadb.....I will change db to MySQL and try it again!

did you add this line to the my.conf?

Code: Select all

sql_mode = NO_ENGINE_SUBSTITUTION

Re: Can't delete filter

Posted: Mon Oct 16, 2017 2:19 am
by sil3ntcor3
That line is there but I don't recall adding it or if it was there by default.

Re: Can't delete filter

Posted: Mon Oct 16, 2017 7:57 pm
by rockedge
it should be there for the newer versions of mysql. can you drop the ZM database and create a new one and import the sql file?

Re: Can't delete filter

Posted: Thu Oct 26, 2017 6:10 pm
by sil3ntcor3
So I ended up building a new VM and using mariadb and everything is working great now.

Re: Can't delete filter

Posted: Fri Oct 27, 2017 3:58 am
by rockedge
:D