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

[James Abernathy]

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