[mythtv] [mythtv-commits] mythtv commit: r10392 - in trunk/mythtv by danielk

Daniel Kristjansson danielk at cuymedia.net
Wed Jul 5 03:51:07 UTC 2006


On Tue, 2006-07-04 at 22:28 -0500, Kevin Kuphal wrote:
> UPDATE channel SET atsc_major_chan = atscsrcid / 256
> fails with an unknown error on my database installation.  Version 3.23.58. 
> specifically:
> |#1105 - Unknown error
> 
> Kevin

Hmmm, does the atsc_major_chan column get created?
What error do you get when you run this on the mysql command line?

mysql -u mythtv -pmythtv mythconverg

mysql> DESCRIBE channel; # tells you if columns were created
mysql> UPDATE channel SET atsc_major_chan = atscsrcid / 256;

Does the atsc_minor_chan set fail as well?
mysql> UPDATE channel SET atsc_minor_chan = atscsrcid % 256;


Does this work?
mysql> UPDATE channel SET atsc_major_chan = atscsrcid;
mysql> UPDATE channel SET atsc_major_chan = atsc_major_chan / 256;

-- Daniel



More information about the mythtv-dev mailing list