Move existing sonarr.db from Mac to QNAP NAS

[dazz2017]

Sorry but this query will be a bit convoluted and may not be your issue.

I’m currently running Sonarr on my Macbook successfully and now want to move it to my QNAP NAS. I've installed Sonarr from the sherpa repo and all config is correct (d/l clients defs, root paths, local & remote paths etc) on the NAS and I can add TV Shows to it no problem (on the NAS).

Now I want to transfer my existing Mac sonarr.db to the NAS replacing the vanilla NAS copy. I've done this xfer in the past from Windows to Mac successfully as the sonarr.db files are the same.

However, Sonarr on the NAS says the Mac sonar.db file is corrupt. Conversely if I copy the vanilla NAS sonarr.db to my Mac, sonarr there says IT'S corrupt.

I've download the DB Browser for SQlite app from github and it can open the Mac sonarr.db fine but IT reports the NAS sonarr.db as corrupt. It's obviously OK for the NAS sonarr instance so any thoughts as to why the NAS sonarr.db format is so different to the others (Mac & Windows)?

[OneCDOnly]

Hi Dazz.

The only thing that comes to mind is that each database may have been written with different versions of the software.

I think this will need help from the Sonarr folks. Can you please contact them and ask about this?

[dazz2017]

Yes, I thought about that. The sherpa installed sonarr version is 4.0.15.2941 whereas the Mac & Win versions are both 4.0.15.2940 so both late V4 releases.

I've just discovered that I can open the NAS sonarr.db file using DB Browser if it's on a local (Mac) drive but not if it's on a NAS shared folder so the DB is probably fine. I'm guessing there is something different in the cfg between the NAS and my Mac that stopping it from opening that isn't a problem b/w my Mac and Windows PCs.

Given the Appdata and Startup directories are different between all 3 instances (Mac/NAS/WIN) it must be something else critically different but I can't find it.