manual reset playout broken again | ErsatzTV | Page 1

ripe nest Jun 12, 2023, 4:07 AM

#

manual reset playout is broken again in ErsatzTV Version
v0.7.8-147ab614-win-x64

#

its broken in this one too ErsatzTV Version
v0.7.8-c5692ef5-win-x64

#

manual reset playout broken

#

manual reset playout broken again

ripe nest Jun 12, 2023, 5:18 AM

#

Are the updates breaking it? or is it happening when I use your sqlite command to change all my streaming modes from mpegts?

ripe nest Jun 13, 2023, 2:51 AM

#

if its me that broke it, is there a tool for fixing the database?

alpine nebula Jun 13, 2023, 2:55 AM

#

dm me your db again, i'll take a look

ripe nest Jun 13, 2023, 3:13 AM

#

ok

#

ist uploading to mediafire

#

pm sent

alpine nebula Jun 13, 2023, 2:09 PM

#

database works fine here (playouts reset properly), but obv i'm not connected to your emby server, so the issue may be with/exacerbated by that, if you still have debug logs enabled can you send me your logs from yesterday and today?

#

context for anyone else reading: there are 436 channels and playouts in the db

ripe nest Jun 13, 2023, 3:42 PM

#

📎 logs.rar

alpine nebula Jun 13, 2023, 3:46 PM

#

alright, yeah. it's the number of channels that have subtitles enabled. the hourly work is taking more than an hour which never leaves room for you to queue a manual playout reset.

#

ill look at how etv checks for subtitles on upcoming playout items, maybe there's a potential optimization there, but disabling subtitles unless you really need it would fix your issue

#

the problem with subtitles is that many need to be extracted to a separate file for ffmpeg to burn it in, which would obviously take forever with the whole library, so etv does it "on-demand" every hour for what's being played that hour

ripe nest Jun 13, 2023, 3:48 PM

#

oh ok. theres 2 spots to disable subtitles? this will take me a really long to to figure out which schedules and channels have subtitles enabled. is there a sqlite command i can run to disable them on all channels at once?

alpine nebula Jun 13, 2023, 3:49 PM

#

sqlite3 ersatztv.sqlite3 'update channel set SubtitleMode = 0';

ripe nest Jun 13, 2023, 4:02 PM

#

i got ana error from that command about the update so replaced quotes with double quotes sqlite3 ersatztv.sqlite3 "update channel set SubtitleMode = 0";

#

wats good is now my new dads other war channels playouts have populated but the reset playouts button is still not randomizing the playout.

#

📎 ersatztv20230613.log

#

i see its still looking for subtitles though

alpine nebula Jun 13, 2023, 4:04 PM

#

you should restart etv

ripe nest Jun 13, 2023, 4:05 PM

#

i had killed etv to run the sql command and started up etv. you mean i should restart it again?

alpine nebula Jun 13, 2023, 4:05 PM

#

ok, one more command

#

sqlite3 ersatztv.sqlite3 "update playoutitem set subtitlemode = null";

ripe nest Jun 13, 2023, 4:10 PM

#

📎 ersatztv20230613.log

#

its still not resetting the playout

#

and its looking for subtitles to extract it looks like in the logs again

alpine nebula Jun 13, 2023, 4:12 PM

#

it always says that, but now it finds nothing so that takes less than a second rather than over an hour

ripe nest Jun 13, 2023, 4:12 PM

#

oh

alpine nebula Jun 13, 2023, 4:12 PM

#

also, the ui doesnt work like it did before, the playouts are being reset fine but it happens in the background and it doesn't auto refresh the table

#

