problem after upgrade to 1.26.4

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

[chippy99]

Did you run zmupdate.pl to update the database ? It seems to be complaining about a missing column in your database.

[topromotion]

Yes, i am run a zmupdate.pl, and upgrading of db pass succesfuly/

[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

[chippy99]

Clutching at straws but have you set monitor colour space to 32 bit ?

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

[topromotion]

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! =)