Page 1 of 1

problem after upgrade to 1.26.4

Posted: Mon Nov 18, 2013 9:31 pm
by topromotion
Hello!

After upgrading from 1.25.0 to 1.26.4 i have a problem - all monitors stay a red color in list, and in log lots of error like that:

Memory map file '/dev/shm/zm.mmap.20' should have been 896 but was instead 0
Can't run query: Unknown column 'Colours' in 'field list'
'zma -m 21' exited abnormally, exit status 30

I use a Dlink ip camera dcs-932l, its works through http.

Re: problem after upgrade to 1.26.4

Posted: Tue Nov 19, 2013 1:19 am
by chippy99
Did you run zmupdate.pl to update the database ? It seems to be complaining about a missing column in your database.

Re: problem after upgrade to 1.26.4

Posted: Tue Nov 19, 2013 6:49 am
by topromotion
Yes, i am run a zmupdate.pl, and upgrading of db pass succesfuly/

Re: problem after upgrade to 1.26.4

Posted: Tue Nov 19, 2013 6:57 am
by topromotion
i have another pc with zoneminder 1.25.0, in /dev/shm/ have a several files like zm.mmap.10, zm.mmap.11. But after update this files disappeared

Re: problem after upgrade to 1.26.4

Posted: Tue Nov 19, 2013 2:34 pm
by chippy99
Clutching at straws but have you set monitor colour space to 32 bit ?

Re: problem after upgrade to 1.26.4

Posted: Tue Nov 19, 2013 2:37 pm
by mastertheknife
Hi,

Execute the SQL statements below to fix this manually:

Code: Select all

ALTER TABLE `Monitors` ADD `Colours` TINYINT UNSIGNED NOT NULL DEFAULT '1' AFTER `Height`;
ALTER TABLE `Monitors` ADD `Deinterlacing` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `Orientation`

Re: problem after upgrade to 1.26.4

Posted: Tue Nov 19, 2013 2:42 pm
by topromotion
mastertheknife wrote:Hi,

Execute the SQL statements below to fix this manually:

Code: Select all

ALTER TABLE `Monitors` ADD `Colours` TINYINT UNSIGNED NOT NULL DEFAULT '1' AFTER `Height`;
ALTER TABLE `Monitors` ADD `Deinterlacing` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `Orientation`
Thank you! Its works for me! =)