Opened 5 years ago
Closed 4 years ago
Last modified 4 years ago
HLS transcode (and likely others) give NULL string db error
|Reported by:||beirdo||Owned by:||Chris Pinkham <cpinkham@…>|
|Component:||MythTV - General||Version:||Master Head|
2012-03-27 19:15:28.759108 E [15286/15286] CoreContext mythdbcon.cpp:648 (exec) - Original query failed, but resend with empty strings in place of NULL strings worked. DB Error (MSqlQuery): Query was: INSERT INTO inuseprograms (chanid, starttime, recusage, hostname, lastupdatetime, rechost, recdir) VALUES (?, ?, ?, ?, ?, ?, ?) Bindings were: :CHANID=0, :HOSTNAME="mythbe", :RECDIR="", :RECHOST=NULL, :RECUSAGE="transcoder", :STARTTIME=2012-03-27T19:15:28, :UPDATETIME=2012-03-27T19:15:28 Driver error was [2/1048]: QMYSQL3: Unable to execute statement Database error was: Column 'rechost' cannot be null
The program works as expected after trying again with "", essentially. A minor inconvenience that messes up the logs, not terribly important.