[mythtv-users] Upgrade to Mint 21 broke mythweb

[Ian Cameron]

This has come up before.  See:
https://lists.archive.carbon60.com/mythtv/users/640572

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:
https://lists.archive.carbon60.com/mythtv/users/640577#640577

According to https://lists.archive.carbon60.com/mythtv/users/640596#640596
this is related to PHP 8.1 and later, specifically raising of exceptions on
error: https://php.watch/versions/8.1/mysqli-error-mode

A fix has been applied for this via:
https://github.com/MythTV/mythweb/pull/84 on July 20th, 2022, but I guess
it's not in the packaged version you're currently using.

Cheers, Ian


On Mon, 10 Apr 2023 at 23:13, Douglas Peale <Douglas_Peale at comcast.net>
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
>
> 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. *
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230411/4322f0a3/attachment.htm>