[mythtv] [mythtv-users] Android mythfrontend mysql driver problems

[Mark Spieth]

On 3/11/2022 9:57 am, David Engel wrote:
> On Thu, Sep 29, 2022 at 03:01:25PM +1000, Mark Spieth wrote:
>> I updated mariadb connector to 3.2.6 but I havent seen any issues with
>> recent builds. Last one I did was end of May using the previous build env
>> settings if SDK 28, NDK 21.4... and tools 29.0.3. I remember a 32 bit build
>> issue I was fixing at the time.
> Mark,
>
> I tracked down a problem I saw to mariadb connector 3.2.6.  Using the
> default, nvshield config, my resulting apk fails silently when
> deleting recordings.  By that, I mean the recording gets removed from
> the list in playbackbox but as soon as there's a refresh or
> playbackbox is re-entered, the recording is back.
>
> ENOTIME kept prventing from working on the problem a lot but I finally
> tracked it down to the query in ProgramInfo::ProgramInfo(uint
> _recordedid).  Specifically, the starttime that gets read from the
> database is empty/blank.  That leads to it being set to the current
> time in PI::clear().  Ultimately, the backend is not able to look up
> the correct recording when it gets the delete request.
>
> The problem is fixed for me by switching back to mariadb connector
> 2.3.7.
>
I have the qt date fix in my myth master tree and I havent seen the 
problem since I added that. Before that, when I deleted a program, went 
back to main menu and then back into playbox the program was still there.

Probably the same problem (timezone info in rendered datetime string)

Mark