Thread Rating:
  • 0 Vote(s) - 0 Average
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: badge.gif]
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: badge.gif]
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average



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