[FEATURE REQUEST & ISSUE] Notifications/Calendar - Wrong aired date - Aired time implementation

[rampionx]

Hi ! First of all, thank you again for this beautiful software that I use daily from now on.

I would like to provide two points that are linked.

First the issue:

• Some aired dates are wrong and I don't know how to correct it. Example (I'm in France - GMT+1):
• Solo Leveling - Aired on Saturday / Announced on Sunday by RYOT.
• Mushoku Tensei - Aired on Sunday / Announced on Monday by RYOT.
• Blue exorcist - Aired on Saturday / Announced on Sunday by RYOT.

Impact: I receive notifications one day after the real release day on TV/streaming platforms. It's quite a loss.

Reason: I watch a lot more anime than TV shows. So I can't say if the problem is only on anime. However, in Sonarr and Trackt the dates are correct. After a quick search, it appears that TVDB, ANIDB, MAL and TMDB are all impacted.

Second point the feature request:

• Would it be possible to synchronize media broadcast times? Before switching to a self-hosted solution, I used TV Time and Trakt among others. Both sent me notifications when the episode aired. It's much more practical for tracking your series than a bunch of notifications for the day at a fixed time. Sonarr also shows the broadcast time in its calendar but can't send notifications. Perhaps the solution to the two points I mentioned would be to synchronize the metadata on Trakt.tv?

In any case, thank you in advance for your interest.

[IgnisDa]

I'm a bit tied up at the moment. If you're up for it, feel free to jump in and submit a PR – I'd really appreciate the help. If you're not sure where to start, I can give you some pointers.

Alternatively, if coding isn't your thing but you still want to support the project, a donation would be super helpful.

[IgnisDa]

@rampionx I think the problem here is that your database is in the wrong timezone. Can you try this? NOTE: You will have to dump your db, reset it and then restore it back again. Timezone changes are not applied to an already initialized database.

[rampionx]

Hi IgnisDa. I have tryed to change timezone. RYOT and PostgresSQL15 are both on my correct timezone (Europe/Paris). (I made a fresh install)

It's steal wrong aired date. In the example below, I get notified by RYOT, 27 hours before the episode is released (at midnight, the day before, so 27 hours before). The aired date still good on Trakt and Sonarr contrary to, RYOT, TVDB and TMDB.

Thank you for your help.

[IgnisDa]

@rampionx Is this a data discrepancy? As far as I can see, the release dates of shows seem to be different on TMDB than trakt. Can you check? https://www.themoviedb.org/tv/94997-house-of-the-dragon/season/2

[rampionx]

Hi IgnisDa, Yes. That's what I said before. As far as I can see TVDB, TMDB, AniDB and MAL use the same aired time. In my case, only Trackt and Sonarr have the good date/hours. It's probably a timezone problem but I don't know how to change it. As you can see in the example below, Sonarr and Trackt look like to use my TZ. TVDB and TMDB looks in a bad timezone. (IDK for TMDB and RYOT. IDK how to see the Aired hour)

TVDB:

TMDB:

RYOT:

Trackt:

Sonarr:

Estearn US vs Europe/Paris TZ:

[IgnisDa]

Ryot does not pull release dates from Trakt. As far as I know, Trakt uses TMDB API, so I wonder if they are maintaining release dates separately? Do you have any idea about this?