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

Current Development version likely to have breaking changes
Post Reply
IgorA100
Posts: 66
Joined: Sat Feb 03, 2024 11:55 am

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

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

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

Post by iconnor »

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