Hi guys,
I had been troubleshooting a duplicate TV show being scraped into my library and may have inadvertently broken something with my watch progress within MariaDB. Before I was mucking around with the DB, my two RPi5s running Libreelec with a shared MariaDB library would instantly update watch progress between upstairs and downstairs. After I fudged around with cleanups and other tidbits on the DB, the watch progress only seems to update every library update (certainly not instant as it was previously). Is there something I might have busted when trying to clean up duplicates and the overall DB?
For reference, I kinda screwed up my entire TV show library and had to do loads of cleanup because TV shows were being duplicated every update. I changed my source from a name (XXXNAS) to IP address (192.168.X.X) and it refreshed the entire thing causing duplicates. I then reverted the change which caused it to triplicate entries.