Mythweb shows duplicate rows in program listing for channel

[Peter Bennett]

In MythWeb, select "Listings", then click on a channel icon in the first column. It opens a page showing programs for that channel for one day. Sometimes it randomly includes 2 copies of some programs, 3 copies of some, 4 copies of some. I attach a zip file of a saved html page so you can see.

It looks like something may be missing in a SQL join.

[Peter Bennett]

Saved html page

[Stuart Auchterlonie]

Do you have multiple channels that are either channum 763 or callsign 'USAHD' ???

[Peter Bennett]

I do not have multiple channels 7643 or callsign USAHD. I also only have one video source.

select * from channel where channum = 763 or callsign = 'USAHD';

Result (1 row)

# chanid, channum, freqid, sourceid, callsign, name, icon, finetune, videofilters, xmltvid, recpriority, contrast, brightness, colour, hue, tvformat, visible, outputfilters, useonairguide, mplexid, serviceid, tmoffset, atsc_major_chan, atsc_minor_chan, last_record, default_authority, commmethod, iptvid

3763, 763, 763, 3, USAHD, USA Network HD, s58452_h3_aa.png, 0, , I58452.json.schedulesdirect.org, 18, 32768, 32768, 32768, 32768, Default, 1, , 0, , 0, 0, 763, 0, 2017-01-04 03:00:01, , -1,

This does happen with other channels as well.

[sphery]

Dup of #12822.