I recently changed my device so I backed up my NzbDrone (sonarr v2) install and then installed v4 fresh. I then imported my back, and low and behold it’s borked. It will not add any existing series due to an SQL error in the database.
I read I should go from v2 > v3 and then to v4. Problem is, I can’t find the v3 install. Could someone point me to it please?
It’s not really necessary to first upgrade to v3, as v4 contains the same migrations, theres just more of them. If the DB isn’t working with v4 then there was some level of corruption with it when it was running in v2, just not in a way that had surfaced yet as v4 migrations touch a lot of different things.
Probably a good idea to start with the information requested when opening the thread, including logs that contain the error you’re getting.