no channels in TVGuide (1 Viewer)

[adagio]

TV-Server Version: 1.0.2.22555
MediaPortal Version: 1.0.2.22555
MediaPortal Skin: standard
Windows Version: Windows XP SP3
CPU Type: Pentium Dual E2200, 2.20 ghz
HDD: ST3500418AS
Memory: 3 gig
Motherboard: Dell Vostro 220
Video Card: ATI Radeon HD3450
Video Card Driver: 8.490
Sound Card: Realtek
Sound Card AC3: no AC3
Sound Card Driver: 6.0.1.5678
1. TV Card: FusionHDTV 7 RT Gold
1. TV Card Type: DVB-T
1. TV Card Driver: 6.2.0.2
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider: Time Warner cable
HTPC Case: Dell VOstro 220
Cooling:
Power Supply: Dell
Remote: none
TV: Westinghouse
TV - HTPC Connection: Composite

I'm trying to see the channels in the TVGiude section of Mediaportal. I'm not talking about the tvguide data itself. I have that, but when I click on TVGuide, it says there are no channels, even though I have plenty. I am guessing that I may have caused this. I added another tuner card and my old tuner had some 'junk' channels that I wanted to remove, so I went into SQL server and deleted those rows from the channel table. Everything is working fine, except I can't get my channels to display in the TVGuide. Can someone give me a hint where to look? Maybe the SQL database doesn't like non sequential records or something?

Thanks for any help.

 

[Shadowmeph]

I am new to this but did you configure your other card .

 

[adagio]

Yes, I did and it works great. I have two cards now. I just want the list of channels back in my TVGuide.

If someone could just tell me how the database is queried to display the channels in MediaPortal TVGuide, I could maybe figure out why they are not displaying. I have one channel showing up, even though all are checked to show in the TVGuide. If I uncheck it then I have no channels, but I can't get any other channels to show. I know I have EPG data because when I select the channel to watch, it shows what is playing.

Thanks!

 

[adagio]

Or can someone tell me where I can find the source code for the TVGuide. I tried finding the source code, but there are so many files - not sure which file to look in.

 

[adagio]

Figured it out. I was trying to clean up old channels left over from a previous card, so I had deleted the channels with SQL, but the channelmap was still referencing some of those old channel id's. Apparently when the TVGuide hits a non existent channel it stops. That's why I was only seeing one channel. I just had to delete the non existent channels referenced in the channel map table, and all is well.

 

[matis1]

i didnt do anything to the sql database but am having the same problem. can you be a bit more precise on what you did to the channel steup in tv-server to get it going again?
thank you

 

[adagio]

I used SQLserver to edit the database directly to fix the issue. So what I did was looked in the groupmap table and checked that for every idChannel value in there, that there was the same idChannel value in the Channels table. If a groupmap entry references an idChannel that can't be found in the Channel table, that's when the problem occurs. Then you just delete that line in Groupmap.

Hope that helps.

 

[matis1]

thanks for your answer, as have no experience working with sql, how did you manage to alter the database in sql. did you use any managing program?
where can i find the database? could it be an option to delete the database and let it be reorganised by mediaportal itself?

 

[adagio]

A standard install of MS SQL installs the SQL Server Management tool. That's how you get into the SQL tables. I probably go into there more than I should - normally you should let MediaPortal handle changes its own way - but for simple corrections I feel comfortable using SQL. If you don't know anything about SQL, I don't know if I can explain enough how to do it here. You may need to go into MediaPortal Configuration and see if you can remove mapped channels in there. Or delete your channels and do a rescan.