[mythtv-users] channel id change to mysql

[Ismo Tanskanen]

Hi,

I had to change few channel id:s to channel-table.
Ifter that I (of cource) noticed that recorded programs does not show
channel sign right in "watch recordings".

Now I want to change recordings chanid to match new one

I execute this sql query:

UPDATE
record,record_tmp,recordedcredits,recordedfile,recordedprogram,recordedseek,recordmatch,recordedmarkup,recorded,oldrecorded
SET chanid=1004 WHERE chanid=1504

And get:
Error Code : 1052
Column 'chanid' in field list is ambiguous
(0 ms taken)

But if I go table to table like this:
UPDATE record SET chanid=1004 WHERE chanid=1504
it works.

Problem is that I have 23 channel id:s changed and there is 10 tables,
it is 230 queries..
What I'm doing wrong

(I know it is not recommended to edit mythconverg directly but anyway, I
lost it already)

- m_kane