I posted about this on GitHub as an issue and as it’s been a week, I thought I would seek some advice here.
I followed these steps from the docs as I had to change my VPS provider.
During the restore process, the difficulty is with SQLite. Doing:
sqlite3 $DATABASE_PATH <gitea-db.sql
gives hundreds of errors, such as
Error: near line 1459: no such column: true Error: near line 1460: no such column: true Error: near line 1468: no such column: false Error: near line 1469: no such column: false
The previous server had the same git and gitea versions.
Any suggestion would be greatly appreciated.