WhoDis 1 Posted March 30, 2020 Share Posted March 30, 2020 How can I mass remove them? I dont know how it happened Lots of my users are complaining new accounts that I set them up appear used. How can I scrub user history? Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 (edited) How can I mass remove them? I dont know how it happened Lots of my users are complaining new accounts that I set them up appear used. How can I scrub user history? Logged as the user or have them do it, multi-select each library on home screen and click the three dot menu in top right and mark unplayed. As for Favorites only way I know of is Deleting the user and recreating them. Edited March 30, 2020 by Happy2Play Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 I guess if you use the Server Configuration Backup plugin, you could create a New user, runs a backup, then restore that new users data to all other users. Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 Logged as the user or have them do it, multi-select each library on home screen and click the three dot menu in top right and mark unplayed. As for Favorites only way I know of is Deleting the user and recreating them. I guess if you use the Server Configuration Backup plugin, you could create a New user, runs a backup, then restore that new users data to all other users. hey I tried this problem is completely new users are getting created with watch history and favorites Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 (edited) hey I tried this problem is completely new users are getting created with watch history and favorites Note sure then, I just created two new users and they contained no watched status or favorites. I guess you would need to list the exact steps your taking. Edited March 30, 2020 by Happy2Play Link to comment Share on other sites More sharing options...
Luke 37253 Posted March 30, 2020 Share Posted March 30, 2020 Where is the watch data coming from? Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 Where is the watch data coming from? I am assuming the library.sql database I copy pasted to avoid scanning everything again Link to comment Share on other sites More sharing options...
Luke 37253 Posted March 30, 2020 Share Posted March 30, 2020 Yes that would be it. Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 (edited) I am assuming the library.sql database I copy pasted to avoid scanning everything again By doing that you are maintaining userdata, so I would assume recreating same username would relink existing userdata. Actually it looks like the userdata table in library.db is indexed starting with userid 1 and so on. So without the users.db each added users would get linked to existing index userid userdata. Edited March 30, 2020 by Happy2Play Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 Yes that would be it. wait so how do I fix it? how do I clean everyones watch history and their favorites Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 By doing that you are maintaining userdata, so I would assume recreating same username would relink existing userdata. Actually it looks like the database is index starting with user 1 and so on. So without the users.db each added users would get linked to existing index id users userdata. so how do I fix this? Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 so how do I fix this? Post 3 if you are Premiere. Otherwise you have to manually clear them via the UI. Or shutdown Emby, open the database, go to usersdata table and clear each userid that needs clearing. You can look at the users.db to see what id is assigned to each user. Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 Post 3 if you are Premiere. Otherwise you have to manually clear them via the UI. Or shutdown Emby, open the database, go to usersdata table and clear each userid that needs clearing. You can look at the users.db to see what id is assigned to each user. I tried post 3 problem is new users created also have a watch history Link to comment Share on other sites More sharing options...
CBers 6795 Posted March 30, 2020 Share Posted March 30, 2020 Don't restore your users from the Server Backup plugin, but create new ones and then restore watched status from old user to new user, even if the names are the same. Done it many times in the past without any issue, but YMMV. Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 The issue may be you have lots of indexed userids in you database and have to create beyond that number to have a clean user. Only looking in the database will tell. Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 The issue may be you have lots of indexed userids in you database and have to create beyond that number to have a clean user. Only looking in the database will tell. yes I feel that might be the case but that'll take a long time unfortunately was hoping for a easier solution Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 Not having proper databases, you have to do all the work manually. Should be easy enough to look at the users.db and see your last id, then go to the library.db usersdata table sort userid column delete everything after your last userid number. Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 Not having proper databases, you have to do all the work manually. Should be easy enough to look at the users.db and see your last id, then go to the library.db usersdata table sort userid column delete everything after your last userid number. ok see my current user.db see lets say have 5 members check library db has 50 members so I need to delete everything in library db after 5 members? (side question. If I delete everything including members will that fix the issue for existing users?) and then add 6th member and then new users added will have clean history? Link to comment Share on other sites More sharing options...
Happy2Play 8356 Posted March 30, 2020 Share Posted March 30, 2020 ok see my current user.db see lets say have 5 members check library db has 50 members so I need to delete everything in library db after 5 members? (side question. If I delete everything including members will that fix the issue for existing users?) and then add 6th member and then new users added will have clean history? You need to delete all troubled userids and anything beyond your current 5 users. You can see the actual NAME for each id in the users.db. Or since you have Server Configuration Backup plugin clear all data in usersdata table, and restore only your known good userdata. Link to comment Share on other sites More sharing options...
WhoDis 1 Posted March 30, 2020 Author Share Posted March 30, 2020 (edited) You need to delete all troubled userids and anything beyond your current 5 users. You can see the actual NAME for each id in the users.db. Or since you have Server Configuration Backup plugin clear all data in usersdata table, and restore only your known good userdata. ah so I can edit userdata table in a backup I create? clear everything and restore using server configuration backup and I wont have to deal with doing anything else that would be less work Edited March 30, 2020 by supedup321 1 Link to comment Share on other sites More sharing options...
Luke 37253 Posted March 31, 2020 Share Posted March 31, 2020 If you're handy with sqlite databases yes you can always do that. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now