ZoneMinder Forums

2021-04-18 08:29:11 zmdc 1227 ERR 'zmc -m 9' exited abnormally, exit status 255 zmdc.pl -
2021-04-18 08:29:11 zmc_m9 4852 ERR Can't run query: Unknown column 'Importance' in 'field list'


Worked fine last night. Didn't do any updates or anything that I know of.

1.35.26

For some reason the 1.35.25 db update hasn't happened. That column was added there.

mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.35.25.sql

It tried to update today.
This is the error



Initiating database upgrade to version 1.35.26 from version 1.35.23

Upgrading database to version 1.35.26
Loading config from DB 220 entries
Saving config to DB 220 entries
Upgrading DB to 1.35.24 from 1.35.23
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1419 (HY000) at line 4 in file: '/usr/share/zoneminder/db/triggers.sql': You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
Output: This update may make changes that require SUPER privileges. If you see an error message saying:

ERROR 1419 (HY000) at line 298: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_functio
This update may make changes that require SUPER privileges. If you see an error message saying:\n\nERROR 1419 (HY000) at line 298: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)\n\nYou will have to either run this update as root manually using something like (on ubuntu/debian)\n\nsudo mysql --defaults-file=/etc/mysql/debian.cnf zm < /usr/share/zoneminder/db/zm_update-1.35.24.sql\n\nOR\n\nsudo mysql --defaults-file=/etc/mysql/debian.cnf "set global log_bin_trust_function_creators=1;"\nsudo zmupdate.pl\n\nOR\n\nTurn off binary logging in your mysql server by adding this to your mysql config.\n[mysqld]\nskip-log-bin\n\n
Event_Summaries Already exists
Event_Summaries Already exists
Command 'mysql -hlocalhost -uzmuser -p'zmpass' zm < /usr/share/zoneminder/db/zm_update-1.35.24.sql' exited with status: 1
Error updating db.
dpkg: error processing package zoneminder (--configure):
installed zoneminder package post-installation script subprocess returned error exit status 1
Errors were encountered while processing:
zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)

You either run zmupdate as a more powerful DB user, or turn off binary logging. (As it states in the text you posted)