2023-06-13 12:10:06.488 -04:00 [DBG] Building playout from "2023-06-13T12:10:06.4881540-04:00" to "2023-06-14T00:00:00.0000000-04:00"
2023-06-13 12:10:06.488 -04:00 [DBG] Building final playout from "2023-06-14T01:24:09.9364340-04:00" to "2023-06-14T12:10:06.4881540-04:00"
2023-06-13 12:10:06.493 -04:00 [DBG] Built playout 438
2023-06-13 12:10:06.608 -04:00 [DBG] Resetting playout 438 for channel 512 - Dad's other War Channel 6
2023-06-13 12:10:06.608 -04:00 [DBG] Building playout from "2023-06-13T12:10:06.6082963-04:00" to "2023-06-14T00:00:00.0000000-04:00"
2023-06-13 12:10:06.608 -04:00 [DBG] Building final playout from "2023-06-14T01:38:37.0949990-04:00" to "2023-06-14T12:10:06.6082963-04:00"
2023-06-13 12:10:06.613 -04:00 [DBG] Built playout 438
2023-06-13 12:10:06.733 -04:00 [DBG] Resetting playout 438 for channel 512 - Dad's other War Channel 6
2023-06-13 12:10:06.733 -04:00 [DBG] Building playout from "2023-06-13T12:10:06.7331487-04:00" to "2023-06-14T00:00:00.0000000-04:00"
2023-06-13 12:10:06.733 -04:00 [DBG] Building final playout from "2023-06-14T00:33:55.8009990-04:00" to "2023-06-14T12:10:06.7331487-04:00"
2023-06-13 12:10:06.738 -04:00 [DBG] Built playout 438
2023-06-13 12:10:06.859 -04:00 [DBG] Resetting playout 438 for channel 512 - Dad's other War Channel 6
2023-06-13 12:10:06.859 -04:00 [DBG] Building playout from "2023-06-13T12:10:06.8594648-04:00" to "2023-06-14T00:00:00.0000000-04:00"
2023-06-13 12:10:06.859 -04:00 [DBG] Building final playout from "2023-06-14T01:40:19.4019800-04:00" to "2023-06-14T12:10:06.8594648-04:00"
2023-06-13 12:10:06.866 -04:00 [DBG] Built playout 438

#

you have to click around. ill see if i can update it to auto refresh, but disabling the subtitles fixed it for you

ripe nest Jun 13, 2023, 4:13 PM

#

ok sweet. thanks ill wait for your uptdate for auto refresh

alpine nebula Jun 13, 2023, 6:23 PM

#

you're right there is a bug with etv checking for subtitles when the channel has them disabled. will fix that too

#

also updating the playout page to disable buttons/show spinning indicator when a playout is being built or subtitles are being extracted

#

new build should be ready shortly

alpine nebula Jun 13, 2023, 7:14 PM

#

https://github.com/jasongdove/ErsatzTV/releases/tag/develop

#

let me know if that helps

#

it should auto refresh that playout details table after the reset is complete

ripe nest Jun 14, 2023, 8:35 PM

#

oh swweet. ok ill try it

#

theres a couple things i dont undertand. did you disable the randomize/rest playout button? thats just while the playout is building? but i dont see any spinning indicator showing the playout is building. and i cant click the reset playout button

#

im on ErsatzTV Version
v0.7.9-a2acfe4d-win-x64

alpine nebula Jun 14, 2023, 8:45 PM

#

it should only be disabled with the spinning indicator, unless you didnt get the latest develop release

#

try a different browser maybe? it's literally the same logic, it cannot be disabled without the spinning indicator

ripe nest Jun 14, 2023, 8:47 PM

#

oh its randomizing now

#

maybe i needed to refresh the page

ripe nest Jun 19, 2023, 7:07 AM

#

in ErsatzTV Version v0.7.9-c148f2eb-win-x64 its looking for subtitles again

#

📎 ersatztv20230619.log

#

so the playouts wont build

alpine nebula Jun 19, 2023, 10:11 AM

#

you need to make sure subtitles are turned off on all channels and all schedule items

ripe nest Jun 19, 2023, 10:03 PM

#

alpine nebula `sqlite3 ersatztv.sqlite3 'update channel set SubtitleMode = 0';`

i thought i did that with your sql commands here

#

i dont know why i had to do it again after i updated

#

because after i updated i noticed the adventure time channel had the spinning icon which was causing the rest of my playout to be empyt. so i stopped etv and started it up again and it was still spinning. then i stopped it again and overwrote all the files with the same update to get the spinning to stop. then i did the sql commands again. thats when my playouts populated. but now i cant reset any playouts, probably because its still looking for subtitles

#

📎 ersatztv20230619.log 📎 ersatztv20230618.log

ripe nest Jun 20, 2023, 3:05 AM

#

I even refreshed the page

#manual reset playout broken again