[mythtv-users] mythweb failure on Debian testing (bookworm)

Stephen Worthington stephen_agent at jsw.gen.nz
Tue Jul 19 15:28:11 UTC 2022


On Tue, 19 Jul 2022 09:43:40 -0500, you wrote:

>On Tue, Jul 19, 2022 at 9:31 AM James Abernathy <jfabernathy at gmail.com>
>wrote:
>
>>
>>
>> On Tue, Jul 19, 2022 at 10:07 AM Greg Oliver <oliver.greg at gmail.com>
>> wrote:
>>
>>> On Tue, Jul 19, 2022 at 8:56 AM James Abernathy <jfabernathy at gmail.com>
>>> wrote:
>>>
>>>> First I have Mythtv and Mythweb working on a Debian 11 Bullseye based
>>>> system which is Linux Mint Debian Edition 5. I was experimenting if I could
>>>> do this on a newer system such as Debian Bookworm. I think I have it
>>>> working except for Mythweb.
>>>>
>>>> The big change from bullseye to bookworm is moving php from 7.4 to 8.1.
>>>> I have Mythweb working on a Ubuntu 22.04 system, which uses php 8.1 so I
>>>> expected no issues. There must be something I missed.  Below is the
>>>> error message I get in a browser:
>>>>
>>>> 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
>>>>
>>>
>>> Looks like it is just missing a table regarding MythMusic.  I am unsure
>>> if it comes with the mc.sql or if it gets added with the MythMusic plugin..?
>>>
>>
>> Interesting. I normally don't build the mythplugins. I just build mythweb.
>> In fact that is what I did on my LMDE5 system where mythtv and mythweb work
>> fine.
>>
>> I just built mythplugins on my bookworm system and rebooted. Still get the
>> same error, so it must be something unique to bookworm.  I use the same
>> script to install mythweb on all debian based systems. There's a variable
>> for the php version.
>>
>> Jim A
>>
>>
>Unsure - "Fatal error: Uncaught mysqli_sql_exception: Table
>'mythconverg.music_songs' doesn't exist" is why it is crashing.  You could
>try on both systems:
>
>mysql -u mythtv -pmythtv mythconverg -e "describe music_songs;\g"
>
>and see if they both return data.  This assumes your db u/p is mythtv

The music_* tables are created by the MythMusic plugin, which is
purely a mythfrontend plugin and will only be run if you run
mythfrontend after installing it.  Mythweb comes with all the PHP to
do the music pages, but the code probably has checks in it to see if
MythMusic is installed.


More information about the mythtv-users mailing list