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

[TJ Harris]

On Tue, Jan 5, 2010 at 6:11 PM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> 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?

It did return a 0.  The Qt version dpkg gives is:  4.5.0-0ubuntu4.3