[mythtv-users] Cannot delete some recorded programs after upgrading to 0.22-fixes

[Michael T. Dean]

On 01/05/2010 12:44 PM, TJ Harris wrote:
> I got a couple private e-mails from others seeing this behvaior, but
> no solutions.
> I did some more debugging on this, to try and isolate the problem.
>
> - It's not just a problem deleting, it also effects other things like
> generating preview images for recordings.   But, it does not effect
> playback of recordings.
>
> - The debug messages point to a problem with a SQL query to retrieve
> the program info.  I grabbed the SQL query from the debug output, and
> tried it by hand and it worked for me.  It returned the right recorded
> program record and the file referenced in that record did exist on
> disk.
>
> - I also ran one of the failing commands (mythbackend to generate
> preview image) with strace and found the same thing, the SQL query
> appeared to be succeeding, but the debug output said it failed.   It
> never tried to access the video file on disk (supporting the fact that
> it thought the SQL query failed)
>   

Can you do:

mysql -umythtv -p mythconverg -e "SELECT count(*) FROM recorded WHERE
bookmark > 1;"

If that gives you a 0, then what version of Qt are you using?

Mike