[Solved] SQL errors

For help and support with Universal Media Server
Forum rules
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
Post Reply
madman555
Posts: 13
Joined: Mon Sep 24, 2018 5:18 am

[Solved] SQL errors

Post by madman555 »

Hi, I'm seeing a lot of this in the logs:

21:34:55 ERROR Database error while looking up file bookmark in FILES_STATUS for "/Volumes/DiskStation 916/videos/-- baby --/Sesame Street - Fun Fun Elmo": Column "BOOKMARK" not found; SQL statement:
SELECT BOOKMARK FROM FILES_STATUS WHERE FILENAME = '/Volumes/DiskStation 916/videos/-- baby --/Sesame Street - Fun Fun Elmo' LIMIT 1 [42122-199]
21:34:55 DEBUG Setting bookmark for /Volumes/DiskStation 916/videos/-- baby --/Sesame Street - Fun Fun Elmo => 0
21:34:55 ERROR Database error while looking up file bookmark in FILES_STATUS for "/Volumes/DiskStation 916/videos/-- baby --/Bin Bin.mp4": Column "BOOKMARK" not found; SQL statement:
SELECT BOOKMARK FROM FILES_STATUS WHERE FILENAME = '/Volumes/DiskStation 916/videos/-- baby --/Bin Bin.mp4' LIMIT 1 [42122-199]
21:34:55 DEBUG Setting bookmark for /Volumes/DiskStation 916/videos/-- baby --/Bin Bin.mp4 => 0
21:34:55 ERROR Database error while looking up file bookmark in FILES_STATUS for "/Volumes/DiskStation 916/videos/-- baby --/Bin Bin DVD Movie.m4v": Column "BOOKMARK" not found; SQL statement:
SELECT BOOKMARK FROM FILES_STATUS WHERE FILENAME = '/Volumes/DiskStation 916/videos/-- baby --/Bin Bin DVD Movie.m4v' LIMIT 1 [42122-199]
21:34:55 DEBUG Setting bookmark for /Volumes/DiskStation 916/videos/-- baby --/Bin Bin DVD Movie.m4v => 0
21:34:55 ERROR Database error while looking up file bookmark in FILES_STATUS for "/Volumes/DiskStation 916/videos/-- baby --/Frozen - Dual + Subs.m4v": Column "BOOKMARK" not found; SQL statement:
SELECT BOOKMARK FROM FILES_STATUS WHERE FILENAME = '/Volumes/DiskStation 916/videos/-- baby --/Frozen - Dual + Subs.m4v' LIMIT 1 [42122-199]

Videos still play, but it seems like it takes a while to show the list of videos.
User avatar
SubJunk
Lead Developer
Posts: 3705
Joined: Sun May 27, 2012 4:12 pm

Re: SQL errors

Post by SubJunk »

Sorry but it looks like your database failed to update at some point. I just tested on my machine and the upgrade succeeded. Can you try doing a clean install or removing your database folder?
madman555
Posts: 13
Joined: Mon Sep 24, 2018 5:18 am

Re: SQL errors

Post by madman555 »

SubJunk wrote: Tue Dec 22, 2020 9:26 am Sorry but it looks like your database failed to update at some point. I just tested on my machine and the upgrade succeeded. Can you try doing a clean install or removing your database folder?
Thank you. I deleted the database folder and that solved the problem.
User avatar
SubJunk
Lead Developer
Posts: 3705
Joined: Sun May 27, 2012 4:12 pm

Re: [Solved] SQL errors

Post by SubJunk »

Thanks for confirming :)
Post Reply