DUPLICATE EPISODE OF SHOW about duckietv HOT 37 CLOSED

Please upload C:\Users<your_user_name>\AppData\Local\DuckieTV-Standalone\User Data\Default\databases\chrome-extension_bagblfnohpiddokbpaacecffdboomafe_0\1 to a cloudshare site such as Dropbox or OneDrive and provide a share link so that I can examine the database to see if I can figure out what is going on.

from duckietv.

from duckietv.

Oh. I'm a win10 user so that is where my example came from.
try looking into any of the folders that would be where appdata is on the path, and see if you can find local.
let me know what the replacement for appdata is so I can update the wiki.

from duckietv.

from duckietv.

Try using your explorer search. open your file explorer at C:\users and use the search to look for DuckieTV-Standalone

from duckietv.

from duckietv.

you cant post image via email, they show up as The files/folders showing are [image: image.png]
use browser to access github and paste image directly in the box.

from duckietv.

from duckietv.

use you browser to access #1393 and paste in the open box at the bottom of the ticket.

from duckietv.

from duckietv.

huh? have you never used github before?

from duckietv.

from duckietv.

so if you are logged into github, access the issue you have raised, scroll to the bottom and paste your image into the open box at the bottom.

from duckietv.

from duckietv.

I've no idea what your screen shot is from.
when you open your file explorer and access C:\users\my_user_name\ do you not get something like

so that in the search box near the upper right you can look for DuckieTV-Standalone ?

from duckietv.

ok a different approach.
when I go to the skinwalker series episodes I see:

what do you see?

from duckietv.

from duckietv.

from duckietv.

show me a screenshot of the duplication you are referring to.

from duckietv.

from duckietv.

and if you look at the series episode list, do you see ep 5 twice there too ?

from duckietv.

from duckietv.

Strange.
from the episodes list, hover your mouse over the first s01e05 and right click and select inspect.
take a note of the episode number, for example 36588 at the end of the href.
then do the same for the duplicate. is it the same number?

from duckietv.

from duckietv.

go to the series episodes list and hover your mouse over s01e05 and right click

then select inspect from the menu
this takes you to the development page Elements view
the href=" should show like this

from duckietv.

from duckietv.

ok.
now, open the development tools page again (F12) and click on the console tab and scroll down to the command line.
at the > prompt paste the following and press enter.
CRUD.executeQuery('select TRAKT_ID from Episodes where ID_Episode = 18377').then(function(element) { console.log(element.rows[0]); })
then do the same for
CRUD.executeQuery('select TRAKT_ID from Episodes where ID_Episode = 18381').then(function(element) { console.log(element.rows[0]); })
are the traktid the same?

from duckietv.

I've got to go now, resume this later.
ITs is likely that your DTV fetched an update just in the middle of someone updating the trakttv database by adding new episodes without deleting the old ones first, assuming that you found different traktid numbers between the same episodes.
So if that is the case something you can try now is to go to the series details page and press the Refresh button, which should fetch the latest data for the series and delete any out of date episodes with old traktid that do not exist anymore.
let me know if that helps.

from duckietv.

from duckietv.

Provide the information I asked earlier about the traktids for beyond skinwalker ranch, and perform the same exercise for beyond oak island too, using the method I described to get the href and then the traktids.

from duckietv.

from duckietv.

Please open the development tools page again using the F12 and click on the console tab and scroll down to the command line.
at the > prompt paste the following and press enter.
CRUD.executeQuery('select TRAKT_ID from Episodes where ID_Episode = 18377').then(function(element) { console.log(element.rows[0]); })
then do the same for
CRUD.executeQuery('select TRAKT_ID from Episodes where ID_Episode = 18381').then(function(element) { console.log(element.rows[0]); })
Report back the results from these commands. Thanks.

from duckietv.

from duckietv.

;-)
yes, but under that will be something like {TRAKT_ID: 10731736}
what do you get?

from duckietv.

from duckietv.

Interesting.
ok, let try manually removing one of the duplicates and see if it stays gone.

• so at the console > prompt do the following command

CRUD.executeQuery('delete from Episodes where ID_Episode = 18381').then(function(element) { if (element.rowsAffected == 0) console.log('not found'); else console.log('deleted')})

if it works you will see deleted
and if you try it again or get the number wrong you will see not found

• then at the series details page click the refresh button
  
• the go to the series season episode list and check you do not have a duplicate episode
• if all good, find the ids for the other two episodes, and delete those duplicates too.

let me know how you go.

from duckietv.

from duckietv.