Ubuntu V2 to V4 upgrade failure

Sonarr version (exact version): 2.0.0.5344
Mono version (if Sonarr is not running on Windows): 5.18.0.240
OS: Linux 4.15.0-213-generic x86_64
Debug logs: N/A
Description of issue: Upgrading from V2 to V4 appears to work as the install script shows that it completes successfully and I can see the sonarr service running but cannot access web gui. Some notes below.

After running the installer via curl I get the prompt that installation was successful and to navigate to the local IP on the same port of 8989 but when i try from a browser i get a connection refused error. I have tried leaving everything at default (user sonarr and group media) as well as using root for the user and the same problem occurs.

Perhaps this helps?

… :~$ sudo systemctl status sonarr
● sonarr.service - Sonarr Daemon
Loaded: loaded (/etc/systemd/system/sonarr.service; enabled; vendor preset: enab
Active: active (running) since Wed 2024-03-13 02:07:12 UTC; 3min 33s ago
Main PID: 7062 (Sonarr)
Tasks: 10 (limit: 2312)
CGroup: /system.slice/sonarr.service
└─7062 /opt/Sonarr/Sonarr -nobrowser -data=/var/lib/sonarr/

Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] NzbDrone.Core.Datastore.Mi
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] NzbDrone.Core.Datastore.Mi
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: [Info] FluentMigrator.Runner.Migr
Mar 13 02:07:18 streamingautomation Sonarr[7062]: SQLite error (1): no such column:

You may need to revert to v2, restore your DB from backup, update to v3, allow migration to finish, then update to v4.

It’s running on a VM and I took a snapshot before the upgrade, so I simply reverted the snapshot so at least I have V2 working (which coincidentally works pretty well still).

So the question is, how can I update to v3? I couldn’t find any good instructions.

TIA!!

https://sonarr.tv/#downloads-linux-ubuntu

See the advanced users section and just change the version in the download link from 4 to 3.

Thanks. I’ve downloaded the tar.gz file but now what? Have a link to instructions? I am not very familiar with linux. I really appreciate the help!

https://www.reddit.com/r/sonarr/comments/ikg4l6/comment/g3l8vwb/

Or download https://raw.githubusercontent.com/Sonarr/Sonarr/develop/distribution/debian/install.sh, edit the version in the dlbase URL to 3, and run that script with sudo bash install.sh.