Jump to content

SQLitePCL.pretty.SQLiteException Error


EuG0000
 Share

Go to solution Solved by Luke,

Recommended Posts

Hi, I'm running Windows EMBY server: Version 3.1.5.0

 

I've been getting Refresh Guide, Clean DB failures etc.

It looks like SQLitePCL.pretty.SQLiteException Error is the cause.

 

I'm attaching the log extract that shows this error.

Any advise on how to fix this?

 

Thank you,

 

LogExtract.txt

Link to comment
Share on other sites

  • Solution

Hi there @@EuG0000, unfortunately your library database file has become corrupt, so you will need to shut down the server and delete this file

C:\Users\EuG\AppData\Roaming\MediaBrowser-Server\data\library.db

This file also contains your watch data, so you might want to back that up before doing so. We have documentation on that here:

 

https://emby.media/community/index.php?/topic/10427-how-to-migrate-emby-server

 

Let us know if you have any issues. Thanks.

  • Like 1
Link to comment
Share on other sites

Thank you.

That worked.

 

What's interesting is that looking at my files I've actually done this before (I have an older .BACK version of my library.db file)

This time I've also noticed there's another very large DB file called refreshinfo.db - I've decided to "delete" (rename to .BACK) that one as well.

 

I've back up my server using the config back up plug in, deleted those files and then restored the configuration.

So far things seem to be running w/o errors - so thank you for the tip!

 

Just curious, what's refreshinfo.db file for?   

New library.db was re-created, however I still don't see new refreshinfo.db.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...