[mythtv-users] channel id change to mysql
Ismo Tanskanen
ismot at telemail.fi
Tue Mar 10 21:19:28 UTC 2009
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
More information about the mythtv-users
mailing list