<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
On 4/10/2023 10:34 PM, Douglas Peale wrote:<br>
<blockquote type="cite"
cite="mid:335dbf16-da87-6ad8-0ba3-9765fea186f8@Comcast.net">
<table class="moz-header-part1 moz-main-header" width="100%"
cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td>
<div class="moz-header-display-name"
style="display:inline;">Subject: </div>
Re: [mythtv-users] Upgrade to Mint 21 broke mythweb</td>
</tr>
<tr>
<td>
<div class="moz-header-display-name"
style="display:inline;">From: </div>
Douglas Peale <a class="moz-txt-link-rfc2396E" href="mailto:Douglas_Peale@Comcast.net"><Douglas_Peale@Comcast.net></a></td>
</tr>
<tr>
<td>
<div class="moz-header-display-name"
style="display:inline;">Date: </div>
4/10/2023, 10:34 PM</td>
</tr>
</tbody>
</table>
<table class="moz-header-part2 moz-main-header" width="100%"
cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td>
<div class="moz-header-display-name"
style="display:inline;">To: </div>
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a></td>
</tr>
</tbody>
</table>
<br>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div class="moz-text-html" lang="x-unicode">
<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 moz-txt-link-freetext" href="mailto:mythtv-users@mythtv.org" moz-do-not-send="true">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" moz-do-not-send="true">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette" moz-do-not-send="true">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org" moz-do-not-send="true">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>
</div>
<fieldset class="moz-mime-attachment-header moz-print-only"><legend
class="moz-mime-attachment-headerName moz-print-only">Attachments:</legend></fieldset>
<div class="moz-mime-attachment-wrap moz-print-only">
<table class="moz-mime-attachment-table">
<tbody>
<tr>
<td class="moz-mime-attachment-file">OpenPGP_0x7B9B5178E6AE112A.asc</td>
<td class="moz-mime-attachment-size">2.4 KB</td>
</tr>
</tbody>
</table>
</div>
</blockquote>
<br>
You missed a step after installing the mythmusic plugin. You need to
restart mythfrontend, then the plugin will create its database
tables, and then mythweb will be happy.<br>
</body>
</html>