On 4/17/06, <b class="gmail_sendername">Mark Knecht</b> <<a href="mailto:markknecht@gmail.com">markknecht@gmail.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br> As of this morning mythfilldatabse is having trouble. It starts off<br>OK talking to Zap2It Labs, but then quickly dies with 100's of<br>messages like the one I've pasted here.<br><br>DB Error (Inserting into dd_schedule):
<br>Query was:<br>INSERT INTO dd_schedule<br>(programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime)<br>VALUES('SH3099430000','14752','2006-04-18T15:00:00','01:00:00',0,0,0,0,0,NULL,0,0,'2006-04-18T16:00:00');
<br>Driver error was [2/1146]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Table 'mythconverg.dd_schedule' doesn't exist<br><br> Any ideas on what to do to fix this?</blockquote><div><br>It looks like maybe your database has something wrong with it; dd_schedule is a table that is dynamically created and removed when mythfilldatabase runs. Try running "mysqlcheck -u mythtv -p -B mythconverg".
<br><br>Carl Fongheiser<br></div></div>