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

Kevin Kuphal kuphal at dls.net
Wed Jul 5 13:08:19 UTC 2006


Daniel Kristjansson wrote:
> 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?
>   
Yes, both new columns are created fine.
> 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;
>   
Same thing.  ERROR 1105: Unknown error.
> Does the atsc_minor_chan set fail as well?
> mysql> UPDATE channel SET atsc_minor_chan = atscsrcid % 256;
>   
No, that reports success.

Query OK, 0 rows affected (0.00 sec)
Rows matched: 20  Changed: 0  Warnings: 11

>
> Does this work?
> mysql> UPDATE channel SET atsc_major_chan = atscsrcid;
> mysql> UPDATE channel SET atsc_major_chan = atsc_major_chan / 256;
>   
Yes, that worked fine.

mysql> UPDATE channel SET atsc_major_chan = atscsrcid;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 20  Changed: 0  Warnings: 11

mysql> UPDATE channel SET atsc_major_chan = atsc_major_chan / 256;
Query OK, 0 rows affected (0.06 sec)
Rows matched: 20  Changed: 0  Warnings: 0

Kevin


More information about the mythtv-dev mailing list