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

[James Abernathy]

On Tue, Jul 19, 2022 at 10:44 AM Greg Oliver <oliver.greg at gmail.com> 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
>
>
I get the same results on both systems:

im at den-pc:~$ mysql -u mythtv -pmythtv mythconverg -e "describe
music_songs;\g"
ERROR 1146 (42S02) at line 1: Table 'mythconverg.music_songs' doesn't exist

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220719/7d1a7d92/attachment.htm>