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

[Duncan Brown]

On 26/10/2009 20:18, Michael T. Dean wrote:
>
> 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
The effort is much appreciated though. Been using myth for many years 
but clueless at this point!

Here's the output:


+------------------------+
| Expirable in recorded: |
+------------------------+
|                    211 |
+------------------------+
1 row in set (0.00 sec)

+----------------------+
| Expirable in record: |
+----------------------+
|                   42 |
+----------------------+
1 row in set (0.00 sec)

+--------------------+
| Other in recorded: |
+--------------------+
|                221 |
+--------------------+
1 row in set (0.00 sec)

+------------------+
| Other in record: |
+------------------+
|               42 |
+------------------+
1 row in set (0.00 sec)

cheers

Dunc