Opened 8 years ago

Closed 4 years ago

#12887 closed Bug Report - General (Unverified)

Billing order is lost in the credits table

Reported by: mythtv@… Owned by:
Priority: minor Milestone: unknown
Component: MythTV - General Version: 0.28.0
Severity: medium Keywords:
Cc: Ticket locked: no

Description

There is no way to order the list of actors in a program to reflect the billing order. I use tv_grab_sd_json and the XML it produces has the actors in billing order but the process of adding them to the credits table removes the order. You can see this clearly in mythweb, just pick any movie.

As a work-around for my purposes I have added a column to credits thus:

alter table credits add column localrank int auto_increment primary key;

I'm not proposing this as the solution but it works for me as the XML from the grabber has the actors in billing order and mythfilldatabase adds them to the credits table in that order. I can get the starts with this query:

select name from credits, people where credits.person = people.person and chanid = CCCC and starttime = SSSS and role = 'actor' order by localrank limit 5;

I don't know what the best solution would be, possibly a rank column (tinyint) and have mythfilldatabase use a counter that increments for every addition to the credits table but the EIT processor would have to be changed too and I don't have a clue what that does. Finally the frontend and mythweb would have to be changed to use the rank.

Change History (1)

comment:1 Changed 4 years ago by Stuart Auchterlonie

Resolution: Unverified
Status: newclosed

Closing all old tickets in trac.

If your issue still persists, please open an issue in Github https://github.com/MythTV/mythtv/issues

and reference the existing trac ticket.

Note: See TracTickets for help on using tickets.