ZoneMinder broken when upgrading 1.26.4->1.26.5

[sgn]

The upgrade itself work out fine on a Debian 7.2 x64 system, starting the new build however fails spectacularly:

Code: Select all

2013-12-14 01:01:03.134100	zmdc	620	ERR	'zmc -m 13' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.133730	zmdc	620	ERR	'zmc -m 12' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.132596	zmc_m13	910	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.132479	zmc_m12	911	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.128830	zmdc	620	ERR	'zma -m 12' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.126794	zma_m12	913	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.122390	zmdc	620	ERR	'zma -m 15' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.121270	zmdc	620	ERR	'zma -m 13' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.120619	zma_m15	909	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.113346	zma_m13	906	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.111110	zmdc	910	INF	'zmc -m 13' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.109770	zmdc	911	INF	'zmc -m 12' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.109400	zmdc	620	ERR	'zmc -m 15' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.108660	zmdc	913	INF	'zma -m 12' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.107766	zmc_m15	905	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.107210	zmdc	620	INF	'zma -m 12' starting at 13/12/14 01:01:03, pid = 913	zmdc.pl	
2013-12-14 01:01:03.105630	zmdc	620	INF	Starting pending process, zma -m 12	zmdc.pl	
2013-12-14 01:01:03.104770	zmdc	620	INF	'zmc -m 12' starting at 13/12/14 01:01:03, pid = 911	zmdc.pl	
2013-12-14 01:01:03.103050	zmdc	620	INF	Starting pending process, zmc -m 12	zmdc.pl	
2013-12-14 01:01:03.102800	zmdc	909	INF	'zma -m 15' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.102230	zmdc	620	INF	'zmc -m 13' starting at 13/12/14 01:01:03, pid = 910	zmdc.pl	
2013-12-14 01:01:03.100530	zmdc	620	ERR	'zma -m 14' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.100110	zmdc	620	INF	Starting pending process, zmc -m 13	zmdc.pl	
2013-12-14 01:01:03.099750	zmdc	620	ERR	'zmc -m 14' exited abnormally, exit status 30	zmdc.pl	
2013-12-14 01:01:03.098030	zmdc	620	INF	'zma -m 15' starting at 13/12/14 01:01:03, pid = 909	zmdc.pl	
2013-12-14 01:01:03.096866	zma_m14	904	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.095890	zmdc	620	INF	Starting pending process, zma -m 15	zmdc.pl	
2013-12-14 01:01:03.095060	zmc_m14	903	ERR	Can't run query: Unknown column 'AlarmRefBlendPerc' in 'field list'	zm_monitor.cpp	2425
2013-12-14 01:01:03.093490	zmdc	906	INF	'zma -m 13' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.092080	zmdc	620	INF	'zma -m 13' starting at 13/12/14 01:01:03, pid = 906	zmdc.pl	
2013-12-14 01:01:03.085550	zmdc	620	INF	Starting pending process, zma -m 13	zmdc.pl	
2013-12-14 01:01:03.081120	zmdc	905	INF	'zmc -m 15' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.081040	zmdc	620	INF	'zmc -m 15' starting at 13/12/14 01:01:03, pid = 905	zmdc.pl	
2013-12-14 01:01:03.079490	zmdc	620	INF	Starting pending process, zmc -m 15	zmdc.pl	
2013-12-14 01:01:03.079120	zmdc	904	INF	'zma -m 14' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.079020	zmdc	620	INF	'zma -m 14' starting at 13/12/14 01:01:03, pid = 904	zmdc.pl	
2013-12-14 01:01:03.077460	zmdc	620	INF	Starting pending process, zma -m 14	zmdc.pl	
2013-12-14 01:01:03.076940	zmdc	903	INF	'zmc -m 14' started at 13/12/14 01:01:03	zmdc.pl	
2013-12-14 01:01:03.076920	zmdc	620	INF	'zmc -m 14' starting at 13/12/14 01:01:03, pid = 903	zmdc.pl	
2013-12-14 01:01:03.073860	zmdc	620	INF	Starting pending process, zmc -m 14

The issue seems to be caused by the DB upgrade, any ideas?

[mastertheknife]

Hi,

Run this SQL query:

Code: Select all

ALTER TABLE `Monitors` ADD `AlarmRefBlendPerc` TINYINT(3) UNSIGNED NOT NULL DEFAULT '3' AFTER `RefBlendPerc`;