1.37.47 unable to add user
Posted: Sat Dec 09, 2023 12:11 pm
Hello,
When I try to add a user on1.37.47 I get the following SQL error:
SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Snapshots' cannot be null', statement was 'INSERT INTO `Users` (`Username`, `Name`, `Email`, `Phone`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Groups`, `Devices`, `Snapshots`, `System`, `MaxBandwidth`, `TokenMinExpiry`, `APIEnabled`, `HomeView`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' params:jon,jon,xxxxxxxxxxxxx,xxxxxxxxxxxxx,$2y$10$ZU4x96c9UV3y12eVqsUQbeLpJ8204ccEppFifzWHkGOo7LZ0VCnUC,en_gb,1,View,View,View,View,View,View,,View,high,,1,console
There is no snapshot option in the config section of users. Is there another setting that needs checking?
When I try to add a user on1.37.47 I get the following SQL error:
SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Snapshots' cannot be null', statement was 'INSERT INTO `Users` (`Username`, `Name`, `Email`, `Phone`, `Password`, `Language`, `Enabled`, `Stream`, `Events`, `Control`, `Monitors`, `Groups`, `Devices`, `Snapshots`, `System`, `MaxBandwidth`, `TokenMinExpiry`, `APIEnabled`, `HomeView`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' params:jon,jon,xxxxxxxxxxxxx,xxxxxxxxxxxxx,$2y$10$ZU4x96c9UV3y12eVqsUQbeLpJ8204ccEppFifzWHkGOo7LZ0VCnUC,en_gb,1,View,View,View,View,View,View,,View,high,,1,console
There is no snapshot option in the config section of users. Is there another setting that needs checking?