[Solved] SQL errors

For help and support with Mac OS X-specific issues
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 » Sat Dec 19, 2020 5:42 pm

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: 3281
Joined: Sun May 27, 2012 4:12 pm

Re: SQL errors

Post by SubJunk » 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?

madman555
Posts: 13
Joined: Mon Sep 24, 2018 5:18 am

Re: SQL errors

Post by madman555 » Wed Jan 13, 2021 7:01 pm

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: 3281
Joined: Sun May 27, 2012 4:12 pm

Re: [Solved] SQL errors

Post by SubJunk » Thu Jan 14, 2021 8:22 am

Thanks for confirming :)

Post Reply