<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>After update to ubuntu 19.10 / mysql 8 and adopting the php 5.2.3
fixes in master.</p>
<p>Mythweb fails on the Status Page and the initiate a recording
page with the same fault.</p>
<p>This seems identical to ticket <a
href="https://code.mythtv.org/trac/ticket/12868">https://code.mythtv.org/trac/ticket/12868
</a></p>
<p>Fixed 3 years ago.</p>
<p>I can vaguely remember having to set an option in a mysql
configuration file to allow null values and it is possible that
the update has wiped this out?<br>
</p>
<p>THe front and back ends (fixes 30) run fine.<br>
</p>
<p>*Fatal Error* at
/usr/local/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php,
line 98:</p>
!!NoTrans: SQL Error: Column 'modified' cannot be null [#1048]!!<br>
<br>
*Backtrace*:<br>
<br>
datetime: 2019-10-30 18:59:30 (GMT)<br>
errornum: 256<br>
error type: User Error<br>
error string: !!NoTrans: SQL Error: Column 'modified' cannot be
null [#1048]!!<br>
filename:
/usr/local/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php<br>
error line: 98<br>
<br>
The relevant part of the trace seems to be<br>
file: /usr/local/share/mythtv/mythweb/classes/Database.php<br>
line: 263<br>
class: Database_Query_mysqlicompat<br>
function: execute<br>
<br>
file: /usr/local/share/mythtv/mythweb/includes/session.php<br>
line: 71<br>
class: Database<br>
function: query<br>
type: -><br>
args: Array<br>
(<br>
[0] => REPLACE INTO mythweb_sessions (id, modified, data)
VALUES (?,NULL,?)<br>
[1] => 9lt6tu3r50eom2t8c00l9dhid3<br>
<br>
The same issue occurs on the screen to initiate recordings<br>
<br>
<br>
<br>
<br>
</body>
</html>