Page 1 of 1

[Solved] SQL errors

Posted: Sat Dec 19, 2020 5:42 pm
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.

Re: SQL errors

Posted: Tue Dec 22, 2020 9:26 am
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?

Re: SQL errors

Posted: Wed Jan 13, 2021 7:01 pm
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.

Re: [Solved] SQL errors

Posted: Thu Jan 14, 2021 8:22 am
by SubJunk
Thanks for confirming :)