MP database question... need answers. (1 Viewer)

[vvulture]

Hi guys...

I recently needed to have a look at my "Schedule" table in my database using management studio, and i noticed that some of my schedules were dated as far back as 2008.
These shows have a "type 3" allocated to them ( record everytime ).

How is it that the shows still manage to record even tho they are dated so far back ? Is this normal behaviour ?
I thought the date is suppose to change everytime the show is to be recorded .

Thank you

 

[Paranoid Delusion]

Not sure this totally applies to you, but one of the fixes in RC1 is the correct deletion of old scheduled recordings (series) in the db, just out of interest is your db pretty big in size.

 

[vvulture]

Not sure this totally applies to you, but one of the fixes in RC1 is the correct deletion of old scheduled recordings (series) in the db, just out of interest is your db pretty big in size.

Thanx for the heads up paranoid.... I'm still using 1.1.0 Alpha so who knows....

Here is my dilemma..
Schedules in database have a type of "3" which means they record everytime.
However, the start time and date as well as finish time and date are in the past as far back as 2008. The shows record no problem, but i am stumped at how it works.

My reasons for wanting to know this are as follows... i am using a VBScript that checks the database for the next scheduled recording and sets up my server to wake up in time for it to record.
Problem is, if the schedule is before the "current" date and time, the script treats the schedule as "being in the past" and ignores it, when in reality it is scheduled to "record everytime on this channel".

This is all related to this other thread: https://forum.team-mediaportal.com/...ollection-fixes-workarounds-69731/index5.html
specifically on pages 3 to 5.

I know WHS is not supported, but please indulge me... this is not a WHS specific issue...
Cheers

 

[vvulture]

Any devs out there care to comment ?

 

[tourettes]

Any devs out there care to comment ?

Haven't ever looked at the scheduling code, but I would assume that record every time type schedules don't check the dates. Why would they? They are only interested in the show itself. If I remember correctly there will be a new "record once" schedule spawned when server sees that it needs to record such show.

 

[vvulture]

Any devs out there care to comment ?

Haven't ever looked at the scheduling code, but I would assume that record every time type schedules don't check the dates. Why would they? They are only interested in the show itself. If I remember correctly there will be a new "record once" schedule spawned when server sees that it needs to record such show.

Thanks for the reply tourettes...
Actually, from the observations i have made, there are no new "spawned" schedules created... that is why i am stumped.
For example, i record the news on channel 9 at the same time every night, but the schedule in the database is dated early 2008, which is when the original schedule was created.
Since then, the date and time has not changed but it keeps recording.. Where is it scheduled ?? MP needs to know the time and date of the show somehow..
My guess is that it checks the "program" table in the database which has the TV guide stored in it...

cheers