mythtv-setup complains about empty tvformat column when adding new DVB-T channels

[Kenni Lund [kenni a kelu dot dk]]

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

[Github]

Fixes #10093. Don't insert null tvformat into channel table.

Branch: master Changeset: e6184ab6dafc69c62ca960ebee8b53c64e3fb3fc