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

[Greg Oliver]

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