Database errors

Server Version#: 1.13.9.5439

Getting database errors in the console:

Oct 16, 2018 14:32:10.548 [4024] Error — SQLITE3:0x1b34ca24, 1, near ",": syntax error
Oct 16, 2018 14:32:10.548 [4024] Error — Soci Exception handled: sqlite3_statement_backend::prepare: near ",": syntax error for SQL: select upper(substr((select, 1, 1)) as c,count(distinct metadata_items.id) from metadata_items  left join metadata_item_settings on metadata_item_settings.guid=metadata_items.guid and metadata_item_settings.account_id= 1 where metadata_items.library_section_id=?  and metadata_items.library_section_id in (1) and metadata_items.metadata_type=2  group by c order by c

I tried rebuilding the database, but this didn’t fix it - I’m still getting these errors. I get this error when listing my TV Shows library. I’m not noticing any performance issues.

Thanks for reporting the issue. If you care to ensure debug logging is enabled and provide full logs zip then it can be referred to the development team

https://support.plex.tv/articles/201643703-reporting-issues-with-plex-media-server/
https://support.plex.tv/articles/200250417-plex-media-server-log-files/

Suggest you restart the server after ensuring debug logging is enabled and then download the logs zip when the db error occurs

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