Upgrade to 1.36.18(?) and get: Unknown column 'Private' in 'field list'

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
SkippyDo
Posts: 227
Joined: Mon Nov 20, 2017 6:49 pm

Upgrade to 1.36.18(?) and get: Unknown column 'Private' in 'field list'

Post by SkippyDo »

Upgraded from 1.36.12 to latest version which is listed as being 1.36.18 (per Debian apt).

Unable to bring up any ZM web pages.

Per troubleshooting tip (from lconnor) in another post/thread with similar issue (viewtopic.php?p=126566#p126566) here's the output from 'zmupdate.pl -f':
Freshening configuration in database
Migratings passwords, if any...
Loading config from DB 221 entries
Saving config to DB 221 entries
DBD::mysql::st execute failed: Unknown column 'Private' in 'field list' at /usr/share/perl5/ZoneMinder/Config.pm line 244.
Can't execute when updating config entry ZM_SKIN_DEFAULT: Unknown column 'Private' in 'field list' at /usr/bin/zmupdate.pl line 333.
SkippyDo
Posts: 227
Joined: Mon Nov 20, 2017 6:49 pm

Re: Upgrade to 1.36.18(?) and get: Unknown column 'Private' in 'field list'

Post by SkippyDo »

OK, got it resolved. Manually updated database (two updates - 1.36.16 and 1.36.18 which contained the newly added columns for Config).
Post Reply