All users disappeared

[Pietro_Boidi]

Self hosted CMS
All users disappeared from the CMS.

Steps I did:

• accessed with admin and create a new user
• opened a Chrome incognito window
• accessed with the new user to the new incognito window

When I came back to the admin CMS all users are disappeared. I can see for example that a folder assigned to a specific user, but I cannot see any user in the user list.

See attached screenshot

User table (does not seems any strange to me)

| userId | userTypeId | userName | userPassword | lastAccessed | email | homePageId | retired | csprng | newUserWizard | firstName | lastName | phone | ref1 | ref2 | ref3 | ref4 | ref5 | isPasswordChangeRequired | twoFactorTypeId | twoFactorSecret | twoFactorRecoveryCodes | homeFolderId |
±-------±-----------±-----------±-------------------------------------------------------------±--------------------±------------------------------±-----------------------±--------±-------±--------------±----------±---------±------±-----±-----±-----±-----±-----±-------------------------±----------------±----------------±-----------------------±-------------+
| 1 | 1 | aaadmin | $2y$10$AAAdTebKnhvWsj7J0vZlR.CakM0UMPee5JU.s7FQmkgd3NJG1RFIm | 2023-11-20 15:49:42 | XXXXXXXXXX@promelit.it | statusdashboard.view | 0 | 2 | 1 | | | | | | | | | 0 | 0 | NULL | NULL | 1 |
| 2 | 2 | omega | $2y$10$AAAOKqfz6mkt8HZuJ1sA1ODRmYmgsur.mTLbBjlPXlwcRrWzJvTUO | 2023-11-08 12:57:41 | XXXXXXXXXX@promelit.it | playlistdashboard.view | 0 | 2 | 1 | | | | | | | | | 0 | 0 | NULL | NULL | 2 |
| 3 | 3 | armageddon | $2y$10$SSSo6IHk0caWMmaqbjCvGeMVNjxbBLXTMwhkCOLqJM0zodvz8fB4a | 2023-11-07 20:47:53 | XXXXXXXXXXpellini@promelit.it | playlistdashboard.view | 0 | 2 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | 1 |
| 4 | 3 | homunculus | $2y$10$AAALMZ.FW.q98rDljQj0MuRGgoQJPtJiurGkK3kXvA1PjsU5NinBK | NULL | | playlistdashboard.view | 0 | 2 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | 1 |
| 5 | 3 | Kerfuffle | $2y$10$SSSHKTm2rud9XlJhvqRTZu.aXn/ax4m5G6MD7lS3Qn8rLHBbd9Lm2 | NULL | paolo@nonmiricordo.com | playlistdashboard.view | 0 | 2 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | 1 |
| 6 | 3 | Pietro | $2y$10$AAAx3FE8l7mBznJClUaDi.H8qgiKHrhmiAiuznHRaCJNwICLAi.bu | 2023-11-20 14:38:26 | | NULL | 0 | 2 | 1 | | | | | | | | | 0 | 0 | NULL | NULL | 3 |
±-------±-----------±-----------±-------------------------------------------------------------±--------------------±------------------------------±-----------------------±--------±-------±--------------±----------±---------±------±-----±-----±-----±-----±-----±-------------------------±----------------±----------------±-----------------------±-------------+
6 rows in set (0.00 sec)

Very strange

Thanks
Pietro

CMS Version

Version 4.0.4

[Pietro_Boidi]

I solved.

I do not why but one user have been created with homePageId = NULL

Therefore the application rise an error.

I fixed with the following query:
update user set homePageId=‘playlistdashboard.view’ where userId=6;

Xibo → Please check why this happens.

Thanks
Pietro