DUPLICATE EPISODE OF SHOW

[geordon49]

STANDALONE V202306010714 Windows 11 Show . - BEYOND SKINWALKER RANCH S01E05 06 07 ARE ALL LISTED TWICE therefore download twice. .

[garfield69]

Please upload C:\Users\\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.

[geordon49]

On my new WINDOWS 11 PC I do not see the folder APPDATA under C:\users\my_user_name\

On Sun, Jul 9, 2023 at 1:00 PM garfield69 @.***> wrote:

Please upload C:\Users\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.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627773138, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY4H2Z7F4XUUTQ7CLBTXPLPR5ANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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.

[geordon49]

I'm sorry but I am completely lost trying to locate DUCKIETV-STANDALONE

On Sun, Jul 9, 2023 at 1:00 PM garfield69 @.***> wrote:

Please upload C:\Users\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.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627773138, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY4H2Z7F4XUUTQ7CLBTXPLPR5ANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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

[geordon49]

The files/folders showing are [image: image.png]

On Sun, Jul 9, 2023 at 1:55 PM garfield69 @.***> wrote:

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

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627784203, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY6E4C25XG5Q7DCMOV3XPLWA3ANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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.

[geordon49]

I dont know where to paste my screen capture

On Sun, Jul 9, 2023 at 2:25 PM garfield69 @.***> wrote:

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.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627789654, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY6CV2COU7V72DQUCXLXPLZQNANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

use you browser to access https://github.com/SchizoDuckie/DuckieTV/issues/1393 and paste in the open box at the bottom of the ticket.

[geordon49]

Entered GITHUB but says NO TICKETS

On Sun, Jul 9, 2023 at 2:42 PM garfield69 @.***> wrote:

use you browser to access #1393 https://github.com/SchizoDuckie/DuckieTV/issues/1393 and paste in the open box at the bottom of the ticket.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627792976, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTYZXCPCCNJZRDUMHJZTXPL3RDANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

huh? have you never used github before?

[geordon49]

YES I have several times

On Sun, Jul 9, 2023 at 2:52 PM garfield69 @.***> wrote:

huh? have you never used github before?

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627795228, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY24CNHJNO6RAIYSWM3XPL4W3ANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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.

[geordon49]

[garfield69]

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 ?

[garfield69]

ok a different approach. when I go to the skinwalker series episodes I see: what do you see?

[geordon49]

The screenshot is from - C:\USERS\geord I have NO IDEA how WINDOWS 11 came up with geord but somehow it did.

On Sun, Jul 9, 2023 at 3:18 PM garfield69 @.***> wrote:

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 [image: image] https://user-images.githubusercontent.com/6933240/252164502-efc9cc4d-960d-4591-9d12-0c5f48690d6c.png so that in the search box near the upper right you can look for DuckieTV-Standalone ?

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627802002, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY2LCBIMRRNA5WQDGX3XPL7W7ANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[geordon49]

The duplication is happening with the newer series called BEYOND SKINWALKER RANCH

On Sun, Jul 9, 2023 at 3:26 PM garfield69 @.***> wrote:

ok a different approach. when I go to the skinwalker series episodes I see: [image: image] https://user-images.githubusercontent.com/6933240/252164856-d00f4a41-f54d-4e53-bce9-a3ef0a3dd567.png what do you see?

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627803700, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY3G6PXAJ3WQVTEAFHTXPMAVZANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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

[geordon49]

I have great difficulty taking screenshot but on the screen is the month of July 9th-15th and under the 11th I have THE AFTERPARTY S02E03,THE SECRET OF SKINWALKER RANCH S01E06,BEYOND SKINWALKER RANCH S01E05. BEYOND SKINWALKER RANCH S01E05.HIJACK S01E05, BSR is on screen twice

On Sun, Jul 9, 2023 at 3:37 PM garfield69 @.***> wrote:

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

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627805837, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY3G6DUNGVKME7HBRZTXPMB53ANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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

[geordon49]

YES

On Sun, Jul 9, 2023 at 3:48 PM garfield69 @.***> wrote:

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

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627808063, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTYY4CIATDQV66BHPHP3XPMDKFANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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?

[geordon49]

How can I find href

On Sun, Jul 9, 2023 at 3:56 PM garfield69 @.***> wrote:

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

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627809707, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTYYX36NGI4RZHKREB33XPMEIBANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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

[geordon49]

First href is 18377 Next href is 18381

On Sun, Jul 9, 2023 at 4:17 PM garfield69 @.***> wrote:

go to the series episodes list and hover your mouse over s01e05 and right click [image: image] https://user-images.githubusercontent.com/6933240/252166971-b90014b2-e2ce-4aee-80ce-e97a88f7d17b.png then select inspect from the menu this takes you to the development page Elements view the href=" should show like this [image: image] https://user-images.githubusercontent.com/6933240/252167045-e0bb20c0-2aaf-4103-bd3e-f5e309a0d184.png

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627815295, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY37EBTXH664CC6IAGTXPMGWJANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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?

[garfield69]

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.

[geordon49]

I just closed DUCKIETV and then entered DUCKIETV and there are double entries on the 11th EP 05,8th EP 06, and 25th EP 07 for BEYOND OAK ISLAND

On Sun, Jul 9, 2023 at 5:25 PM garfield69 @.***> wrote:

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.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627829448, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY3DS7NLKKQJP4WC2QLXPMOUDANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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.

[geordon49]

BEYOND OAK ISLAND S03E12 HREF IS13069 S03E11 HREF IS13068

On Sun, Jul 9, 2023 at 9:12 PM garfield69 @.***> wrote:

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 descrived to get the href and then the traktids.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1627904686, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTYZTTC64DJQC3AU46RLXPNJGBANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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.

[geordon49]

ID_Episode = 18377 and 18381 says promise (pending)

On Mon, Jul 10, 2023 at 2:39 PM garfield69 @.***> wrote:

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.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1629498464, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY34OGVDYFVJHSULTRLXPRD4PANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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

[geordon49]

I get for EP ID 18777 - TRAKTID 10731734 I get for EP ID 18381 -TRAKTID 10731734

EXACT SAME My system does updates auto and as of this moment the duplicate records are still there

On Mon, Jul 10, 2023 at 2:39 PM garfield69 @.***> wrote:

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.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1629498464, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY34OGVDYFVJHSULTRLXPRD4PANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don

[garfield69]

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.

[geordon49]

That worked for the episode 5 of BEYOND SKINWALKER RANCH but I did not do the others.

On Mon, Jul 10, 2023 at 9:38 PM garfield69 @.***> wrote:

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 [image: image] https://user-images.githubusercontent.com/6933240/252526774-3eb3e81c-63c6-4dba-b1bd-4407ecd96e48.png
• 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.

— Reply to this email directly, view it on GitHub https://github.com/SchizoDuckie/DuckieTV/issues/1393#issuecomment-1629971393, or unsubscribe https://github.com/notifications/unsubscribe-auth/AD6PTY72F2IZHWQPOY4DINTXPSU73ANCNFSM6AAAAAA2DPB77M . You are receiving this because you authored the thread.Message ID: @.***>

-- Don