SQL-ERR 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'zm.Monitor' doesn't exist', statement was 'SELECT Name FROM Monitor' params:
Install of ZM 1.31.27, cannot create new monitor.
-
- Posts: 12
- Joined: Mon Jan 22, 2018 7:02 pm
Install of ZM 1.31.27, cannot create new monitor.
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
Re: Install of ZM 1.31.27, cannot create new monitor.
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']) );
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']) );
-
- Posts: 12
- Joined: Mon Jan 22, 2018 7:02 pm
Re: Install of ZM 1.31.27, cannot create new monitor.
Thank You, that fixed it.