+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Mac OS X (https://forum.kodi.tv/forumdisplay.php?fid=56)
+---- Thread: No TV shows and Movies in Library mode (/showthread.php?tid=127815)
No TV shows and Movies in Library mode - PR1MO - 2012-04-05
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)
RE: No TV shows and Movies in Library mode - jmarshall - 2012-04-05
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.
RE: No TV shows and Movies in Library mode - PR1MO - 2012-04-05
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.
RE: No TV shows and Movies in Library mode - jmarshall - 2012-04-05
Can't recall offhand what Dharma was, but you'll get a reasonable idea from the file date I think.