After enabling authorization on site, errors appeared in DB. v1.37.55

[IgorA100]

Code: Select all

2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR '00000', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)'	/usr/share/zoneminder/www/includes/database.php	119
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Permission' cannot be null', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)' params:16,2,	/usr/share/zoneminder/www/includes/database.php	161
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR '00000', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)'	/usr/share/zoneminder/www/includes/database.php	119
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Permission' cannot be null', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)' params:12,2,	/usr/share/zoneminder/www/includes/database.php	161
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR '00000', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)'	/usr/share/zoneminder/www/includes/database.php	119
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Permission' cannot be null', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)' params:11,2,	/usr/share/zoneminder/www/includes/database.php	161
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR '00000', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)'	/usr/share/zoneminder/www/includes/database.php	119
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Permission' cannot be null', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)' params:10,2,	/usr/share/zoneminder/www/includes/database.php	161
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR '00000', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)'	/usr/share/zoneminder/www/includes/database.php	119
2/28/24, 10:47:53 PM GMT+3	web_php	279579	ERR	SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Permission' cannot be null', statement was 'INSERT INTO `Monitors_Permissions` (`MonitorId`, `UserId`, `Permission`) VALUES (?, ?, ?)' params:7,2,	/usr/share/zoneminder/www/includes/database.php	161

[iconnor]

Just pushed a fix for it. The issue was that it is trying to set permissions for monitors that have been deleted.