Opened 4 years ago

Closed 4 years ago

#12953 closed Bug Report - General (Duplicate)

Mythweb shows duplicate rows in program listing for channel

Reported by: Peter Bennett Owned by: Stuart Auchterlonie
Priority: minor Milestone: 0.28.1
Component: Plugin - MythWeb Version: 0.28.0
Severity: medium Keywords:
Cc: Ticket locked: no


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.

Attachments (1) (128.6 KB) - added by Peter Bennett 4 years ago.
Saved html page

Download all attachments as: .zip

Change History (4)

Changed 4 years ago by Peter Bennett

Attachment: added

Saved html page

comment:1 Changed 4 years ago by Stuart Auchterlonie

Milestone: unknown0.28.1
Status: newinfoneeded_new

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

comment:2 Changed 4 years ago by 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, ,, 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.

comment:3 Changed 4 years ago by sphery

Resolution: Duplicate
Status: infoneeded_newclosed

Dup of #12822.

Note: See TracTickets for help on using tickets.