How Can We Help?
Change user id
It can happend that you can’t login into a programm from the good mode.
This can be possible because the user “rv” is not 1, so it should be changed to be 1 with the following of querry.
SET @oldUserId = 1;
SET @newUserId = 3;
UPDATE `Users` SET `UserId` = @newUserId WHERE `UserId` = @oldUserId;
UPDATE `UsersToStatistics` SET `UserId` = @newUserId WHERE `UserId` = @oldUserId;
UPDATE `Reservations` SET `UserId` = @newUserId WHERE `UserId` = @oldUserId;
UPDATE `ReservationsAccounts` SET `UserId` = @newUserId WHERE `UserId` = @oldUserId;
UPDATE `log_reservations` SET `id_user` = @newUserId WHERE `id_user` = @oldUserId;
UPDATE `log_reservation_accounts` SET `id_user` = @newUserId WHERE `id_user` = @oldUserId;
UPDATE `LogUser` SET `UserId` = @newUserId WHERE `UserId` = @oldUserId;
UPDATE `UsersHotels` SET `UserId` = @newUserId WHERE `UserId` = @oldUserId;