Kodi Community Forum

Full Version: No TV shows and Movies in Library mode
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, I booted up XBMC today and when I go to TV Shows or Movies, it is just showing up blank. I found this in the error log:

14:24:42 T:61256704 ERROR: SQL: The database disk image is malformed
Query: select * from episodeview order by idEpisode desc limit 10
14:24:42 T:61256704 ERROR: GetEpisodesByWhere failed
14:24:43 T:61256704 ERROR: SQL: The database disk image is malformed
Query: SELECT count(1) FROM tvshowview LIMIT 1
14:24:43 T:61256704 ERROR: GetSingleValue - failed to get value 'count(1)' from table 'tvshowview'
14:24:43 T:61256704 ERROR: SQL: The database disk image is malformed
Query: SELECT sum(watchedcount) FROM tvshowview LIMIT 1
14:24:43 T:61256704 ERROR: GetSingleValue - failed to get value 'sum(watchedcount)' from table 'tvshowview'
14:24:43 T:61256704 ERROR: SQL: The database disk image is malformed
Query: SELECT sum(totalcount) FROM tvshowview LIMIT 1
14:24:43 T:61256704 ERROR: GetSingleValue - failed to get value 'sum(totalcount)' from table 'tvshowview'
14:24:43 T:61256704 ERROR: SQL: The database disk image is malformed
Query: SELECT sum(watchedcount = totalcount) FROM tvshowview LIMIT 1
14:24:43 T:61256704 ERROR: GetSingleValue - failed to get value 'sum(watchedcount = totalcount)' from table 'tvshowview'

Anyone have any solutions to this? (While I cross my fingers that I don't have to rebuild the library)
You're gonna have to, yes. That's a corrupt video database - there's nothing to be done but delete. MyVideos60.db is the Eden version.

Depending on when you last updated XBMC, there will be an older version of your db there - if so, leave it in place and you may not have to do quite so much work to rescan.
My last update before the official Eden release was RC2, and the the 3 betas before that. I have MyVideos50.db which I guess is the Dharma version? Thanks for your help.
Can't recall offhand what Dharma was, but you'll get a reasonable idea from the file date I think.