[Solved] SQL errors
Posted: 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.
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.