ZoneMinder / zoneminder

ZoneMinder is a free, open source Closed-circuit television software application developed for Linux which supports IP, USB and Analog cameras.
http://www.zoneminder.com/
GNU General Public License v2.0
5.13k stars 1.22k forks source link

BUG... after Upgrading #3746

Closed TheReiner closed 11 months ago

TheReiner commented 1 year ago

Hello, my ZoneMinder is stuck after upgrading... i Try to zmupdate.pl -f But i have always the problem :-(

Thanks

My configuration Debian (Stable) Bullseye (Lastversion)

Database upgrade to version 1.36.33 successful.

Freshening configuration in database
Migratings passwords, if any...
Loading config from DBNo option 'ZM_JANUS_PATH' found, removing.
No option 'ZM_JANUS_SECRET' found, removing.
 221 entries
Saving config to DB 227 entries
DBD::mysql::st execute failed: Unknown column 'System' in 'field list' at /usr/share/perl5/ZoneMinder/Config.pm line 244.
Can't execute when updating config entry ZM_SKIN_DEFAULT: Unknown column 'System' in 'field list' at /usr/bin/zmupdate.pl line 333.
Error updating config.
dpkg: error processing package zoneminder (--configure):
 installed zoneminder package post-installation script subprocess returned error exit status 1
Processing triggers for desktop-file-utils (0.26-1) ...
Processing triggers for gnome-menus (3.36.0-1) ...
Processing triggers for libc-bin (2.31-13+deb11u6) ...
Processing triggers for man-db (2.9.4-2) ...
Processing triggers for mailcap (3.69) ...
Processing triggers for libapache2-mod-php7.4 (7.4.33-1+deb11u4) ...
Processing triggers for php7.4-cli (7.4.33-1+deb11u4) ...
Errors were encountered while processing:
 zoneminder
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@ZoneMinder-Server:~# zmupdate.pl -f

Freshening configuration in database
Migratings passwords, if any...
Loading config from DBNo option 'ZM_JANUS_PATH' found, removing.
No option 'ZM_JANUS_SECRET' found, removing.
 221 entries
Saving config to DB 227 entries
DBD::mysql::st execute failed: Unknown column 'System' in 'field list' at /usr/share/perl5/ZoneMinder/Config.pm line 244.
Can't execute when updating config entry ZM_SKIN_DEFAULT: Unknown column 'System' in 'field list' at /usr/bin/zmupdate.pl line 333.
welcome[bot] commented 1 year ago

Thanks for opening your first issue here! Just a reminder, this forum is for Bug Reports only. Be sure to follow the issue template!

connortechnology commented 1 year ago

Looks like somehow the 1.36.16 db update did not get applied. Please try to do it manually: mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.36.16.sql