<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 29/11/2022 4:17 am, David Engel
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:Y4TtMx5Qadr5rT4%2F@opus.istwok.net">
<pre class="moz-quote-pre" wrap="">On Mon, Nov 28, 2022 at 09:11:18AM +1100, Mark Spieth wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On 10/11/2022 9:14 am, Mark Spieth wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On 10/11/2022 3:10 am, David Engel wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On Wed, Nov 09, 2022 at 06:23:54PM +1100, Mark Spieth wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On 3/11/2022 9:57 am, David Engel wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On Thu, Sep 29, 2022 at 03:01:25PM +1000, Mark Spieth wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">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)
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">Good you could reproduce and fix it. When do you think you'll commit
it?
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
There is a PR and issue already in github for a long time. Its a myth
fix as it affects mysql as well.
<a class="moz-txt-link-freetext" href="https://github.com/MythTV/mythtv/pull/574">https://github.com/MythTV/mythtv/pull/574</a>
Its in its own branch feature/datetime-sql-bind-format-fix
I'm hesitant to merge myself unless there is a consensus. My opinion is
that its easier to fix in myth and then its fixed everywhere.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
Update on the delete issue.
I have just updated my full system(s) this weekend and can now see delete
failing again. reverting back to an android build from 6 oct also fails to
delete, and this one worked before. So the issue must live in the backend.
The linux frontend deletes fine and so does leanfront. so there is some sort
of compatability issue somewhere.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
The problem I saw is definitely a frontend issue.
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">The version of the backend that was working was built on 31 may 2022 so that
leaves a lot of search space.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
My current backend is based on c12871f5 from 2022/08/26.
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">This is with the above patch and I also tried the qt patch for the qt mysql
driver, with the same behaviour.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
It sounds like maybe the patch breaks the backend too.
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">I will look into this unless someone else has some but like david, ENOTIME.
</pre>
</blockquote>
</blockquote>
<p>I finally found some time.<br>
</p>
<p>I have fixed this issue with upgrading the mariadb connector to
3.3.3.</p>
<p>Qt remains at 5.15.6<br>
</p>
<p>I also committed a couple of other updates:</p>
<ul>
<li>mysql plugin patch from invent.kde.org which is also in the
linux source.<br>
</li>
<li>build performance improvements</li>
<li>exiv2 iconv usage update</li>
<li>minor gdb.sh update for 32bit on 64bit debugging.<br>
</li>
</ul>
<p>There was another mysql patch in the qt6 tree but I didn't
include that since it didn't make any difference to the broken
functionality that mariadb connector 3.3.3 seemed to fix.<br>
</p>
<p>Please test but it works for me for delete program.</p>
<p>Cheers</p>
<p>Mark</p>
<p><br>
</p>
</body>
</html>