Unknown column 'MotionFrameSkip' in 'field list'

[aginzu]

I'm trying to install Zoneminder 1.27.0 from source on 32 bit Ubuntu 12.04 and zma exits abnormally. The message is "ERR [Can't run query: Unknown column 'MotionFrameSkip' in 'field list']". I have tried deleting the database and recreating it with mysql zm < db/zm_create.sql and I still get the same error after restarting zoneminder.

I had a pre-built earlier version installed and want to update to 1.27 from source. The earlier version (1.26) worked, but this is the first time I have tried installing from source.

Any suggestions?

[mastertheknife]

Hi,

Did you run zmupdate.pl after installing this version of ZM?

At any case, you can add that new field manually to the database using this SQL statement:

Code: Select all

ALTER TABLE `Monitors` ADD `MotionFrameSkip` smallint(5) unsigned NOT NULL default '0' AFTER `FrameSkip`

[aginzu]

Thanks for the response.

When I run zmupdate.pl I get

"Warning, overriding installed ./zm.conf file with local copy
Database already at version 1.27, update aborted."

I added the new field manually, and now I get

Can't run query: Unknown column 'ExtendAlarmFrames' in 'field list'

It looks like the db/zm_create.sql that is supposed to populate the database is missing some items. Can I get a correct copy of it from somewhere, or do I need to back the database down to some other version so that zmupdate.pl will run?

[aginzu]

I fixed the problem by running zm_update-1.27.1.sql in mysql.

Apparently, somehow, although the source tree I downloaded is called 1.27.0, it's actually 1.27.1. which is why the tables were missing.