On 4/10/23 18:38, Stephen Worthington wrote:
> On Mon, 10 Apr 2023 15:12:06 -0700, you wrote:
>
>> On 4/10/23 14:35, Mike Hodson wrote:
>>> 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
>>>
>>>
>>>
>>>
>> 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
> 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.
>
>> 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.
>> *
> 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
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums:https://forum.mythtv.org
running
sudo a2dismod php7.4
it tells me it is already disabled.
running
sudo a2enmod php8.1
it tells me it is already enabled.
Given those results, it is pointless to restart apache2.
mythmusic was not already installed. I installed it, and attempting to access mythweb gets me this:
*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*
which appears to be the same error as before.
I was once running on the ppa, but at some point, mint switch back to its own repositories and removed the ppa.
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.)
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.
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.