ZoneMinder Forums

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?

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:

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?

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.