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

Lost EPG/Guide data [SOLVED]
http://forum.linhes.org/viewtopic.php?f=6&t=17821
Page 1 of 1

Author:  tophee [ Sun Feb 03, 2008 3:45 pm ]
Post subject:  Lost EPG/Guide data [SOLVED]

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

Author:  cecil [ Sun Feb 03, 2008 3:52 pm ]
Post subject: 

Did you check the db for errors?

Author:  tophee [ Sun Feb 03, 2008 4:03 pm ]
Post subject: 

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.

Author:  tophee [ Mon Feb 04, 2008 2:04 am ]
Post subject: 

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.

Author:  tophee [ Mon Feb 04, 2008 11:54 am ]
Post subject: 

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.

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/