[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