id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
10093	mythtv-setup complains about empty tvformat column when adding new DVB-T channels	Kenni Lund [kenni a kelu dot dk]	danielk	"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"	Bug Report - General	closed	minor	0.25	MythTV - Mythtv-setup	Master Head	medium	fixed			0