[mythtv-users] Upgrade to Mint 21 broke mythweb

faginbagin helen.buus at gmail.com
Tue Apr 11 15:53:12 UTC 2023


On 4/10/2023 10:34 PM, Douglas Peale wrote:
> Subject:
> Re: [mythtv-users] Upgrade to Mint 21 broke mythweb
> From:
> Douglas Peale <Douglas_Peale at Comcast.net>
> Date:
> 4/10/2023, 10:34 PM
>
> To:
> mythtv-users at mythtv.org
>
>
> 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 at 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.
>
> Attachments:
>
> OpenPGP_0x7B9B5178E6AE112A.asc 	2.4 KB
>

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230411/ae4cfe68/attachment.htm>


More information about the mythtv-users mailing list