[mythtv] [mythtv-commits] Ticket #1230: missing airdate for recordings in mythweb

[Robert Tsai]

On Mon, Feb 06, 2006 at 02:22:00PM -0000, MythTV wrote:
> #1230: missing airdate for recordings in mythweb
> ----------------------------------------+-----------------------------------
>  Reporter:  mythdev at penyball.cix.co.uk  |       Owner:  xris
>      Type:  enhancement                 |      Status:  new 
>  Priority:  minor                       |   Milestone:  0.19
> Component:  mythweb                     |     Version:  head
>  Severity:  low                         |  
> ----------------------------------------+-----------------------------------
>  My live systems have been running at 6910 since August 2005. I've just
>  updated to 8864.
>  All my recordings made under 6910 are shown in mythweb as recorded on
>  1/1/1970 :( New recordings and recordings prior to 6910 are ok.  (The
>  correct dates for all recordings are shown in mythtv screens - this only
>  affects mythweb)
> 
>  Tracking this down it would appear that 6910 was not setting
>  recorded.progstart/progend and presumably some time since then mythweb has
>  started using progstart/progend rather than starttime/endtime.
> 
>  In case this hits anyone else the fix is a simple sql update:
>  {{{
>   update recorded set progstart=starttime, progend=endtime
>   where progstart = '0000-00-00 00::00:00';
>  }}}

There was probably something fubar'ed in your upgrade. The upgrade
should have upgraded your DB schema in the way you describe above:

	    if (dbver == "1095")
	    {   
		const QString updates[] = {
	"ALTER TABLE recorded ADD COLUMN progstart DATETIME NOT NULL;",
	"UPDATE recorded SET progstart = starttime;",
	"ALTER TABLE recorded ADD COLUMN progend DATETIME NOT NULL;",
	"UPDATE recorded SET progend = endtime;",
	""
	};

I'd check your logs and look for the DB schema updates and see if
something went wrong there.

--Rob
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-dev/attachments/20060206/2e7ceb2a/attachment.pgp