[mythtv-users] Upgrade to Mint 21 broke mythweb

[Douglas Peale]

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

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.
*

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230410/cad57e3f/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0x7B9B5178E6AE112A.asc
Type: application/pgp-keys
Size: 2452 bytes
Desc: OpenPGP public key
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230410/cad57e3f/attachment-0001.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 203 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230410/cad57e3f/attachment-0001.sig>