The database cannot be repaired.

[KizunerE 0]

My media library is not displaying any images, and the logs show some errors like 'SQLitePCL.pretty.SQLiteException.' I tried to follow the tutorial to repair the database, but the sqlite3 tool reports some error like:

"Parse error near line 320596: near "UserDataKeys2": syntax error
  ES (53610, 'Person-?????); INSERT OR IGNORE INTO 'UserDataKeys2'('Id', 'UserDa
                                      error here ---^"

 

How can I fix this? I also found that the new episodes added to my media library are not having their Episode Intros added. Even when I manually execute the scan task, it always returns 0 seconds. Is this also an issue caused by database corruption?

 

[Carlo 4561]

Hi, do you have the Emby Premiere Backup and Restore plugin installed and configured or any manual backup of your Emby Server folder?

Is this a new Emby Server you've recently setup?

Thanks,
Carlo

[KizunerE 0]

19 minutes ago, Carlo said:

Hi, do you have the Emby Premiere Backup and Restore plugin installed and configured or any manual backup of your Emby Server folder?

Is this a new Emby Server you've recently setup?

Thanks,
Carlo

Unfortunately, I don't have any backups, and I hadn't learned about backups before this. The server has been running for six months.

Edited October 5, 2024 by KizunerE

[Carlo 4561]

Ouch,

There is no easy way to fix this unfortunately without a valid backup.
If it were me, I'd setup the Backup and Restore plugin (requires Premiere) and do a backup of your current Emby config.
I'd then uninstall Emby and completely remove it from the system (after making a copy of all files/folders under the Emby parent root directory.
Then I'd install Emby, setup Premiere, install the Backup and Restore plugin, do a full system restore.

With a bit of luck, you'll be able to restore the system configuration settings, have all your user settings and the user watched status, your library setups, etc as well as a non-corrupt database. After a full library scan again with a bit of luck on your side things will be back working normally.

If this doesn't work, you may have to remove Emby, followed by a new install.

I wish I had better advice for you than this. Moving forward make sure to backup your system.

Carlo

[Happy2Play 9780]

If not a Premiere user, you should look at manual backups of the Emby programdata folder.

Configuration Backup | how-to-backup-manually

Or a bare minimum of the database in the /programdata/data folder.

[KizunerE 0]

On 10/6/2024 at 3:53 AM, Carlo said:

Ouch,

There is no easy way to fix this unfortunately without a valid backup.
If it were me, I'd setup the Backup and Restore plugin (requires Premiere) and do a backup of your current Emby config.
I'd then uninstall Emby and completely remove it from the system (after making a copy of all files/folders under the Emby parent root directory.
Then I'd install Emby, setup Premiere, install the Backup and Restore plugin, do a full system restore.

With a bit of luck, you'll be able to restore the system configuration settings, have all your user settings and the user watched status, your library setups, etc as well as a non-corrupt database. After a full library scan again with a bit of luck on your side things will be back working normally.

If this doesn't work, you may have to remove Emby, followed by a new install.

I wish I had better advice for you than this. Moving forward make sure to backup your system.

Carlo

I'm not a Premiere user，is there any way to recover undamaged data?

[Luke 42079]

8 hours ago, KizunerE said:

I'm not a Premiere user，is there any way to recover undamaged data?

Hi, do you have a previous copy of your server data folder before this issue occurred? That would be the best way.

[Carlo 4561]

On 10/7/2024 at 3:59 AM, KizunerE said:

I'm not a Premiere user，is there any way to recover undamaged data?

You could signup for Premiere for just a month to get access to the Backup & Restore Configuration plugin.
I really don't have any other suggestions to try if you don't have a previous copy.