Bug occur on version 4.8.8

[davidhu1207 1]

Today I renamed a library in the media library, and then all the media library contents became empty so can not to play normally. I tried to reinstall OS and EMBY service but face the same issue.

and now I got a new problem that I can only create ONE library,  it will be empty again if I create secondary library. Does anyone know how to solve this problem? thanks in advanced !

[Happy2Play 9780]

What do you mean you renamed a library?

How many libraries do you have and what are their paths?

But sounds like you have overlapping library paths.

Please post the server log also.

[davidhu1207 1]

4 hours ago, Happy2Play said:

What do you mean you renamed a library?

How many libraries do you have and what are their paths?

But sounds like you have overlapping library paths.

Please post the server log also.

 

I mean the rename library please refer to the snapshot. Will got the error message and then all library will be can not play normally because show up is empty. However I have tried to remove all libraries and added again, but still face the issue that the first added library can be work, all other library are empty.

I have 8 libraries and still work well before I tried to rename one library. and now no more log can provide because I have reinstall OS and EMBY service. but the  issue that the first added library can be work, all other library are empty still again. 

[Happy2Play 9780]

Okay and the server log as the screenshot is not the complete error.

But without all the original libraries and log it will be impossible to say.

What where/are all library paths?  As they can not overlap each other.

Edited July 20, 2024 by Happy2Play

[davidhu1207 1]

When I add new library and then it show "No items found", rerfer 1.PNG and 2.PNG.

but actually the there have125 video files in that folder. and in the first library is work well refer to 3.PNG and 4.PNG

 

 

[Happy2Play 9780]

Yes per your image Music video library will kill all other libraries do to parent path /Emby.  No other library can ever be a child of any other library so /Emby/Movies will not work as /Emby is already a library.

You have to make music videos something like /Emby/Music Videos.

[davidhu1207 1]

8 minutes ago, Happy2Play said:

Okay and the server log as the screenshot is not the complete error.

But without all the original libraries and log it will be impossible to say.

What where/are all library paths?  As they can not overlap each other.

I have 7 libraries as below path.   I have delete all libraries and add only one to the /EMBY. it can see all contents now. but I want to create more libraries for echo sub-folder, but just first one library is work, I really don't know what the root issue.  do you know, I have use the 7 folders for 2 years and no any issue. this is my first face the problem at yesterday, and can not be to fixup include reinstall EMBY and reinstall OS and EMBY.

 /EMBY/1080P/
/EMBY/ documentary/
 /EMBY/Kids-cartoon/
 /EMBY/Kids-episodes/
 /EMBY/Movies/
 /EMBY/Movies-Episodes/
/EMBY/TEST/

[Happy2Play 9780]

You can not have a root folder library and a subfolder library as it creates SQLiteException: Constraint: FOREIGN KEY constraint failed issue in the database.

https://emby.media/community/index.php?/topic/128180-sqliteexception-constraint-foreign-key-constraint-failed

So all library path can not have any child libraries.

So you can not have a /EMBY library and all the others.  Delete that library /Emby and all the others will work.

[davidhu1207 1]

7 minutes ago, Happy2Play said:

Yes per your image Music video library will kill all other libraries do to parent path /Emby.  No other library can ever be a child of any other library so /Emby/Movies will not work as /Emby is already a library.

You have to make music videos something like /Emby/Music Videos.

it's only work first one library so I create /EMBY,  

Below is my libraries, but only one can work since pop the error message Exception of type 'SQLlitePCL.pretty.SQLiteException'....

/EMBY/1080P/
/EMBY/ documentary/
 /EMBY/Kids-cartoon/
 /EMBY/Kids-episodes/
 /EMBY/Movies/
 /EMBY/Movies-Episodes/
/EMBY/TEST/

 

[davidhu1207 1]

4 minutes ago, Happy2Play said:

You can not have a root folder library and a subfolder library as it creates SQLiteException: Constraint: FOREIGN KEY constraint failed issue in the database.

https://emby.media/community/index.php?/topic/128180-sqliteexception-constraint-foreign-key-constraint-failed

So all library path can not have any child libraries.

So you can not have a /EMBY library and all the others.  Delete that library /Emby and all the others will work.

it's no the issue, I have delete /EMBY library and keep another one and face the same issue.

 

