Server Version#: DSM 6.2.4-25556
Player Version#:
<If providing server logs please do NOT turn on verbose logging, only debug logging should be enabled>
Everything was fine and working, i made no changes to anything. I had to turn off my house power for a day or so to make some upgrades. when i turned everything back on, the server i had on my synology wasn’t available. when i accessed the DSM through my computer, it said it was stopped.
i tried restarting it, but it refused to start, sometimes it would say “running” and i would try to access it through the DSM web UI, but it would say "refused to connect, and then it would show “stopped” in the DSM.
i have uninstalled and reinstalled multiple times and it still refuses to start, i get a “failed to run the package service” window. i have even tried to install via downloaded updates to no avail.
Specifically, the DB structure internally was stopped in the middle of updating and is now corrupted.
DBRepair can’t fix that.
DBRepair can select and install one of the backup databases.
Using a backup DB is the correct action here.
Jun 15, 2024 11:42:28.417 [0xf4c45a40] ERROR - SQLITE3:0x1a36004, 1, no such table: sqlite_schema in "UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_metadata_mappings' AND type = 'table'"
Jun 15, 2024 11:42:28.418 [0xf4c45a40] ERROR - Exception inside transaction (inside=1) (../Library/DatabaseMigrations.cpp:209): sqlite3_statement_backend::prepare: no such table: sqlite_schema for SQL: UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_metadata_mappings' AND type = 'table'
Jun 15, 2024 11:42:28.428 [0xf4c45a40] ERROR - Exception thrown during migrations, aborting: sqlite3_statement_backend::prepare: no such table: sqlite_schema for SQL: UPDATE sqlite_schema SET sql = replace(sql, 'dt_integer(8)', 'datetime') WHERE name = 'media_metadata_mappings' AND type = 'table'
