using mysql

I had been able to create 2 users, I closed the guest, for all the next users created, it was impossible to login / change the password

log :

2019-07-23 16:39:54.716 ** ERROR ** [V8.1.2] on file '/var/www/html/Prj3dRTeam/model/UserMain.php' at line (436)
2019-07-23 16:39:54.716 ** ERROR ** [V8.1.2] cause = Undefined index:
2019-07-23 16:40:33.230 ** ERROR ** [V8.1.2] ERROR **
2019-07-23 16:40:33.230 ** ERROR ** [V8.1.2] on file '/var/www/html/Prj3dRTeam/model/UserMain.php' at line (436)
2019-07-23 16:40:33.230 ** ERROR ** [V8.1.2] cause = Undefined index:
2019-07-23 16:40:58.731 ** ERROR ** [V8.1.2] ERROR **

fix :

I realized that the problem was link to the id 123 of the table accessright with the value #10 to idAcessProfile

the last id of the table accessprofile was #9 and not #10 ... after a little research in the *.sql file i found :

-- V8.1 : remove this accessprofile which is no used
--INSERT INTO `${prefix}accessprofile` (`id`,`name`,`description`,`idAccessScopeRead`,`idAccessScopeCreate`,`idAccessScopeUpdate`,`idAccessScopeDelete`,`sortOrder`,`idle`) values 
--(10,'accessReadOwnOnly',null,2,1,1,1,900,0);

INSERT INTO `${prefix}accessright` (`idProfile`, `idMenu`, `idAccessProfile`) VALUES
(1, 91, 1),
(2, 91, 1),
(3, 91, 1),
(4, 91, 10),
(6, 91, 10),
(7, 91, 10),
(5, 91, 10);

and this look like my problem ... so i added the id #10 with
(10,'accessReadOwnOnly',null,2,1,1,1,900,0) in accessprofile

and now it's work ...

even if I don't understand where why I need the id #10 as it look like it had been removed if the 8.1

maybe it's because I canceled the guest ?

have a good day 🙂