[Happy2Play 9780]

You cannot have a /Emby library and creates any other library containing /Emby/xxxxxxxxxxxxxx as the path is already in the database and cannot be used again.

So if you want /Emby/1080p you have to remove /Emby library completely.  There is no way to have both.

So you most likely will have to remove all libraries and hope the db clears itself otherwise you will have to start over.

[Happy2Play 9780]

Ok if you delete all libraries and just add one we need to know if you are still getting db errrors in log if so you will have to most likely delete the library.db as it is broke.

But need server logs to verify.

Corrupt Database | Emby Documentation

[davidhu1207 1]

6 minutes ago, Happy2Play said:

Ok if you delete all libraries and just add one we need to know if you are still getting db errrors in log if so you will have to most likely delete the library.db as it is broke.

But need server logs to verify.

Corrupt Database | Emby Documentation

attached file is the log, thank you so much!

embyserver.txt

[davidhu1207 1]

11 minutes ago, Happy2Play said:

Ok if you delete all libraries and just add one we need to know if you are still getting db errrors in log if so you will have to most likely delete the library.db as it is broke.

But need server logs to verify.

Corrupt Database | Emby Documentation

 

this is first log from yesterday after reinstall OS and EMBY

embyserver-63857116800.txt

[Happy2Play 9780]

8 minutes ago, davidhu1207 said:

attached file is the log, thank you so much!

Don't appear to have a database issue but you are saying the /Emby/Movie library is showing no content. 

Do you have parental controls or access on the user?

Not sure if this path issue created issues but may need to toggle Access in User setup.  If you toggle uncheck hit save and checked and hit save does the content appear?

2 minutes ago, davidhu1207 said:

this is first log from yesterday after reinstall OS and EMBY

Yes this log shows the foreign key constraint issue but your other log does not.

[davidhu1207 1]

20 minutes ago, Happy2Play said:

You cannot have a /Emby library and creates any other library containing /Emby/xxxxxxxxxxxxxx as the path is already in the database and cannot be used again.

So if you want /Emby/1080p you have to remove /Emby library completely.  There is no way to have both.

So you most likely will have to remove all libraries and hope the db clears itself otherwise you will have to start over.

I'm now tired to reinstall from ubuntu to centos

[Happy2Play 9780]

1 minute ago, davidhu1207 said:

I'm now tired to reinstall from ubuntu to centos

You should not have any issues as long as you do not have parent and sub-folders libraries on a new install.

[davidhu1207 1]

13 minutes ago, Happy2Play said:

Don't appear to have a database issue but you are saying the /Emby/Movie library is showing no content. 

Do you have parental controls or access on the user?

Not sure if this path issue created issues but may need to toggle Access in User setup.  If you toggle uncheck hit save and checked and hit save does the content appear?

Yes this log shows the foreign key constraint issue but your other log does not.

foreign key constraint issue maybe is reinstall OS and EMBY, but client still remember older OS&EMBY setting

[davidhu1207 1]

update the EMBY version from 4.8.8 to 4.9 BETA, same issue.

[davidhu1207 1]

47 minutes ago, Happy2Play said:

You should not have any issues as long as you do not have parent and sub-folders libraries on a new install.

 

BIG ISSUE，I can't login to the web EMBY still show the ERROR MESSAGES 'SQLlitePCL.pretty.SQLiteException..' since update EMBY from 4.8.8 to 4.9.0.27 BETA

[Happy2Play 9780]

1 minute ago, davidhu1207 said:

 

BIG ISSUE，I can't login to the web EMBY still show the ERROR MESSAGES 'SQLlitePCL.pretty.SQLiteException..' since update EMBY from 4.8.8 to 4.9.0.27 BETA

Without logs it is impossible to say.

[Happy2Play 9780]

Why did you upgrade and not do a clean install?

[davidhu1207 1]

1 minute ago, Happy2Play said:

Without logs it is impossible to say.

I found the issue that / space full because I'm tried store part of the video files from /EMBY to /MEDIA folder, it's ok now after delete /MEDIA folder.

[Luke 42077]

Hi, are you saying you're all set now?

[davidhu1207 1]

2 minutes ago, Luke said:

Hi, are you saying you're all set now?

Yes, but still face the same issue.