Unknown column 'MotionFrameSkip' in 'field list'

Forum for questions and support relating to the 1.27.x releases only.
Locked
aginzu
Posts: 16
Joined: Mon Apr 29, 2013 5:25 pm

Unknown column 'MotionFrameSkip' in 'field list'

Post by 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
Posts: 678
Joined: Wed Dec 16, 2009 4:32 pm
Location: Israel

Re: Unknown column 'MotionFrameSkip' in 'field list'

Post by 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`
Kfir Itzhak.
aginzu
Posts: 16
Joined: Mon Apr 29, 2013 5:25 pm

Re: Unknown column 'MotionFrameSkip' in 'field list'

Post by 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
Posts: 16
Joined: Mon Apr 29, 2013 5:25 pm

Re: Unknown column 'MotionFrameSkip' in 'field list'

Post by 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.
Locked