[mythtv-users] Mythweb Mysql 8 Ubuntu 19.10

[John]

After update to ubuntu 19.10 / mysql 8 and adopting the php 5.2.3 fixes 
in master.

Mythweb fails on the Status Page and the initiate a recording page with 
the same fault.

This seems identical to ticket https://code.mythtv.org/trac/ticket/12868

Fixed 3 years ago.

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?

THe front and back ends (fixes 30) run fine.

*Fatal Error* at 
/usr/local/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php, 
line 98:

!!NoTrans: SQL Error: Column 'modified' cannot be null [#1048]!!

*Backtrace*:

     datetime:  2019-10-30 18:59:30 (GMT)
     errornum:  256
   error type:  User Error
error string:  !!NoTrans: SQL Error: Column 'modified' cannot be null 
[#1048]!!
     filename: 
/usr/local/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php
   error line:  98

The relevant part of the trace seems to be
  file:  /usr/local/share/mythtv/mythweb/classes/Database.php
     line:  263
    class:  Database_Query_mysqlicompat
function:  execute

     file:  /usr/local/share/mythtv/mythweb/includes/session.php
     line:  71
    class:  Database
function:  query
     type:  ->
     args:  Array
(
     [0] => REPLACE INTO mythweb_sessions (id, modified, data) VALUES 
(?,NULL,?)
     [1] => 9lt6tu3r50eom2t8c00l9dhid3

The same issue occurs on the screen to initiate recordings




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20191030/75e4bc16/attachment.htm>