[mythtv-users] Help - Cannot scheduled any programs - to record

[Michael T. Dean]

On 05/11/2008 02:43 PM, Albert Graham wrote:
> I cannot scheduled anything to record ? also all my previous schedules 
> are gone ? (since last night)
>
> I'm really stuck, my MythTV setup is working OK, I can view TV and 
> recorded programs, but can no longer scheduled anything to record.
>
> I cannot found anything wrong ?
>
> The mythtv backend log file looks OK but does contain the following:
>
> 2008-05-11 19:30:10.623 DB Error (Creating sched_temp_record table):
> Query was:
> CREATE TEMPORARY TABLE sched_temp_record LIKE record;
> Driver error was [2/1049]:
> QMYSQL3: Unable to execute query
> Database error was:
> Unknown database 'mythconverg'
>   

Looks like your system (one of them) is connecting to the wrong DB server.

rm ~/.mythtv/{config.xml,mysql.txt}

Then use mythtv-setup to re-create your config.xml.

Mike