No TV shows and Movies in Library mode

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
PR1MO Offline
Junior Member
Posts: 2
Joined: Apr 2012
Reputation: 0
Post: #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)
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 26,221
Joined: Oct 2003
Reputation: 178
Post: #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]
find quote
PR1MO Offline
Junior Member
Posts: 2
Joined: Apr 2012
Reputation: 0
Post: #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.
find quote
jmarshall Offline
Team-XBMC Developer
Posts: 26,221
Joined: Oct 2003
Reputation: 178
Post: #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]
find quote