No monitors showing in console, no montage, errors in log

[JBE-Zorg]

Just upgraded to the latest 1.37.37 (1.37.37~20230421175235-jammy) and am not seeing any monitors showing in the console nor any live views in Montage.

console.png (20.31 KiB) Viewed 672 times

montage.png (19.02 KiB) Viewed 672 times

I am seeing some SQL errors in the log:

Code: Select all

4/22/23, 6:58:23 AM EDT	web_php	10386	ERR	SQL-ERR dbFetchAll no result, statement was 'SELECT M.*, S.*, E.* FROM Monitors AS M LEFT JOIN Monitor_Status AS S ON S.MonitorId=M.Id LEFT JOIN Event_Summaries AS E ON E.MonitorId=M.Id WHERE M.`Deleted`=false ORDER BY Sequence ASC'	/usr/share/zoneminder/www/includes/database.php	195
4/22/23, 6:58:23 AM EDT	web_php	10386	ERR	SQL-ERR 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'M.Deleted' in 'where clause'', statement was 'SELECT M.*, S.*, E.* FROM Monitors AS M LEFT JOIN Monitor_Status AS S ON S.MonitorId=M.Id LEFT JOIN Event_Summaries AS E ON E.MonitorId=M.Id WHERE M.`Deleted`=false ORDER BY Sequence ASC' params:	/usr/share/zoneminder/www/includes/database.php	161
4/22/23, 6:56:03 AM EDT	web_php	10386	ERR	SQL-ERR dbFetchAll no result, statement was 'SELECT M.*, S.*, E.* FROM Monitors AS M LEFT JOIN Monitor_Status AS S ON S.MonitorId=M.Id LEFT JOIN Event_Summaries AS E ON E.MonitorId=M.Id WHERE M.`Deleted`=false ORDER BY Sequence ASC'	/usr/share/zoneminder/www/includes/database.php	195
4/22/23, 6:56:03 AM EDT	web_php	10386	ERR	SQL-ERR 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'M.Deleted' in 'where clause'', statement was 'SELECT M.*, S.*, E.* FROM Monitors AS M LEFT JOIN Monitor_Status AS S ON S.MonitorId=M.Id LEFT JOIN Event_Summaries AS E ON E.MonitorId=M.Id WHERE M.`Deleted`=false ORDER BY Sequence ASC' params:	/usr/share/zoneminder/www/includes/database.php	161
4/22/23, 6:52:02 AM EDT	web_php	6147	ERR	SQL-ERR dbFetchAll no result, statement was 'SELECT M.*, S.*, E.* FROM Monitors AS M LEFT JOIN Monitor_Status AS S ON S.MonitorId=M.Id LEFT JOIN Event_Summaries AS E ON E.MonitorId=M.Id WHERE M.`Deleted`=false ORDER BY Sequence ASC'	/usr/share/zoneminder/www/includes/database.php	195
4/22/23, 6:52:02 AM EDT	web_php	6147	ERR	SQL-ERR 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'M.Deleted' in 'where clause'', statement was 'SELECT M.*, S.*, E.* FROM Monitors AS M LEFT JOIN Monitor_Status AS S ON S.MonitorId=M.Id LEFT JOIN Event_Summaries AS E ON E.MonitorId=M.Id WHERE M.`Deleted`=false ORDER BY Sequence ASC' params:	/usr/share/zoneminder/www/includes/database.php	161

Errors when starting/restarting zoneminder service:

Code: Select all

4/21/23, 9:32:49 PM EDT	zms_m3	29184	ERR	Unable to connect to monitor id 3 for streaming	zm_stream.cpp	59
4/21/23, 9:32:49 PM EDT	zms_m3	29184	ERR	Shared data not initialised by capture daemon for monitor BACK	zm_monitor.cpp	1082
4/21/23, 9:32:49 PM EDT	zms_m4	29171	ERR	Unable to connect to monitor id 4 for streaming	zm_stream.cpp	59
4/21/23, 9:32:49 PM EDT	zms_m4	29171	ERR	Shared data not initialised by capture daemon for monitor SIDE	zm_monitor.cpp	1082
4/21/23, 9:32:49 PM EDT	zms_m1	29169	ERR	Unable to connect to monitor id 1 for streaming	zm_stream.cpp	59
4/21/23, 9:32:49 PM EDT	zms_m1	29169	ERR	Shared data not initialised by capture daemon for monitor FRONT	zm_monitor.cpp	1082
4/21/23, 9:32:48 PM EDT	zms_m3	29184	ERR	Unable to connect to monitor id 3 for streaming	zm_stream.cpp	59
4/21/23, 9:32:48 PM EDT	zms_m3	29184	ERR	Can't open memory map file /dev/shm/zm.mmap.3: No such file or directory	zm_monitor.cpp	862
4/21/23, 9:32:48 PM EDT	zms_m4	29171	ERR	Unable to connect to monitor id 4 for streaming	zm_stream.cpp	59
4/21/23, 9:32:48 PM EDT	zms_m4	29171	ERR	Can't open memory map file /dev/shm/zm.mmap.4: No such file or directory	zm_monitor.cpp	862
4/21/23, 9:32:48 PM EDT	zms_m1	29169	ERR	Unable to connect to monitor id 1 for streaming	zm_stream.cpp	59
4/21/23, 9:32:48 PM EDT	zms_m1	29169	ERR	Can't open memory map file /dev/shm/zm.mmap.1: No such file or directory	zm_monitor.cpp	862

[iconnor]

New packages building, in the meantime do mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.37.39.sql

[JBE-Zorg]

Thank you, that did the trick! Much appreciated.

Errors gone and everthing looks to be working normally.