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:
tophee
PostPosted: Sun Feb 03, 2008 3:45 pm 
Offline
Joined: Tue Sep 13, 2005 10:48 am
Posts: 852
Location: London, UK
I've turned on the TV to watch something this evening. Before I flipped through what I had recorded I decided to see what might be coming up. I went to the guide and to my dismay, do not appear there was no data in the guide.

I checked my last run of mythfilldatabase through Information, and it says I've data for the next 8 days. Which is usual.

I quickly put live TV on. And it works. Just no guide data.
I had a very quick look in mythtv-settup. And card one (listed as 0) is reporting an error.

A quick reboot, and no dice. No further in fixing this. Ususally I'd roll my sleeves up an d have a fiddle. Unfortunately I've family here so they want to watch stuff.

I imagine that a delete cards and channels and adding them again with a quick rescan will fix the problem. Unfortunately I can't do that immediately (see above). However, I thought I'd post this little tale to see if anyone has any experience of such an occurrence. Hopefully my proposed fix will, well, fix it. I might do the little fix identified in the installation guide / hints and tips for R5F27 for ensuring there are no errors in the database.

As tjc posted:

Quote:
1.2) If you are getting errors/warnings when you try to exit mythtv-setup along the lines of "Card 0 (type) is set to start on channel 2, which does not exist.", you may need to manually delete the offending rows in the cardinput table. These are generally rows with the cardid = 0. If the following commands show a cardid (especially 0) in the cardinput table which is not listed in the capturecard table you should remove all references to it:
Code:
root@black2:~# mysql mythconverg -e "select cardid, videodevice, defaultinput from capturecard"
+--------+-------------+--------------+
| cardid | videodevice | defaultinput |
+--------+-------------+--------------+
| 1 | /dev/video0 | Tuner 1 |
| 2 | /dev/video1 | Tuner 1 |
+--------+-------------+--------------+
root@black2:~# mysql mythconverg -e "select cardid, sourceid, inputname from cardinput"
+--------+----------+-----------+
| cardid | sourceid | inputname |
+--------+----------+-----------+
| 1 | 1 | Tuner 1 |
| 2 | 1 | Tuner 1 |
+--------+----------+-----------+

As far as I can tell, valid cardid and sourceid values now start from 1 rather than 0. To remove the offending records:
Code:
mysql mythconverg -e "delete from cardinput where cardid=0"



Anyone had any experience with this type of problem that can offer any insight?

Well, I will post back if what I propose fixes it. It'll mean that there is a solution that someone else might find useful for a similar problem. When I searched couldn't find anything relating to this. -Though I may have missed it.

Regards Chris

_________________
Version:R8
Intel C2D 7400, Nvidia 5600 via HDMI to Samsung B37B650TW (PAL), Asus P5QL-E mobo, 4Gb PC6400 DDR2 ram, Samsung Spinpoint 500 Gb & 1Tb drive, Nova-HD-S2 (x2)


Last edited by tophee on Mon Feb 04, 2008 11:54 am, edited 1 time in total.
Top
 Profile  
 
cecil
 Post subject:
PostPosted: Sun Feb 03, 2008 3:52 pm 
Offline
Site Admin
Joined: Fri Sep 19, 2003 6:37 pm
Posts: 2659
Location: Whittier, Ca
Did you check the db for errors?
Top
 Profile  
 
tophee
 Post subject:
PostPosted: Sun Feb 03, 2008 4:03 pm 
Offline
Joined: Tue Sep 13, 2005 10:48 am
Posts: 852
Location: London, UK
Not yet, as I said - have the inlaws over and they want to watch tv.
I will, though not quite sure how to check for db errors.

_________________
Version:R8
Intel C2D 7400, Nvidia 5600 via HDMI to Samsung B37B650TW (PAL), Asus P5QL-E mobo, 4Gb PC6400 DDR2 ram, Samsung Spinpoint 500 Gb & 1Tb drive, Nova-HD-S2 (x2)
Top
 Profile  
 
tophee
 Post subject:
PostPosted: Mon Feb 04, 2008 2:04 am 
Offline
Joined: Tue Sep 13, 2005 10:48 am
Posts: 852
Location: London, UK
oh, I see. If I'd have looked sooner I'd have seen this: http://www.knoppmythwiki.org/index.php?page=RepairingMythConvergDB will have a go tonight.

_________________
Version:R8
Intel C2D 7400, Nvidia 5600 via HDMI to Samsung B37B650TW (PAL), Asus P5QL-E mobo, 4Gb PC6400 DDR2 ram, Samsung Spinpoint 500 Gb & 1Tb drive, Nova-HD-S2 (x2)
Top
 Profile  
 
tophee
 Post subject:
PostPosted: Mon Feb 04, 2008 11:54 am 
Offline
Joined: Tue Sep 13, 2005 10:48 am
Posts: 852
Location: London, UK
Thanks for the push in the right direction Cesman.
It was the DB. Followed the guide on the wiki and all is back. Thanks alot.

_________________
Version:R8
Intel C2D 7400, Nvidia 5600 via HDMI to Samsung B37B650TW (PAL), Asus P5QL-E mobo, 4Gb PC6400 DDR2 ram, Samsung Spinpoint 500 Gb & 1Tb drive, Nova-HD-S2 (x2)
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 31 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