Add back deleted channel (1 Viewer)

[VE6CPU]

MediaPortal Version: 1.1.3

Sorry everyone for so many posts. I search this one for a while and couldn't find anything that would help.

I deleted an ATSC channel by accident. I tried doing a rescan but it didn't add it back in. I have no idea what the transport or many of the other settings are. I just know its ch 38.1. Is there a doc on this?

Thanks.

Stephen

 

[mm1352000]

Hi again

You can't un-delete a channel. A rescan should have picked it back up though. Are you certain it didn't get added back into the list?

mm

 

[VE6CPU]

I tried the rescan on both digital tuners. When it gets to 38 it says "New 0: Updated 1" but I can't find that channel in TV Channels or TV Mapping.

Stephen

 

[mm1352000]

I don't know why that hasn't worked. Check the tuningdetail table in the database if you can and find the detail with major channel 38 and minor channel 1. Use idChannel to do a reverse lookup on the channel itself in the channel table. If the channel entry doesn't exist but the tuningdetail does then please let me know as that would be a problem that should be fixed.

mm

 

[VE6CPU]

I'm running mysql as the database. Do you know what the default root password is or what the user name/password is that MP uses?

 

[Paranoid Delusion]

Password = MediaPortal
User = root

HTH

 

[VE6CPU]

Okay I'm in the DB. I am finding something a little out with the table. We have 6 digital OTA channels here. It seems to have mixed up two of them. One is on channel 49 and is CityTV Calgary and maps to 5.1. The other is Channel 38 OMNI Calgary and maps to 38.1.

In the DB it seems to have CityTV on channelNumber 49 which is right but when in the TV server it is showing OMNI in the name for ch 49.

I get an empty set when looking for Ch 38 in both Major and channelNumber.

Looking at the Channels table it show idChannel = 8 for "OMNI Calgary" but idChannel 8 maps to CityTV in the tuningdetail table.

Can I do a delete from in both of these tables and do a rescan or do I need to update other tables to make that work?

Stephen

P.S. I did a complete uninstall this morning and reinstalled 1.2.0. I was using 1.2.0RC last night. The DB was blank when I started this morning but I still have the same problem.

I had a second machine that I installed 1.2.0 final on just a few minutes ago. It has a single HVR-950q usb tuner. I did a channel scan on the ATSC input and noticed something. It found channel 38 (Omni Calgary) and on that line it said "New 1: Updated 0". Later on in the scan it found channel 49 (CityTV Calgary) and it said "New 0: Update 1". So it looks like it's updating ch 38 with ch 49's info. Both of these channels are owned by the same company but that shouldn't make any difference.

My question is, how is MP determining if it should update or insert a new channel?

Stephen

 

[mm1352000]

Hi again Stephen

We use TSID + ONID + SID as the unique identifier of a channel. In database column terms that is transportId + networkId + serviceId. If a tuningdetail record with a particular combination already exists then we update rather than create. If those channels have the same combination of those IDs then they are not compliant with DVB guidelines, which is the main broadcasting standard that MediaPortal adheres to. You will have to create Omni Calgary manually:

1. Open TV Server configuration.
2. Go to the "TV Channels" section.
3. Rename "Omni Calgary" to "CityTV Calgary".
4. Click "add" (channel).
5. Set name "Omni Calgary".
6. Click "add".
7. Select "ATSC" (???).
8. Enter the channel number you use to select the channel (doesn't *really* matter).
9. Enter the appropriate frequency (critical).
10. Enter 38 as major channel.
11. Enter 1 as minor channel.
12. Select 8 VSB for ATSC modulation.
13. Enter the network ID, transport ID and service ID you found in the DB.
14. PMT PID is probably 30. You may need to set it to 0 if you don't know what it is.
15. Optionally enter the provider name.
16. Tick free to air.

Unfortunately this is going to keep getting messed up each time you rescan - one of the downsides of having non-compliant providers.

mm

 

[VE6CPU]

Thanks for the instructions. That seems to do the trick but took a search to find what frequency 38 was (thanks Google).

One other way that worked and is a bit of a hack also.

I deleted all the channels in TV Server config. I then did a scan and before it got to ch 49 I stopped the scan. I took a DB backup at that point. I then did a rescan this time letting it get all the way through and it updated the ch 38 with ch 49's info. I then exported the db again to a different file name.

At this point I opened both xml files and copy and pasted the real channel's names and numbers and changed the ID's so they didn't over lap. I then saved to yet a third xml file and used this third file to import the channels. It imported them properly and I can preview each channel correctly. So as long as I don't rescan all should work.

I'm emailing the stations (owned by the same company) to tell them that yes people notice these things.

Stephen

 

[mm1352000]

Cheers Stephen
I do apologise for the inconvenience. I hope the stations are responsive to your request.

mm