View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 16 posts ] 
Go to page 1, 2  Next

Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun Jul 17, 2005 11:34 am 
Offline
Joined: Thu Nov 25, 2004 11:15 pm
Posts: 75
I'm running R4V5 (haven't gotten around to upgrading).
For several days, myth has been freezing when told to delete a recording. It would delete it, but it had to be hard shutdown in order to get anywhere. Then one time, on reboot, the machine stopped at the desktop. If I try to run mythbackend from xterm I get this error:
Quote:
Told to create a NEW database schema but the database already has 38 tables.
If you are sure this is a good myth database, verify that the settings table has the DBSchemaVer variable.


From here http://mysettopbox.tv/phpBB2/viewtopic.php?t=2860#15525 I tried to run
Code:
mysql mythconverg -e "select * from settings order by value;"
but that gave
Quote:
Error 1146 at Line 1: Table mythconverg.settings doesn't exist


I found this http://www.gossamer-threads.com/lists/m ... 023#110946 but now when I try to run mythtvsetup, I get a command not found.

I'm starting to think the hard drive has had corruption or something. How can I check for this or whatever else this might be. Thanks in advance.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jul 17, 2005 12:51 pm 
Offline
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location: Nashville, TN
on knoppmyth it's mythtv-setup

_________________
Have a question search the forum and have a look at the KnoppMythWiki.

Xsecrets


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jul 17, 2005 8:53 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
You should check your db for errors.

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 18, 2005 12:23 am 
Offline
Joined: Thu Nov 25, 2004 11:15 pm
Posts: 75
how can I do that?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 18, 2005 12:24 am 
Offline
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location: Nashville, TN
there's a sticky post in howto section

_________________
Have a question search the forum and have a look at the KnoppMythWiki.

Xsecrets


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 18, 2005 8:36 am 
Offline
Joined: Thu Nov 25, 2004 11:15 pm
Posts: 75
thanks


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 22, 2005 8:30 am 
Offline
Joined: Thu Nov 25, 2004 11:15 pm
Posts: 75
I've gone through everything in the thread on repairing the tables but nothing has come up with errors yet I still get the "database schema" error when trying to run the backend.

I think I now have an idea what caused the error though. hda4 is 98% full so what I'm guessing happened is that when it froze while deleting, it deleted the database entry but not the file itself. Does this make sense? And if it does, will manually deleting some old recordings help fix this?


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jul 24, 2005 9:49 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
No, it doesn't make sense as I've filled /myth when I was away on business for longer that I was originally scheduled.

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jul 24, 2005 10:06 pm 
Offline
Joined: Thu Nov 25, 2004 11:15 pm
Posts: 75
is there anything else I should check for or do you think its time to wipe the database/reinstall?


Top
 Profile  
 
 Post subject:
PostPosted: Sun Jul 24, 2005 10:34 pm 
Offline
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location: Nashville, TN
generally the problem is that it deletes the file, but not the db entry. I've had this happen then I go into mythweb find out what it thinks the filename is and do a touch 2335664234352234(whatever filename is supopsed to be).nuv in the /myth/tv dir and delete it again and all was happy.

_________________
Have a question search the forum and have a look at the KnoppMythWiki.

Xsecrets


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 26, 2005 9:02 am 
Offline
Joined: Thu Nov 25, 2004 11:15 pm
Posts: 75
my backend is not running however so will mythweb still function? I thought mythweb required the backend.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jul 26, 2005 11:51 pm 
Offline
Joined: Sun Jul 24, 2005 1:37 am
Posts: 42
Xsecrets wrote:
I've had this happen then I go into mythweb find out what it thinks the filename is and do a touch 2335664234352234


Oh cool. I've had this happen to me before and didn't know how to delete the file. Thanks for the tip!!!

-Aubrey


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 27, 2005 7:45 am 
Offline
Joined: Mon Oct 06, 2003 10:38 am
Posts: 4978
Location: Nashville, TN
if you can't make the backend run forget what I said as that is not your problem as file/db mismatch will not keep the backend from running.

_________________
Have a question search the forum and have a look at the KnoppMythWiki.

Xsecrets


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 27, 2005 6:57 pm 
Offline
Joined: Thu Nov 25, 2004 11:15 pm
Posts: 75
so I take it its time to reinstall?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 27, 2005 8:25 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Possibly. You might want to try a back up and if what it dumps out of the DB looks OK, an upgrade.


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ] 
Go to page 1, 2  Next



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu