View Full Version : The office (US) watched and unwatched episode issue (season 3)
I have a weird issue with season 3 of the office. XBMC says I have 35 files in this season but only shows and lists 23, when I look at my file structure I only have eps 1-23 and no other files in this file. I went to thetvdb.com and looked up the season and it only has 23 episodes. I've tried re adding the show/season and it still comes back with 35 episodes in the little watched unwaatched quick view it gives you. If I select the season and hit mark all as watched it will change the 23 to watched but still say i have 12 unwatched episodes, and there are no unwatched eps when i go into the season. How do I fix this?
I am not having this problem with any other show/season
thanks in advance
Have you tried removing the Series from the database, closing XBMC, relaunching it and make it scrap the data from scratch?
Have you tried removing the Series from the database, closing XBMC, relaunching it and make it scrap the data from scratch?
I'll try this AGAIN when i get home from work, but what I did before was select remove from library (which should remove it from the DB) and then click update library which is the same function that is run when you boot up xbmc so I believe this will have the same effect
jmarshall
2009-01-16, 21:56
If you can get it reproducible, please post on trac and attach your database file so that developers can reproduce.
Thanks,
Jonathan
If you can get it reproducible, please post on trac and attach your database file so that developers can reproduce.
Thanks,
Jonathan
Remove and restart didn't do anything....
Can someone tell me where to grab the DB from? also where am i suppose to put it?
edit: i think i found it but i dont see anyway to upload it to the thread
You may want to make sure there's not any additional digits in the filename, sometimes that causes it to think it's a mutli-part episode.
If you pm me the names of the episodes (a directory list from the command line is fine) I can isolate the issue as I've got a similar problem I am working on in MIP right now.
Database locations (in windows)
C:\Documents and Settings\<USERNAME>\Application Data\XBMC\userdata\Database\MyVideos34.db
or
C:\Program Files\XBMC\userdata\Database\MyVideos34.db
or
<install directory>\userdata\Database\MyVideos34.db
You may want to make sure there's not any additional digits in the filename, sometimes that causes it to think it's a mutli-part episode.
If you pm me the names of the episodes (a directory list from the command line is fine) I can isolate the issue as I've got a similar problem I am working on in MIP right now.
Database locations (in windows)
C:\Documents and Settings\<USERNAME>\Application Data\XBMC\userdata\Database\MyVideos34.db
or
C:\Program Files\XBMC\userdata\Database\MyVideos34.db
or
<install directory>\userdata\Database\MyVideos34.db
you sir are a genious. I wouldve of never thought this was the issue. Bascially my office files were misnamed and the double episodes were named like 1-2. tvdb.com uses just single episodes names (as it should for these) so i just addes a SXXEXX tag on the front of each file without changing the rest. This caused some **** up in the db and caused my problem which is now fixed because i removed all the numbers out of the file name besides the tag i want tvdb.com to use. thanks!