[mythtv-users] Myth not autoexpiring since upgrade to 0.22RC1

[Michael T. Dean]

On 10/26/2009 03:28 PM, Duncan Brown wrote:
> On 26/10/2009 19:09, Michael T. Dean wrote:
>> Please post the output of:
>>
>> mythbackend -v file --printexpire
>>
>> You've cut out some important information from the logs above, so 
>> there's not enough info to see what's happening.  You can run the 
>> above while mythbackend is running.
> Thanks for the reply 

In the interest of full disclosure, I should admit that I'm just a 
not-knowledgeable middle-man in this process.  Chris Pinkham is doing 
all the work here/deserves the thanks.

So, can you run the following and post the results:

cat << "EOF" | mysql -umythtv -p mythconverg
SELECT COUNT(*) AS 'Expirable in recorded:' FROM recorded WHERE 
autoexpire = 1;
SELECT COUNT(*) AS 'Expirable in record:' FROM record WHERE autoexpire = 1;
SELECT COUNT(*) AS 'Other in recorded:' FROM recorded WHERE autoexpire != 0;
SELECT COUNT(*) AS 'Other in record:' FROM record WHERE autoexpire != 0;
EOF

Thanks,
Mike