Can't delete filter

[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.

[rockedge]

what are the zoneminder and operating system versions ?

[sil3ntcor3]

Zoneminder v1.31.1 and Ubuntu 16.04.3 LTS

[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.

[sil3ntcor3]

Thanks.

[rockedge]

are you using mariadb or mysql for the database?

[sil3ntcor3]

MySQL

[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

[sil3ntcor3]

That line is there but I don't recall adding it or if it was there by default.

[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?

[sil3ntcor3]

So I ended up building a new VM and using mariadb and everything is working great now.

[rockedge]