<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Apr 25, 2022 at 5:27 PM Paul Harrison <<a href="mailto:mythtv@mythqml.net">mythtv@mythqml.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
  
    
  
  <div>
    <p>On 25/04/2022 15:53, James wrote:<br>
    </p>
    <blockquote type="cite">
      
      <br>
      <div><br>
        <blockquote type="cite">
          <div>On 25 Apr 2022, at 10:31 pm, Paul Harrison <<a href="mailto:mythtv@mythqml.net" target="_blank">mythtv@mythqml.net</a>>
            wrote:</div>
          <br>
          <div>
            
            <p style="font-family:Helvetica;font-size:24px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none">Looks like all db errors are being treated as
              fatal on your system but not on others.</p>
            <p style="font-family:Helvetica;font-size:24px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none"><a href="https://github.com/MythTV/mythweb/blob/master/modules/music/init.php#L14" target="_blank">https://github.com/MythTV/mythweb/blob/master/modules/music/init.php#L14</a></p>
            <p style="font-family:Helvetica;font-size:24px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;text-decoration:none">It looks like that code should first disable
              fatal errors, check for the existence of the music_songs
              table and enable or disable the music module accordingly. </p>
          </div>
        </blockquote>
      </div>
      <br>
      <div>I'm not going to lose sleep but:</div>
      <div><br>
      </div>
      <div>
        <div><br>
        </div>
        <div>// First, we should check to see that MythMusic is
          configured.</div>
        <div>// Make sure to turn off fatal errors in case the
          table isn't there.</div>
        <div>    $db->disable_fatal_errors();</div>
        <div>    $has_music = $db->query_col('SELECT
          COUNT(*) FROM music_songs');</div>
        <div>    $db->enable_fatal_errors();</div>
        <div>    $db->error(false);</div>
      </div>
      <div><br>
      </div>
      <div>But I get a fatal error! maybe there's another
        check?</div>
      <div><br>
      </div>
      <div><br>
        Fatal error: Uncaught mysqli_sql_exception: Table
        'mythconverg.music_songs' doesn't exist in
        /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php:68
        Stack trace: #0
        /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php(68):
        mysqli_query() </div>
      <div><br>
      </div>
      <div>Yup</div>
      <div>James</div>
      <br>
    </blockquote>
    <p><br>
    </p>
    <p>Are you using php 8.1 or later?</p>
    <p><a href="https://php.watch/versions/8.1/mysqli-error-mode" target="_blank">https://php.watch/versions/8.1/mysqli-error-mode</a><br>
    </p>
    <p><br>
    </p>
    <p>Paul H.<br>
    </p></div></blockquote><div><br></div><div>This was already reported here (including the full stack trace):<br><a href="http://lists.mythtv.org/pipermail/mythtv-users/2022-January/408819.html">http://lists.mythtv.org/pipermail/mythtv-users/2022-January/408819.html</a><br><br></div><div>Seems to be related to php 8.1</div><div><br></div><div>Roland<br></div><div><br></div><div> <br></div></div></div>