rendered paste bodyQuery was:
SELECT dd_v_station.stationid, dd_v_station.callsign, dd_v_station.stationname, dd_v_station.fccchannelnumber, dd_v_station.channel, dd_v_station.channelMinor FROM dd_v_station LEFT JOIN channel ON dd_v_station.stationid = channel.xmltvid AND channel.sourceid = 1 WHERE channel.chanid IS NULL
Driver error was [2/1267]:
QMYSQL3: Unable to execute query
Database error was:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
2006-12-18 21:50:43.396 Updating icons for sourceid: 1
2006-12-18 21:50:43.407 Channels updated.
2006-12-18 21:50:43.410 DB Error (Populating temporary table dd_v_program):
Query was:
INSERT INTO dd_v_program ( chanid, starttime, endtime, title, subtitle, description, airdate, stars, previouslyshown, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, showtype, category_type, colorcode, syndicatedepisodenumber, tvrating, mpaarating, programid ) SELECT chanid, scheduletime, endtime, title, subtitle, description, year, stars, isrepeat, stereo, subtitled, hdtv, closecaptioned, partnumber, parttotal, seriesid, originalairdate, showtype, category_type, colorcode, syndicatedepisodenumber, tvrating, mpaarating, dd_program.programid FROM channel, dd_schedule, dd_program WHERE ((dd_schedule.programid = dd_program.programid) AND (channel.xmltvid = dd_schedule.stationid) AND (channel.sourceid = 1))
Driver error was [2/1267]:
QMYSQL3: Unable to execute query
Database error was:
Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='