View unanswered posts    View active topics

Board index KnoppMyth General

All times are UTC - 6 hours





Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
Gibble
 Post subject: Lost my database!!!
PostPosted: Mon Oct 01, 2007 5:07 pm 
Offline
Joined: Thu Sep 30, 2004 12:26 pm
Posts: 468
Location: Canada
I noticed today when I went to view mythweb, it had no upcoming recordings, etc. Thought my listings and schedules were still there.

Though, if I click on a schedule I see
Code:
Recording Group:

    Error at /usr/share/mythtv/mythweb/includes/recording_schedules.php, line 503:
    mysql_fetch_row(): supplied argument is not a valid MySQL result resource

    Error at /usr/share/mythtv/mythweb/includes/recording_schedules.php, line 507:
    mysql_free_result(): supplied argument is not a valid MySQL result resource 


I thought the mysql daemon just crashed, but I ps -A | grep sql shows the mysqld and mysqld_safe processes both running.

I need to fix this ASAP! I have stuff scheduled 45 minutes from now EEK! :shock:

_________________
"The amount of time needed to solve a problem is inversely proportionate to the complexity of the solution" -- Me

KM: R5.5
CPU: Athlon 3800+
Vid: nvidia 7300GT
Snd: Chaintech av-710
Tuner: PVR150
HD: 1000gb sata + 750gb sata + 500gb usb
Top
 Profile  
 
Gibble
 Post subject:
PostPosted: Mon Oct 01, 2007 5:11 pm 
Offline
Joined: Thu Sep 30, 2004 12:26 pm
Posts: 468
Location: Canada
Looking further...

mysql> select * from recorded;
ERROR 145 (HY000): Table './mythconverg/recorded' is marked as crashed and should be repaired

_________________
"The amount of time needed to solve a problem is inversely proportionate to the complexity of the solution" -- Me

KM: R5.5
CPU: Athlon 3800+
Vid: nvidia 7300GT
Snd: Chaintech av-710
Tuner: PVR150
HD: 1000gb sata + 750gb sata + 500gb usb
Top
 Profile  
 
Gibble
 Post subject:
PostPosted: Mon Oct 01, 2007 5:16 pm 
Offline
Joined: Thu Sep 30, 2004 12:26 pm
Posts: 468
Location: Canada
I've repaired that table, not sure what to do next.

_________________
"The amount of time needed to solve a problem is inversely proportionate to the complexity of the solution" -- Me

KM: R5.5
CPU: Athlon 3800+
Vid: nvidia 7300GT
Snd: Chaintech av-710
Tuner: PVR150
HD: 1000gb sata + 750gb sata + 500gb usb
Top
 Profile  
 
Gibble
 Post subject:
PostPosted: Mon Oct 01, 2007 5:20 pm 
Offline
Joined: Thu Sep 30, 2004 12:26 pm
Posts: 468
Location: Canada
Catastrophe averted.

There were a whole series of "recorded***" tables that had crashed, they all had an extra row in them. After doing a repair table on them each, the db was clean, and had no more issues that I could find.

I then went to mythweb, selected any recording schedule, and saved it without making changes and now my upcoming recordings all show up.

I hope this helps anyone who has a similar problem.

I think it all stems from a crash yesterday when I had to hit reset. Myth had crashed bringing up the guide while watching livetv...hopefully this is a one time occurence!

ciao,
C

_________________
"The amount of time needed to solve a problem is inversely proportionate to the complexity of the solution" -- Me

KM: R5.5
CPU: Athlon 3800+
Vid: nvidia 7300GT
Snd: Chaintech av-710
Tuner: PVR150
HD: 1000gb sata + 750gb sata + 500gb usb
Top
 Profile  
 
slowtolearn
 Post subject:
PostPosted: Mon Oct 01, 2007 6:06 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
You probably want to check/repair the other tables as well http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 


Board index KnoppMyth General

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 23 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:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu