View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: mythconverg Damaged
PostPosted: Mon May 02, 2005 8:37 pm 
Offline
Joined: Mon May 02, 2005 8:13 pm
Posts: 4
Hi Folks...I have run across a problem with my KnoppMythR5A15 operation. This evening I went to my recorded_programs via the mythweb and was greeted by and empty page

preview title subtitle description channum recgroup airdate length file size

programs, using 1063 TB () out of B.

The previous evening all was working fine, showed 40 or so recorded programs with previews. Upon analyzing the tables with phpmyadmin I get the following error when running check table.

Problems with indexes of table `program`
PRIMARY and INDEX keys should not both be set for column `chanid`
Problems with indexes of table `recgrouppassword`
PRIMARY and INDEX keys should not both be set for column `recgroup`
Problems with indexes of table `recordedprogram`
PRIMARY and INDEX keys should not both be set for column `chanid`
Problems with indexes of table `videometadata`
More than one INDEX key was created for column `title`

Any ideas of what to do or how to fix?

thanks


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 02, 2005 8:43 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
Perhaps a search of the forum?

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 02, 2005 9:01 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
I'll give you a clue... it's a "sticky" problem, or at least a sticky posting... ;-)


Top
 Profile  
 
 Post subject:
PostPosted: Mon May 02, 2005 9:03 pm 
Offline
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location: Fontana, Ca
Hint hint hint hint...

_________________
cesman

When the source is open, the possibilities are endless!


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 03, 2005 6:41 am 
Offline
Joined: Mon May 02, 2005 8:13 pm
Posts: 4
Hi guys, thanks for the quick responses.

In fact, i did do some searches before posting, however, I was clearly using the wrong keywords on both here and google.

The sticky clue was the cincher as I was not expecting to find the problem in Hints & Tips :lol:

Repairing broken MySQL tables
http://mysettopbox.tv/phpBB2/viewtopic.php?t=1043

So, Onward....I had already done the repairs using phpmyadmin prior to posting here and the errors remained. I had a friend of mine, who has been using myth for a long time and is actually the one who turned me onto knoppmyth, check over the tables and do the cli commands. In the end, i still get a blank recorded programs page. So, rather then spend any more time on it..i just copied the shows i had not seen over the network and restored from iso. Hopefully this issue will not appear again.

Oh, fwiw, this machine is on a UPS and I did not see any unexpected system reboots between the time the page was working and the time it was not nor where there any entires in mysql.err log...but I have no idea if there should be any. Also, the watch recording 'page' worked fine from the tv menu, meaning all the recorded shows displayed in the list, were slectable and played, so it seems it was only a mythweb display issue.

Thanks, great work and I appreciate your time.


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 3 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