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

[Albert Graham]

Mike,

Just to clarify,  here is  the startup of the backend log, you'll 
notices that before the failed SQL, the backend does connect to the 
database 3 times OK, so I don't know what that error is about, but it 
looks like something is trying to connect to a non-existent database,

Albert.


cat be.log |more
2008-05-11 23:50:51.804 Using runtime prefix = /home/mtv, libdir = 
/home/mtv/lib
2008-05-11 23:50:51.918 Using localhost value of agraham.g-b.net
2008-05-11 23:50:51.995 New DB connection, total: 1
2008-05-11 23:50:52.008 Connected to database 'mythconverg' at host: 
192.168.10.1
2008-05-11 23:50:52.008 Closing DB connection named 'DBManager0'
2008-05-11 23:50:52.009 Connected to database 'mythconverg' at host: 
192.168.10.1
2008-05-11 23:50:52.018 New DB connection, total: 2
2008-05-11 23:50:52.019 Connected to database 'mythconverg' at host: 
192.168.10.1
2008-05-11 23:50:52.047 Current Schema Version: 1214
Starting up as the master server.
2008-05-11 23:50:52.177 mythbackend: MythBackend started as master server
2008-05-11 23:50:52.335 New DB connection, total: 3
2008-05-11 23:50:52.336 Connected to database 'mythconverg' at host: 
192.168.10.1
2008-05-11 23:50:53.396 ret_pid(0) child(6854) status(0x0)
2008-05-11 23:50:54.397 ret_pid(0) child(6854) status(0x0)
2008-05-11 23:50:55.397 ret_pid(6854) child(6854) status(0x0)
2008-05-11 23:50:55.429 External Tuning program exited with no error
2008-05-11 23:50:55.450 New DB scheduler connection
2008-05-11 23:50:55.460 Connected to database 'mythconverg' at host: 
192.168.10.1
2008-05-11 23:50:56.822 Main::Registering HttpStatus Extension
2008-05-11 23:50:56.822 mythbackend version: 0.21.20080304-1 www.mythtv.org
2008-05-11 23:50:56.822 Enabled verbose msgs:  important general
2008-05-11 23:50:56.864 AutoExpire: CalcParams(): Max required Free 
Space: 1.0 GB w/freq: 15 min
2008-05-11 23:50:58.572 Reschedule requested for id -1.
2008-05-11 23:51:00.594 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'

2008-05-11 23:51:00.598 Scheduled 7 items in 2.0 = 2.02 match + 0.01 place
2008-05-11 23:51:00.600 scheduler: Scheduled items: Scheduled 7 items in 
2.0 = 2.02 match + 0.01 place
2008-05-11 23:51:00.602 Seem to be woken up by USER
2008-05-11 23:51:01.872 MainServer::HandleAnnounce Monitor
2008-05-11 23:51:01.872 adding: agraham.g-b.net as a client (events: 0)

=-========== END


Michael T. Dean wrote:
> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>