Databases: Changing Guest user account id

Databases: Changing Guest user account id

par Eric Kemsley,
Nombre de réponses : 2

The Guest user account changed from 1 to 339 in the mdl_user table and the account no longer works. How can I change that back to 1.

I'm using mysql on a linux server.

TIA,

Eric

Moyenne des évaluations  -
En réponse à Eric Kemsley

Re: Databases: Changing Guest user account id

par Guido Vega,
Hi Eric,
I think by doing a simple UPDATE (i.e. UPDATE mdl_user SET id = '1' WHERE id = '339'). Of course there is if is not record with id = 1 in your mdl_user table.

Regards,
GV