After doing a lot of testing I determined that it was not the database at all causing the problems. The problem was with the latest beta version of Plex
1.32.5.7210-77f7f99fa
which for some reason causes my TV library to stop working with collection creation. This only seems to affect manual collections and not smart collections