2010-08-22, 17:02
I can't seem to clean the library from missing files.
This is the part in de debug log what's wrong. I checked the database and tvshow table is intact and has no 'strange' data.
I'm using build 33035. Anybody got the same problem or ideas how to fix this?
Code:
16:33:39 T:3644 M:1389805568 DEBUG: Cleaning paths that don't exist and don't have content set...
16:33:39 T:3644 M:1389805568 DEBUG: CVideoDatabase::CleanDatabase Cleaning tvshow table
16:33:39 T:3644 M:1389735936 ERROR: SQL: SQL error or missing database
Query: DELETE tvshow.* FROM tvshow JOIN tvshowlinkpath ON tvshow.idShow=tvshowlinkpath.idShow JOIN path ON path.idPath=tvshowlinkpath.idPath WHERE tvshow.idShow NOT IN ( SELECT idShow from tvshowlinkepisode ) AND path.strContent=''
16:33:39 T:3644 M:1389723648 ERROR: CVideoDatabase::CleanDatabase failed
I'm using build 33035. Anybody got the same problem or ideas how to fix this?