Ticket #9161: 9161.log

File 9161.log, 7.2 KB (added by Simon Kenyon <simon@…>, 13 years ago)

sql errors in the log after applying 6948-v2.patch

Line 
12010-12-01 22:44:38.223 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='2'
22010-12-01 22:44:38.224 Driver error was [2/1052]:
3QMYSQL3: Unable to prepare statement
4Database error was:
5Column 'sourceid' in where clause is ambiguous
6
72010-12-01 22:44:38.225 DB Error (ChannelUtil::GetChannels()):
8Query was:
9SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='2'
10Driver error was [2/1052]:
11QMYSQL: Unable to execute query
12Database error was:
13Column 'sourceid' in where clause is ambiguous
14
152010-12-01 22:44:42.500 New DB connection, total: 4
162010-12-01 22:44:43.631 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
172010-12-01 22:44:43.631 Driver error was [2/1052]:
18QMYSQL3: Unable to prepare statement
19Database error was:
20Column 'sourceid' in where clause is ambiguous
21
222010-12-01 22:44:43.632 DB Error (ChannelUtil::GetChannels()):
23Query was:
24SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
25Driver error was [2/1052]:
26QMYSQL: Unable to execute query
27Database error was:
28Column 'sourceid' in where clause is ambiguous
29
302010-12-01 22:44:43.641 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
312010-12-01 22:44:43.642 Driver error was [2/1052]:
32QMYSQL3: Unable to prepare statement
33Database error was:
34Column 'sourceid' in where clause is ambiguous
35
362010-12-01 22:44:43.642 DB Error (ChannelUtil::GetChannels()):
37Query was:
38SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
39Driver error was [2/1052]:
40QMYSQL: Unable to execute query
41Database error was:
42Column 'sourceid' in where clause is ambiguous
43
442010-12-01 22:44:43.649 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
452010-12-01 22:44:43.649 Driver error was [2/1052]:
46QMYSQL3: Unable to prepare statement
47Database error was:
48Column 'sourceid' in where clause is ambiguous
49
502010-12-01 22:44:43.650 DB Error (ChannelUtil::GetChannels()):
51Query was:
52SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
53Driver error was [2/1052]:
54QMYSQL: Unable to execute query
55Database error was:
56Column 'sourceid' in where clause is ambiguous
57
582010-12-01 22:44:43.656 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
592010-12-01 22:44:43.657 Driver error was [2/1052]:
60QMYSQL3: Unable to prepare statement
61Database error was:
62Column 'sourceid' in where clause is ambiguous
63
642010-12-01 22:44:43.657 DB Error (ChannelUtil::GetChannels()):
65Query was:
66SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
67Driver error was [2/1052]:
68QMYSQL: Unable to execute query
69Database error was:
70Column 'sourceid' in where clause is ambiguous
71
722010-12-01 22:44:43.661 Error preparing query: SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
732010-12-01 22:44:43.661 Driver error was [2/1052]:
74QMYSQL3: Unable to prepare statement
75Database error was:
76Column 'sourceid' in where clause is ambiguous
77
782010-12-01 22:44:43.662 DB Error (ChannelUtil::GetChannels()):
79Query was:
80SELECT channum, callsign, channel.chanid,        atsc_major_chan, atsc_minor_chan,        name, icon, mplexid, visible,        channel.sourceid, cardinput.cardid, channelgroup.grpid FROM channel LEFT JOIN channelgroup ON channel.chanid     = channelgroup.chanid JOIN cardinput         ON cardinput.sourceid = channel.sourceid JOIN capturecard       ON cardinput.cardid   = capturecard.cardid WHERE sourceid='1'
81Driver error was [2/1052]:
82QMYSQL: Unable to execute query
83Database error was:
84Column 'sourceid' in where clause is ambiguous