﻿id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
10520	HLS transcode (and likely others) give NULL string db error	beirdo	Chris Pinkham <cpinkham@…>	"{{{
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."	Bug Report - General	closed	minor	0.26	MythTV - General	Master Head	low	fixed			0
