EIT helper only updates first DVB card's EPG data

[dan.sheridan@…]

I have just added a second DVB card to my system. The first DVB card continues to get updated EPG data from the UK DVB EPG. The second card has no data for any of its channels.

In my logs I see, for example,

2006-01-30 17:03:14.436 MSqlQuery: SELECT chanid, useonairguide FROM channel, dtv_multiplex WHERE serviceid = 14592 AND       networkid = 9018 AND       transportid = 12290 AND       channel.mplexid = dtv_multiplex.mplexid

Running this in mysql gives me

+--------+---------------+
| chanid | useonairguide |
+--------+---------------+
|   1196 |             1 |
|   6196 |             1 |
+--------+---------------+

but the code in eithelper.cpp only uses the first chanid for updating the database. The second chanid is discarded.

[dan.sheridan@…]

Attached patch fixes it for me. I've addressed the comment in eithelper.cpp:

 *  NOTE: This currently takes a mplexid key for the dtv_multiplex table,
 *        but it should just take a sourceid key for the channel table.

[danielk]

I'm not going to use the patch since this code will be changed greatly in the EIT rewrite.

But I'm keeping the ticket open.

Can you describe what is happening in more detail. Am I to understand that when card 2 does a scan it never inserts anything because it gets the mplexid for the same channel on card 1, and when finds that it doesn't match the current channel it tosses the data?

[dan.sheridan@…]

The code as written takes the first result from the query that I pasted in and discards the others, so the channel data for card 1 gets updated every time, even though the data originated from card 2. So no data ever gets inserted for card 2's channels, just for card 1's channels.

Can I pursuade you to use the patch as an interim measure? -- it's not very invasive...

[danielk]

(In [9046]) Closes #1155. Make sure EIT scanner updates the right source if a channel exists on multiple transports with exactly the same params.

[dan.sheridan@…]

Thanks very much Daniel!