Opened 8 years ago

Closed 8 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)

mythtv-setup.log (49.5 KB) - added by Kenni Lund [kenni a kelu dot dk] 8 years ago.

Download all attachments as: .zip

Change History (2)

Changed 8 years ago by Kenni Lund [kenni a kelu dot dk]

Attachment: mythtv-setup.log added

comment:1 Changed 8 years ago by Github

Milestone: unknown0.25
Resolution: fixed
Status: newclosed

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

Branch: master Changeset: e6184ab6dafc69c62ca960ebee8b53c64e3fb3fc

Note: See TracTickets for help on using tickets.