No TV shows and Movies in Library mode
#1
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)
Reply
#2
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.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
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.
Reply
#4
Can't recall offhand what Dharma was, but you'll get a reasonable idea from the file date I think.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply

Logout Mark Read Team Forum Stats Members Help
No TV shows and Movies in Library mode0