Trilium doesn't start after backup restore

[Aleks8350]

I was following the guide on github to restoring my back up, but every time I copy the document.db into my trilium-data folder and try to launch, trilium auto generates the document.db-wal and document.db-shm files, instantly deletes them and nothing happens.
If I remove the document.db, it generates a new one and I have a fresh install.
At first, I thought that the database must be corrupted, but I can open it with SQL Browser and view my notes that way.
Any help would be appreciated.
Running Ubuntu 20.04 & app version 0.56.2

[sigaloid]

Try running Trilium in a command line, see if any errors are printed. The wal and shm files are separate files - they aren't the main database.

[Aleks8350]

Hi, thanks for the reply, this is the error:

App db version is 197, while db version is 170. Migration needed.
DB size: 15319 KB
Trusted reverse proxy: false
App HTTP server starting up at port 37840
{
"appVersion": "0.56.2",
"dbVersion": 197,
"syncVersion": 26,
"buildDate": "2022-10-27T22:41:15+02:00",
"buildRevision": "6c37f2ce7117f5df03ce9e79897a5520e36701a0",
"dataDirectory": "/home/aleks/.local/share/trilium-data",
"clipperProtocolVersion": "1.0",
"utcDateTime": "2022-11-10T19:59:43.434Z"
}
CPU model: Intel(R) Core(TM) i7-8650U CPU @ 1.90GHz, logical cores: 8 freq: 2648 Mhz
Listening on port 37840
Created backup at /home/aleks/.local/share/trilium-data/backup/backup-before-migration.db
ERROR: Direct migration from your current version is not supported. Please upgrade to the latest v0.47.X first and only then to this version.
The database connection is not open
Disabling scheduled backups.
The database connection is not open
The database connection is not open
TypeError: sql.getRawRows is not a function or its return value is not iterable
at load (/usr/lib/trilium/resources/app.asar/src/becca/becca_loader.js:33:27)
at /usr/lib/trilium/resources/app.asar/src/becca/becca_loader.js:18:9
TypeError: sql.getRawRows is not a function or its return value is not iterable
at load (/usr/lib/trilium/resources/app.asar/src/becca/becca_loader.js:33:27)
at /usr/lib/trilium/resources/app.asar/src/becca/becca_loader.js:18:9
Error: Option "spellCheckEnabled" doesn't exist
at getOption (/usr/lib/trilium/resources/app.asar/src/services/options.js:21:15)
at Object.getOptionBool (/usr/lib/trilium/resources/app.asar/src/services/options.js:46:17)
at Object.createMainWindow (/usr/lib/trilium/resources/app.asar/src/services/window.js:56:45)
at App. (/usr/lib/trilium/resources/app.asar/electron.js:33:29)
Error: Option "spellCheckEnabled" doesn't exist
at getOption (/usr/lib/trilium/resources/app.asar/src/services/options.js:21:15)
at Object.getOptionBool (/usr/lib/trilium/resources/app.asar/src/services/options.js:46:17)
at Object.createMainWindow (/usr/lib/trilium/resources/app.asar/src/services/window.js:56:45)
at App. (/usr/lib/trilium/resources/app.asar/electron.js:33:29)
(node:43589) UnhandledPromiseRejectionWarning: TypeError: sql.getRawRows is not a function or its return value is not iterable
at load (/usr/lib/trilium/resources/app.asar/src/becca/becca_loader.js:33:27)
at /usr/lib/trilium/resources/app.asar/src/becca/becca_loader.js:18:9
(Use trilium --trace-warnings ... to show where the warning was created)
(node:43589) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag --unhandled-rejections=strict (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 1)
(node:43589) UnhandledPromiseRejectionWarning: Error: Option "spellCheckEnabled" doesn't exist
at getOption (/usr/lib/trilium/resources/app.asar/src/services/options.js:21:15)
at Object.getOptionBool (/usr/lib/trilium/resources/app.asar/src/services/options.js:46:17)
at Object.createMainWindow (/usr/lib/trilium/resources/app.asar/src/services/window.js:56:45)
at App. (/usr/lib/trilium/resources/app.asar/electron.js:33:29)
(node:43589) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag --unhandled-rejections=strict (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 3)

[sigaloid]

The relevant line is ERROR: Direct migration from your current version is not supported. Please upgrade to the latest v0.47.X first and only then to this version., install the 0.47.x version mentioned. That should migrate you over. Then open the latest version and see if it will migrate