<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 4/10/23 18:38, Stephen Worthington
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:ivd93ip51eltfu5uo9489ajif3okag464o@4ax.com">
<pre class="moz-quote-pre" wrap="">On Mon, 10 Apr 2023 15:12:06 -0700, you wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On 4/10/23 14:35, Mike Hodson wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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.
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.
You just need to edit the config to match what exists now and every time you upgrade.
Mike
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">I looked in the apache2.conf file, and found that it was attempting to load everything in the /etc/apache2/mods-enabled directory.
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
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
The correct way to do this is to use the a2dismod command (with sudo)
to disable the old php module, and use a2enmod to enable the new
version. Then restart apache2. So:
sudo a2dismod php7.4
sudo a2enmod php8.1
sudo systemctl restart apache2
But that basically does exactly what you have done by changing the
links.
Updates to the php packages do not automatically do this, for some
strange reason, so you always need to do it manually every time the
php version changes.
You can use the "a2query -m" command to list the currently enabled
modules.
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">It now runs without errors.
localhost/mythweb now reports an error:
*Fatal error*: 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 */usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php* on line *68*
*I'm afraid I don't understand the error message.
*
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
That error says that mythweb thinks you have the frontend-only
mythmusic package installed (from whatever clue it uses to decide
that), so it has gone looking for the mythmusic database tables, and
has not found one of them (music_songs). You could try uninstalling
the mythmusic package and reinstalling it, then running mythfrontend
to allow it to re-create the mythmusic tables.
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
<p>running</p>
<pre class="moz-quote-pre" wrap="">sudo a2dismod php7.4</pre>
<p>it tells me it is already disabled.</p>
<p>running <br>
</p>
<pre class="moz-quote-pre" wrap="">sudo a2enmod php8.1</pre>
<p> it tells me it is already enabled.</p>
<p>Given those results, it is pointless to restart apache2.</p>
<p>mythmusic was not already installed. I installed it, and
attempting to access mythweb gets me this:</p>
<p><br>
<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>which appears to be the same error as before.</p>
<p>I was once running on the ppa, but at some point, mint switch
back to its own repositories and removed the ppa.</p>
<p>I may switch back to the ppa in the near future to use 33, but
that I will do on a day when I have nothing else to do. In past
experience it is always a fight to get mythtv working again after
re-installing it (usually due to file permissions and database
passwords since I will try to keep my old database.)</p>
<p>Part of the reason for requiring mythweb is to use the channel
editor I have three antennas, and probably 200 subchannels. I
noticed some new ATSC3.0 channels showed up, and I wanted to see
if mythTV can handle them. It has been more than a year since I
last scanned channels (an ordeal since mythTV like 45_3 format
instead of the 45.3 format that everyone else uses and I prefer,
so I have to rename all my channels, and then disable the channels
that are picked up by the back of antennas aimed elsewhere.</p>
<p>Since it has been pointed out that Mint is distributing a version
that does not have a fix needed to make this work, I will pause my
attempts to get this working until I can switch to the ppa and
version 33. That has a better chance of working with ATSC3.0
channels anyway.<br>
</p>
<p></p>
<p></p>
</body>
</html>