LinHES Forums
http://forum.linhes.org/

mythfilldatabase error - FIXED
http://forum.linhes.org/viewtopic.php?f=6&t=5726		 Page 1 of 1
Author:  thervey [ Thu Aug 18, 2005 7:23 pm ]
Post subject:  mythfilldatabase error - FIXED
Read several posts about mythfilldatabase errors but havent found one that matched this yet.

there error i am getting is the following.
Code:
DB Error (Inserting into dd_schedule):
Query was:
INSERT INTO dd_schedule (programid,stationid,scheduletime,duration,repeat,stereo,subtitled,hdtv,closecaptioned,tvrating,partnumber,parttotal,endtime) VALUES('EP7302190008','10171','2005-08-19T09:30:00','00:15:00',0,0,0,0,1,'TV-Y',0,0,'2005-08-19T09:45:00');
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythconverg.dd_schedule' doesn't exist


And this continues to repeat over and over again until i ctrl-c out of it. Any suggestions? The only thing that I can think of that would be causing this could be related to a previous issue i was having. That was that my log files were growing to large and causing knoppmyth to crash as it tried to load. To fix that I ran a script that someone posted on here that fixed that problem. However after running that script i started having issues my channel listings. At one point I could run mythfilldatabase and everything seemed fine. Now though things seem a mess. Posted below is the script that i ran.

Code:
df -h
echo " " > /var/log/messages
echo " " > /var/log/kern.log
echo " " > /var/log/syslog
echo " " > /var/log/mythtv/mythbackend.log
echo " " > /var/log/mythtv/mythbackend.log.1
df -h
/usr/local/bin/reset-mythbackend


If anyone has any suggestions I would appreciate it, thanks.
Author:  thervey [ Thu Aug 18, 2005 8:01 pm ]
Post subject: 
Fixed the error I think.

Turns out that my hda1 was maxed out on space because I had mistakenly moved a very large file to the home directory there. Moved the file elsewhere and now mythfilldatabase is working fine.
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/