[mythtv-users] find_orphans.py broken on 32 bit x86?

[Tom Dexter]

On 10/31/18, Tom Dexter <digitalaudiorock at gmail.com> wrote:
> On 10/31/18, Jonatan Lindblad <lindbladjonatan at gmail.com> wrote:
>>
>> I'm pretty sure it's the bookmarkupdate value that's the problem,
>> https://forum.mythtv.org/viewtopic.php?f=36&t=1716&start=15.
>>
>> Jonatan
>
> Bingo...that was it. Something's clearly trying to use that 0000-00-00
> 00:00:00. When I manually updated that to the CURRENT_TIMESTAMP
> find_orphans.py worked. As noted in that forum topic, it's not a
> solution...but still good to know.
>
> Thanks!
> Tom
>

It's also worth noting that setting the bookmarkupdate to null (rather
than the default of 0000-00-00 00:00:00) allows find_orphans.py to
work as well:

UPDATE recorded SET bookmarkupdate=NULL WHERE
bookmarkupdate='0000-00-00 00:00:00';

Tom