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

Nick Morrott knowledgejunkie at gmail.com
Fri Feb 2 02:50:54 UTC 2007


On 31/01/07, Neil Crane <neilcrane at gmail.com> wrote:
> Whilst looking at the cx88 problem (I've now spotted a log entry which
> says the device is busy, which might have something to do with it), I
> decided to upgrade to the latest svn. I now have a problem whereby I
> can't view live tv - mythfrontend immediately returns to the main
> menu.
>
> The tail of the backend log says:
>
> 2007-01-31 21:01:50.363 DB Error (SetInUse):
> Query was:
> INSERT INTO inuseprograms  (chanid, starttime, recusage, hostname,
> lastupdatetime,  rechost, recdir )  VALUES  ('1001',
> '2007-01-31T21:02:39', 'recorder', 'linux', '2007-01-31T21:01:50',
> 'linux', NULL);
> Driver error was [2/1048]:
> QMYSQL3: Unable to execute query
> Database error was:
> Column 'recdir' cannot be null
>
> I've run mysqlcheck, and all appears well with the database.

Is your default storage group configured in setup?

Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin


More information about the mythtv-users mailing list