Opened 9 years ago

Closed 9 years ago

#8694 closed defect (fixed)

"Custom record" or "Program Finder Rules" (record.chanid = 0) NOT displayed on "Recording Rules"

Reported by: Federico Owned by: stuartm
Priority: minor Milestone: 0.24
Component: MythTV - General Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

I use trunk revision 25416 and since revision 25187 i noticed that some "custom rules" disappeared from the "Recording Rules" list.

I mean all rules i created (or i create just now) from the Search Listing Pages, where i can make a specific search by title, keywords...and then create the Rule (it's a wonderful feature)

I miss a custom record rule too, create from the TV->Schedule Recordings->Custom Record

TV->Schedule Recordings->Search Listings/* TV->Schedule Recordings->Custom Record

Looking for those rules in the mythconverg.record table i realized all these rules have the chanid value equal to 0. If i change the value to a > 0 then the rule is showed.

Sustem is debian, with mythtv trunk revision update weekly (now rev 25416)

Attachments (3)

init.sql (486 bytes) - added by Federico <federico.ferri@…> 9 years ago.
mythconverg.record.sql (3.0 KB) - added by Federico <federico.ferri@…> 9 years ago.
fix.update.sql (46 bytes) - added by Federico <federico.ferri@…> 9 years ago.

Download all attachments as: .zip

Change History (13)

comment:1 Changed 9 years ago by Federico

this is the "mythfrontend -v database" output when i open the TV->Schedule Recordings->Recording Rules

2010-07-25 01:37:55.571 MSqlQuery::exec(DBManager0) SELECT recordid, title, chanid, starttime, startdate, type, inactive, last_record, avg_delay, profile FROM record; <<<< Returns 10 row(s)

10 is the right number including the missing rules, but on screen i see 7 rule... (i miss the 3 chanid=0)

thank you, Bye bye

comment:2 Changed 9 years ago by Federico <federico.ferri@…>

Another info: I don't use mythweb (not installed) , all my work is done with mythfrontend.

My system is: one backend + frontend
two frontends (little used..)

the broken rules are missing in every frontend (visualization) and from every frontend (creation); i created rules in two of the three frontend and the problem is always reproducible every time.

Thank you

comment:3 Changed 9 years ago by Federico <federico.ferri@…>

Two more infos.... :-)

Even if they aren't showed, the rules are active, in fact the relative programs are recorded as i can see in the conflict page or when they are actually recorded.

One of the "ghost rules" was created on january and never edited. Simply it vanished from the list in the mythfrontend (but not in the db) after an update. (i don't remember exactly to which trunk revision). After i notice this rule missing i make the other tests.

Changed 9 years ago by Federico <federico.ferri@…>

Attachment: init.sql added

comment:4 Changed 9 years ago by Federico <federico.ferri@…>

I have done a new test.

  • On a kubuntu i installed mythtv-trunk 25549
  • I create an empty mysql mythconverg schema
  • start mythtv-setup only to create the database and to set the 'General' attributes (next->next->next->...->finish)
  • the init.sql (attachment) script inserts into tables some dummy values for capturecard , cardinput and videosource (needed to start mythbackend).
  • start mythbackend
  • start mythfrontend (some upgrades for mythvideo)
  • even if there isn't any channel i create a rule from "find programs matching search words"->"title" which isn't' visible in the frontend Recordings Rule window.

thank you, federico

  • It "Became" visible if i change the record.chanid from 0 to 1 (attachment update.fix.sql)

thank you, federico

Changed 9 years ago by Federico <federico.ferri@…>

Attachment: mythconverg.record.sql added

Changed 9 years ago by Federico <federico.ferri@…>

Attachment: fix.update.sql added

comment:5 Changed 9 years ago by robertm

Owner: set to stuartm
Status: newassigned

comment:6 Changed 9 years ago by stuartm

Milestone: unknown0.24
Status: assignedaccepted
Version: UnspecifiedTrunk Head

comment:7 Changed 9 years ago by stuartm

This bug was introduced in [24694], where we started filtering out ProgramInfo? objects with a chanid of zero. I need to check with Daniel whether there was a good reason for doing that before I can decide on the best fix.

comment:8 Changed 9 years ago by stuartm

Owner: changed from stuartm to danielk
Status: acceptedassigned

comment:9 Changed 9 years ago by stuartm

Owner: changed from danielk to stuartm
Status: assignedaccepted

comment:10 Changed 9 years ago by stuartm

Resolution: fixed
Status: acceptedclosed

(In [26031]) Move the empty chanid check from RemoteUtil::RemoteGetRecordingList?() to ProgramInfoCache? (Playbackbox) where it might actually be needed. Fixes #8694

Note: See TracTickets for help on using tickets.