Opened 9 years ago
Closed 9 years ago
#10093 closed Bug Report - General (fixed)
mythtv-setup complains about empty tvformat column when adding new DVB-T channels
Reported by: | Kenni Lund [kenni a kelu dot dk] | Owned by: | danielk |
---|---|---|---|
Priority: | minor | Milestone: | 0.25 |
Component: | MythTV - Mythtv-setup | Version: | Master Head |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
When scanning for new channels in mythtv-setup and adding these, mythtv-setup throws the following error for each channel:
2011-10-13 01:12:18.432224 E [25734/25734] CoreContext mythdbcon.cpp:684 (exec) - Original query failed, but resend with empty strings in place of NULL strings worked. DB Error (MSqlQuery): Query was: INSERT INTO channel (chanid, channum, sourceid, callsign, name, serviceid, mplexid, freqid, atsc_major_chan, atsc_minor_chan, useonairguide, visible, tvformat, icon, xmltvid, default_authority) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Bindings were: :AUTHORITY="", :CALLSIGN="DR HD", :CHANID=1006, :CHANNUM="6", :FREQID="51", :ICON="", :MAJORCHAN=0, :MINORCHAN=0, :MPLEXID=1, :NAME="DR HD", :SERVICEID=2030, :SOURCEID=1, :TVFORMAT=NULL, :USEOAG=true, :VISIBLE=true, :XMLTVID="" Driver error was [2/1048]: QMYSQL3: Unable to execute statement Database error was: Column 'tvformat' cannot be null
As the error says, the channels does get created, but with tvformat="".
This is on current master as of today: v0.25pre-3486-gcfeca63
Attachments (1)
Change History (2)
Changed 9 years ago by
Attachment: | mythtv-setup.log added |
---|
comment:1 Changed 9 years ago by
Milestone: | unknown → 0.25 |
---|---|
Resolution: | → fixed |
Status: | new → closed |
Note: See
TracTickets for help on using
tickets.
Fixes #10093. Don't insert null tvformat into channel table.