Opened 10 years ago

Closed 10 years ago

#9968 closed Bug Report - General (fixed)

Import recorder NULL strings in mysql query

Reported by: Lawrence Rust <lvr@…> Owned by: danielk
Priority: minor Milestone: 0.25
Component: MythTV - General Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no


Commits 4dfcdb8dd0 1fb0a77fc and d85b750 introduced much stricter checking on mysql queries which results in the import recorder giving the following message in the backend log:

2011-08-06 10:04:58.926519 E  Original query failed, but resend with empty strings in place of NULL strings worked. 
DB Error (MSqlQuery):
Query was:
INSERT INTO recorded    (chanid,    starttime,   endtime,         title,                subtitle,  description, season,          episode,              hostname,  category,    recgroup,        autoexpire,           recordid,  seriesid,    programid,       inetref,              stars,     previouslyshown,              originalairdate,      findid,    transcoder,  playgroup,       recpriority,          basename,  progstart,   progend,         profile,              duplicate, storagegroup) VALUES  (?,   ?,     ?,           ?,               ?, ?,       ?,         ?,             ?, ?,   ?,       ?,             ?, ?,   ?,      ?,             ?,    ?,                      ?,         ?,   ?, ?,      ?,         ?, ?,  ?,        ?,             0,         ?) 
Bindings were:
:AUTOEXP=true, :BASENAME="92009_20110806100458.mpg", :CATEGORY=NULL,
:CHANID=92009, :DESC=NULL, :ENDS=2011-08-06T10:30:00, :EPISODE=0, :FINDID=0,
:HOSTNAME="gagarin", :INETREF=NULL, :ORIGAIRDATE="0000-00-00",
:PLAYGROUP="Default", :PROFILE="Default", :PROGEND=2011-08-06T10:30:00,
:PROGRAMID=NULL, :PROGSTART=2011-08-06T10:04:58, :RECGROUP="Default",
:STARTS=2011-08-06T10:04:58, :STORGROUP="LiveTV", :SUBTITLE=NULL, :TITLE="",
Driver error was [2/1048]:
QMYSQL3: Unable to execute statement
Database error was:
Column 'subtitle' cannot be null

Change History (2)

comment:1 Changed 10 years ago by danielk

Owner: set to danielk
Status: newaccepted

comment:2 Changed 10 years ago by Github

Milestone: unknown0.25
Resolution: fixed
Status: acceptedclosed

Fixes #9968. Don't pass NULL values to NOT NULL columns in RecordingInfo? (subtitle and description).

Branch: master Changeset: 6bd5d1e3bdb1bef201a1f50c0976eaf6d0333716

Note: See TracTickets for help on using tickets.