[mythtv-users] mythjobqueue DB error

[Blammo]

On Tue, Apr 15, 2008 at 2:36 PM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 04/14/2008 11:23 PM, Richard Shaw wrote:
>> Column 'recdir' cannot be null

> Sounds like you have a broken storage groups configuration.  What do you
> get with:
>
> SELECT * FROM storagegroup;

Same problem:

Query was:
INSERT INTO inuseprograms  (chanid, starttime, recusage, hostname,
lastupdatetime,  rechost, recdir )  VALUES  ('1121',
'2008-05-21T21:38:00', 'flagger', 'backend1', '2008-05-21T21:38:12',
'tuners', NULL);
Driver error was [2/1048]:
QMYSQL3: Unable to execute query
Database error was:
Column 'recdir' cannot be null


mysql> select * from storagegroup;
+----+-----------+-----------------------+---------------+
| id | groupname | hostname              | dirname       |
+----+-----------+-----------------------+---------------+
|  1 | Default   | backend1              | /raid/myth/tv |

Which is correct.. that's MBE with local disk space.