What table did you drop?
SELECT name FROM sqlite_master
to see if you still have your backup table, if so just do the
INSERT INTO PlaybackActivity SELECT *, 0 FROM PlaybackActivity_<TIME STAMP>
Pm me your zipped unaltered backup file and I will have a look.
@TeamB A few hours after I posted I managed to restore the playback history using the SQL approach. On previous attempts, executing the SELECT command came back with a PlaybackActivity backup table that had no time stamp. Executing the INSERT INTO script did nothing. I played a couple of videos and then tried again. This time a backup table with a time stamp was listed. Importing it restored the database with the full playback history.
Its kind of a moot point now. When I woke up this morning, I found that the "Playback Reporting" plugin had been updated to version 1.4.11. The release notes identify that it is not compatible with Beta versions of Emby, which is the release channel I am on. So now there is no longer a "Playback Reporting" option listed in the side menu. I went to the plugin catalog to rollback to an older version of the plugin. But the most recent version other than 1.4.11 is 126.96.36.199. Is there somewhere I can get the 1.4.10 version? And is there a way I can stop Emby from reinstalling the 1.4.11 version after rolling back?
Nevermind. I just read your post to @Happy2Play where you state "Perhaps I need to look into having the plugin not load if it detects the server is BETA." I suspect that is what the 1.4.11 release was intended to do. Which kind of sucks. I purposely stuck with the 188.8.131.52 beta version of Emby to keep the "Playback Reporting" plugin functionality. It worked fine on that version. I understand your decision though.
Edited by DarWun, 25 May 2019 - 01:05 PM.