I just bought a Life Pass using another e-mail, and I successfully transferred my server’s ownership over my new account following one of your guides.
My personal watching history is there, but the managed users for obvious reason had to be recreated and lost the connection with their watching history.
Is it possible to connect my new managed users to their watching history using some SQLite, or that’s a long shot?
Another thing, I created that damn Guest user by mistake and I can’t find a way to get rid of it, is it possible?
Note: this is strictly unsupported. Save your original db file prior to making any edits.
If you subsequently get difficulties with statistics or “played” status, you may have to scrap the user and give him a new “identity”.
Although the update below didn’t work (I don’t know why he was trying to do that once all users’ id were already updated), my managed users got their watching history back.
UPDATE accounts SET id = (SELECT ua.new from ua WHERE accounts.id = ua.old) WHERE EXISTS (SELECT * FROM ua WHERE accounts.id = ua.old);
