Install of ZM 1.31.27, cannot create new monitor.

Forum for questions and support relating to the 1.31.x releases only.
Locked
sonicspeedway
Posts: 12
Joined: Mon Jan 22, 2018 7:02 pm

Install of ZM 1.31.27, cannot create new monitor.

Post by sonicspeedway »

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:
User avatar
iconnor
Posts: 2900
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Install of ZM 1.31.27, cannot create new monitor.

Post by iconnor »

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']) );
sonicspeedway
Posts: 12
Joined: Mon Jan 22, 2018 7:02 pm

Re: Install of ZM 1.31.27, cannot create new monitor.

Post by sonicspeedway »

Thank You, that fixed it.
Locked