[mythtv-users] Baseball Season

[Christian Hack]

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of 
> beckham44 beckham44
> Sent: Monday, 5 April 2004 3:52 PM
> To: mythtv-users at mythtv.org
> Subject: [mythtv-users] Baseball Season
> 
> Since the subtitle always shows the teams playing, I thought 
> I would do 
> something like this:
> 
> mysql> UPDATE program SET title="MLB Baseball (TEX)" WHERE title="MLB 
> Baseball" and subtitle LIKE "%Texas%";
> 
> This way I could create a recording to always record "MLB 
> Baseball (TEX)" on 
> any channel, or so I thought.  However, when I did this, all 
> of the start 
> times on the programs that were changed were set to the 
> current date and 
> time - so the game that is 9 days away now started 
> immediately and lasted 
> 209 hours.  Why was this?
> 

That's because the Time/Date fields used by MythTV are updated to the
current time whenever a row is modified and they aren't explicitly set.

See here (I think this is the right bit): 
http://www.mysql.com/doc/en/TIMESTAMP_pre-4.1.html

I don't quite understand why it's implemented like this in MySQL but
that's how it is.

CH