[mythtv-users] SQL Error: scheduling recordings

Trey Thompson treythompson at gmail.com
Fri Nov 10 15:47:02 UTC 2006


> >Can you record from the frontend?
> >_______________________________________________
>
> No that doesn't work either. When I selected a show on the front end and hit 'R' I found somewhat of an error there:
>
> 2006-11-10 00:04:05.867 DB Error (inserting row):
> Query was:
> INSERT INTO record (recordid) VALUES (0);
> Driver error was [2/1364]:
> QMYSQL3: Unable to execute query
> Database error was:
> Field 'description' doesn't have a default value
>
> 2006-11-10 00:04:05.870 DB Error (simpledbstorage update):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2006-11-10 00:04:05.871 DB Error (simpledbstorage update):
> Query was:
>
> No error type from QSqlError?  Strange...
> 2006-11-10 00:04:05.873 DB Error (simpledbstorage update):
> Query was:

I'm totally a newbie here, so I'm just guessing...
Does the user you're connecting to MySQL with have all the security?
Have you tried dropping the mythconverg table, recreating it? (You'd
lose all settings obviously, I don't know how far into your setup you
are...)
How about just simply stopping/restarting mysql?


More information about the mythtv-users mailing list