TV Guide problems

[cyclone05]

I went on vacation and my TV Guide was fine. I get back and my guide shows only "no show details". Since an update was release while I was gone I updated first - hoping that that would fix it. It didn't.

I use Schedules Direct with one analog (cable) and two OTA digital tuners.

Any suggestions?

[whurlston]

Has your SD subscription expired? If not, zip and post your logs showing an EPG update.

[cyclone05]

No, my subscription is current. I've never had a problem that required me to do anything with logs before, so if I didn't give you what you need let me know.

I also checked my listing reports to make sure the unique codes hadn't changed. They hadn't, but I went ahead and retyped them just to make sure. Still doesn't work.

[whurlston]

It is showing that it is pulling listings:

Code:

2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 8 KCCIDT : 453 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 8 KCCIDT2 : 80 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 11 KDINDT : 525 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 11 KDINDT2 : 658 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 11 KDINDT3 : 758 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 17 KDSMDT : 611 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 17 KDSMDT2 : 611 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 21 KTINDT3 : 758 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 13 WHODT : 414 shows
2008-06-18 18:43:09.578    VERBOSE    [5]     - channel 5 WOIDT : 456 shows

Is the correct date showing at the top of your TV guide?

[cyclone05]

Yeah, correct date, but still no details.

[whurlston]

I'm not sure then, sorry. sub may have some insight though.

[cyclone05]

Thanks for your help - maybe someone else has had this happen?

[JavaWiz]

Not sure, but there are some error messages at the end of the log indicating that the Channel table may be corrupted??

2008-06-18 18:46:28.562 ERROR [1] No rows affected by: update CHANNEL set channel_number=2, favourite_channel="Y" where oid=15
2008-06-18 18:46:28.562 ERROR [1] No rows affected by: update CHANNEL set channel_number=3, favourite_channel="Y" where oid=48
2008-06-18 18:46:28.562 ERROR [1] No rows affected by: update CHANNEL set channel_number=4, favourite_channel="Y" where oid=41
....

You might try running the following script to see if the channel table matches up to your programme table for the above oid from the channel table:

Code:

[FONT=Courier New]@Echo ON[/FONT]
[FONT=Courier New]pushd c:\Program Files\Devnz\Gbpvr[/FONT]
[FONT=Courier New]Echo .echo on                                       >  sqlscript.scr[/FONT]
[FONT=Courier New]Echo .output stdout                                 >> sqlscript.scr[/FONT]
[FONT=Courier New]Echo SELECT start_time, end_time, p.Name, sub_title >> sqlscript.scr[/FONT]
[FONT=Courier New]Echo   FROM programme p, channel c                  >> sqlscript.scr[/FONT]
[FONT=Courier New]Echo  WHERE p.channel_oid = c.oid                   >> sqlscript.scr[/FONT]
[FONT=Courier New]Echo    AND c.oid = 41;                             >> sqlscript.scr[/FONT]
[FONT=Courier New]@ECHO ON[/FONT]
[FONT=Courier New]SQLITE3 GBPVR.DB3 < sqlscript.scr[/FONT]
[FONT=Courier New]@ECHO OFF[/FONT]
[FONT=Courier New]popd[/FONT]

Paste that code into notepad, save the file as c:\temp\CheckDb.cmd, then run it in a CMD prompt. It should output all the EPG listings for oid 41 in the channel table (which should map to your channel 4 in your EPG).

[cyclone05]

It looks like everything does map to 41, if I'm reading any of this correctly. So what should I do? Just reinstall GB-PVR? Or something else?

Thanks!

[JavaWiz]

It looks like everything does map to 41, if I'm reading any of this correctly. So what should I do? Just reinstall GB-PVR? Or something else?

Thanks!

I don't think a re-install is necessary. You might try:

• Delete your capture sources
  
• Save changes
  
• Re-add/setup your capture sources