Opened 13 years ago
Closed 13 years ago
#9968 closed Bug Report - General (fixed)
Import recorder NULL strings in mysql query
Reported by: | Owned by: | danielk | |
---|---|---|---|
Priority: | minor | Milestone: | 0.25 |
Component: | MythTV - General | Version: | Master Head |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
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", :RECORDID=0, :RECPRIORITY=0, :REPEAT=false, :SEASON=0, :SERIESID=NULL, :STARS=0, :STARTS=2011-08-06T10:04:58, :STORGROUP="LiveTV", :SUBTITLE=NULL, :TITLE="", :TRANSCODER=0 Driver error was [2/1048]: QMYSQL3: Unable to execute statement Database error was: Column 'subtitle' cannot be null
Change History (2)
Note: See
TracTickets for help on using
tickets.
Fixes #9968. Don't pass NULL values to NOT NULL columns in RecordingInfo? (subtitle and description).