<div dir="ltr"><div class="gmail_default" style="font-size:small">This has come up before. See: <a href="https://lists.archive.carbon60.com/mythtv/users/640572">https://lists.archive.carbon60.com/mythtv/users/640572</a></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">A solution seems to be to install the MythMusic plugin - temporarily at least if you have no use for it - on a front end and run it up so that it generates the table(s) required. See: <a href="https://lists.archive.carbon60.com/mythtv/users/640577#640577">https://lists.archive.carbon60.com/mythtv/users/640577#640577</a></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">According to <a href="https://lists.archive.carbon60.com/mythtv/users/640596#640596">https://lists.archive.carbon60.com/mythtv/users/640596#640596</a> this is related to PHP 8.1 and later, specifically raising of exceptions on error: <a href="https://php.watch/versions/8.1/mysqli-error-mode">https://php.watch/versions/8.1/mysqli-error-mode</a></div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">A fix has been applied for this via: <a href="https://github.com/MythTV/mythweb/pull/84">https://github.com/MythTV/mythweb/pull/84</a> on July 20th, 2022, but I guess it's not in the packaged version you're currently using.</div><div class="gmail_default" style="font-size:small"><br></div><div class="gmail_default" style="font-size:small">Cheers, Ian</div><div class="gmail_default" style="font-size:small"><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, 10 Apr 2023 at 23:13, Douglas Peale <<a href="mailto:Douglas_Peale@comcast.net">Douglas_Peale@comcast.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>
<div>On 4/10/23 14:35, Mike Hodson wrote:<br>
</div>
<blockquote type="cite">
<div dir="auto">
<div>You should just need to change the config to actually match
the version of PHP installed which is no longer the old one
your old config had in it.
<div dir="auto"><br>
</div>
<div dir="auto">Go looking through /use/lib/apache2/modules/
directory on your system, look and see if there's a PHP
library in there. There should be, and likely be a newer
version than 7.4. </div>
<div dir="auto"><br>
</div>
<div dir="auto">You just need to edit the config to match what
exists now and every time you upgrade.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Mike</div>
<div dir="auto"><br>
</div>
<div dir="auto"><br>
</div>
<br>
</div>
</div>
<br>
</blockquote>
<p>I looked in the apache2.conf file, and found that it was
attempting to load everything in the /etc/apache2/mods-enabled
directory.</p>
<p>Looking in that directory, I found both php7.4 and php8.1 . Since
files in this directory are just soft links to files in
mods-enabled with the same names, I deleted the php7.4 files, and
restarted apache2</p>
<p>It now runs without errors.</p>
<p>localhost/mythweb now reports an error:</p>
<p><b>Fatal error</b>: Uncaught mysqli_sql_exception: Table
'mythconverg.music_songs' doesn't exist in
/usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php:68
Stack trace:
#0
/usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php(68):
mysqli_query()
#1 /usr/share/mythtv/mythweb/classes/Database.php(263):
Database_Query_mysqlicompat->execute()
#2 /usr/share/mythtv/mythweb/classes/Database.php(326):
Database->query()
#3 /usr/share/mythtv/mythweb/modules/music/init.php(15):
Database->query_col()
#4 /usr/share/mythtv/mythweb/classes/Modules.php(30):
require_once('...')
#5 /usr/share/mythtv/mythweb/classes/Modules.php(50):
Modules::load()
#6 /usr/share/mythtv/mythweb/mythweb.php(30): Modules::getModule()
#7 {main} thrown in <b>/usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php</b>
on line <b>68</b></p>
<p><b>I'm afraid I don't understand the error message.<br>
</b></p>
</div>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>