<br><br><div class="gmail_quote">On Tue, Mar 10, 2009 at 4:19 PM, Ismo Tanskanen <span dir="ltr"><<a href="mailto:ismot@telemail.fi">ismot@telemail.fi</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<br>
I had to change few channel id:s to channel-table.<br>
Ifter that I (of cource) noticed that recorded programs does not show<br>
channel sign right in "watch recordings".<br>
<br>
Now I want to change recordings chanid to match new one<br>
<br>
I execute this sql query:<br>
<br>
UPDATE<br>
record,record_tmp,recordedcredits,recordedfile,recordedprogram,recordedseek,recordmatch,recordedmarkup,recorded,oldrecorded<br>
SET chanid=1004 WHERE chanid=1504<br>
<br>
And get:<br>
Error Code : 1052<br>
Column 'chanid' in field list is ambiguous<br>
(0 ms taken)</blockquote><div><br>Have you tried making the WHERE clause chanid explicit like:<br><br>WHERE record.chanid = 1504?<br><br>I think SQL needs to know which chanid to key off of.<br><br>Kevin</div></div>