2011-02-10, 16:16
I whipped this up real quick to determine if the duration of the streamdetails is being populated in the database. This is where you'll need to check the duration - not in the movie / episode table.
Download XBMC SQL Test from here.
Instructions to use:
1. extract the zip file
2. drop a copy of your MyVideos34.db into the XBMC SQL Test folder
3. rename MyVideos34.db to MyVideos34.db3
4. run the executable.
This will populate the top gridview with a list of 100 episodes. This is the 'episode' table found in the database. Select a row and the bottom gridview will be populated with the 'streamdetails' table of the selected episode. Check the last column (iDuration) and it should have a number in it.
Download XBMC SQL Test from here.
Instructions to use:
1. extract the zip file
2. drop a copy of your MyVideos34.db into the XBMC SQL Test folder
3. rename MyVideos34.db to MyVideos34.db3
4. run the executable.
This will populate the top gridview with a list of 100 episodes. This is the 'episode' table found in the database. Select a row and the bottom gridview will be populated with the 'streamdetails' table of the selected episode. Check the last column (iDuration) and it should have a number in it.