[mythtv-users] DB Error - Column 'recdir' cannot be null

[Tom Greer]

On one of my four MythTV frontend/backend systems, I get DB Errors in
the backend logs that look like this:

2007-06-20 11:30:17.664 DB Error (SetInUse):
Query was:
INSERT INTO inuseprograms  (chanid, starttime, recusage, hostname,
lastupdatetime,  rechost, recdir )  VALUES  ('1345',
'2007-06-20T09:42:01', 'flagger', 'shuttle1', '2007-06-20T11:30:17',
'mythtv1', NULL);
Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'recdir' cannot be null

I have a valid default storage directory defined for this backend in
mythtv-setup.  In fact, all of my Myth systems are similarly
configured.  I don't see any obvious differences between this box and
the others.

Also, the system successfully displays live TV and records just fine.

I just happened to look at the backend logs and stumbled on these errors.

I'd like to fix this.  Any help is appreciated.

Tom