[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