ZoneMinder Forums

This is my backup/testing server, My old install got messed up doing an upgrade so I started with fresh 16.04 install. Followed the wiki install for zoneminder install and installed 1.31.1 and it works perfect. So i added the storage areas ppa and installed and it upgraded no errors. Now setting on 1.31.27, when I hit add new monitor, the page is blank and this error is created in the log

SQL-ERR 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zm.Monitor' doesn't exist', statement was 'SELECT Name FROM Monitor' params:

I have push some new packages that fix this.

Basically there is a missing s in an sql statment.

edit /usr/share/zoneminder/www/skins/classic/views/js/monitor.js.php

at line 39

change

$query = empty($_REQUEST['mid']) ? dbQuery('SELECT Name FROM Monitor') : dbQuery('SELECT Name FROM Monitors WHERE Id != ?', array($_REQUEST['mid']) );

to

$query = empty($_REQUEST['mid']) ? dbQuery('SELECT Name FROM Monitors') : dbQuery('SELECT Name FROM Monitors WHERE Id != ?', array($_REQUEST['mid']) );

Thank You, that fixed it.