[BUG] Photos > SQLITE3:0x80000001, 28, double-quoted string literal: "2021-05-17 19:36:06"

Plex Media Server NAS & Devices
21

I rolled back to 1.22.3.4523 and the problem is not present in the old server build. I don’t have the patience to roll through all the updates in the middle to nail down the update when the bug was introduced but that at least gives you a starting point :slight_smile:

1 Like
22

It is not fixed. I keep getting this error, even when opening the home menu that does not have any photos pinned. It makes it load very slow and consume 100% of my cpu for 15 to 20 seconds.

23

Yep, still broken.

24

I am also seeing this error but not for pictures ( don’t have any loaded ) just a few TV and Movies

25

After looking at the logs, and some googling, I found that this is caused by some library called libva and the lack of support for NVIDIA hardware acceleration.

Turning off hardware acceleration fixed these issues for me. Hoping a future patch will fix this and allow me to re-enable hardware encoding.

@ChuckPa

26

If I may clarify ?

  1. libva is the framework API.
  2. If you add the QSV libraries, you get support for Intel Quick Sync Video – Which Plex as done and ships with PMS.
  3. If you add the Nvidia drivers, you get Nvidia support although the native Nvidia API is better. Plex uses the Nvidia-native API
  4. if you add the AMD drivers, even though not officially supported by Plex, you can get Plex to use AMD GPU cards. (you have to be 100% correct in how you do it).

If you will show me the logs of the failure, I might have the fix for it now.
I know what happened.

I’m also willing to bet that if you went back to 1.22.3 and enabled HW transcoding, it would work flawlessly. - which is a very quick way to confirm.

Would you like the solution now?

Additionally – SQLITE quoted string errors have nothing to do with Hardware Transcoding.

27

Updated to version 1.23.3.4692 yesterday and am no longer seeing this issue. I haven’t tested extensivily, but all indications is that my problem displaying some images appears to have been resolved.

28

I have something like this:
Time

Level
Error

Thread

Message
SQLITE3: 0x80000001, 28, double-quoted string literal: “2021-06-18 10:30:00”

Plex in Docker. Can it be fixed somehow?

29

What exactly is broken?

30

I changed the docker and now this message will not appear when starting the movie.

31

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.