[mythtv-users] MythWeb Recording Schedule

[Michael T. Dean]

(left broken quoting by broken Microsoft MUA because I have no clue 
which quotes go to which level--only fixed the part I wrote)

On 06/26/2012 09:42 AM, Scott and Nicole Harris wrote:
>>>>>>>> Am I going blind, or has MythWeb’s ability to set filters for
>>>>>>>> recordings (New Episodes Only, etc) disappeared? I see a “Filters”
>>>>>>>> section with checkboxes for “This Episode” / “This Series”. Checking
>>>>>>>> them
>>>>>>>> does not open any further options, so I really have no idea what it
>>>>>>>> is they do.
>>>>>>> In 0.25, the drop down filter list was replaced with the check boxes
>>>>>>> you mention. To replicate previous behaviour, just tick "New episode"
>>>>>>> and "Identifiable episode". Can't remember what the
>>>>>>>>>> corresponding wording was in the drop down
>>>>>> There are no such checkboxes. There are two checkboxes in “Filters”....”This
>>>>>> Episode”, “This Series”
>>>>> Weird, I have 8 options under filters. Don't know if this list varies
>>>>> depending on the type of programme you are trying to record, can't say I
>>>>> have noticed any differences.
>>>>> What programme is it? Where in the world are you? I can try and
>>>>> replicate
>>>> I'm in the USA. It's all my programs, name one...The Big Bang Theory,
>>>> The Office, NCIS...all of them. Would it help if included sections of
>>>> code from any files for you to compare?
>>>>
>>> Sounds like your database is messed up--possibly a broken (probably by
>>> interruption) upgrade?
>>>
>>> What do you get for:
>>>
>>> mysql -umythtv -p mythconverg -e 'SELECT * FROM recordfilter;"
>>>
>>> and did you encounter any difficulties with upgrade or have any theories
>>> how your database could have been broken?
>> It returns only those two rows (this series, this episode). I did have some
>> issues upgrading. Is there a list of the rules, so I can manually put them
>> in?
> I installed mythtv-database on another machine and manually inserted the details from the 8 filters from that fresh db to my db on my backend.  I checked each of the boxes on mythweb for a recording rule and checked the "filter" field in the record table and they were updated each time.  Appears to be a bit flag (1,2,4,8,16,32,64,128).

You completely missed a very important DB upgrade (and who knows what 
else went wrong), meaning your entire schema and data is suspect.  If I 
were you, I'd seriously consider a partial restore to fix the schema and 
throw away all non-re-creatable data (meaning any re-created data will 
be valid)--because you may not realize what else is broken until it's 
too late.

http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup

Mike