[Solved] SQL errors
Forum rules
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
[Solved] SQL errors
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.
Re: SQL errors
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
Thank you. I deleted the database folder and that solved the problem.