Forum GLPI-Project

Gplo

Member

Registered: 2018-02-15

Posts: 4

Deleted Almost All users

Hi,

Ive deleted almost all the users, the reasson is that we had them as Super-Admin user,

So what i did is click in admnistration tab, then profiles and super admin.

I choose all the super admin with the exception of IT,

The surprise once i quit the role of super admin is that all thoose users desapeared, becase they didnt have the "normal" user role,

We previously checked that they had both roles, but it was a coincidence that the users we checked had both roles.

we do not have any backup and the users who were deleted can not login anymore, we can not syncronyce either because it says "thoose users already exist"

What can we do? Thank you so much.

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,167

Re: Deleted Almost All users

FIRST dump your database ! and make sure you can restore;

INSERT INTO glpi_profiles_users (profiles_id,entities_id,is_recursive,is_dynamic) SELECT glpi_users.id,1,0,0 from glpi_users

---

Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

Gplo

Member

Registered: 2018-02-15

Posts: 4

Re: Deleted Almost All users

FIRST dump your database ! and make sure you can restore;

INSERT INTO glpi_profiles_users (profiles_id,entities_id,is_recursive,is_dynamic) SELECT glpi_users.id,1,0,0 from glpi_users

Hi @LaDenrée

We have tried to do it but sadly nothing has change,

Would you need any other detail about what we did?

Thank you for your answer

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,167

Re: Deleted Almost All users

can you check if users still are in glpi_users table ?

---

Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6

Gplo

Member

Registered: 2018-02-15

Posts: 4

Re: Deleted Almost All users

can you check if users still are in glpi_users table ?

Yes, they have the field Profiles ID as 0 or 404, we need to change them to 5

Thank you so much

Gplo

Member

Registered: 2018-02-15

Posts: 4

Re: Deleted Almost All users

Hello, we have already fixed it doing what i mentioned in the last comment,

Thank you for your help.