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/ |