<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>On 19/07/2022 16:56, James Abernathy wrote:<br>
</p>
<blockquote type="cite"
cite="mid:CANFv2EkmNifY55s7HUsTp_F5ti-e3Z5wq3yYOPsraDWc=NAfnA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Jul 19, 2022 at
11:42 AM Greg Oliver <<a
href="mailto:oliver.greg@gmail.com" moz-do-not-send="true"
class="moz-txt-link-freetext">oliver.greg@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Jul 19, 2022
at 10:35 AM James Abernathy <<a
href="mailto:jfabernathy@gmail.com" target="_blank"
moz-do-not-send="true" class="moz-txt-link-freetext">jfabernathy@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px
0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, Jul 19,
2022 at 10:44 AM Greg Oliver <<a
href="mailto:oliver.greg@gmail.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">oliver.greg@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px
0px 0px 0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue,
Jul 19, 2022 at 9:31 AM James Abernathy
<<a href="mailto:jfabernathy@gmail.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">jfabernathy@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On
Tue, Jul 19, 2022 at 10:07 AM Greg
Oliver <<a
href="mailto:oliver.greg@gmail.com"
target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">oliver.greg@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div class="gmail_quote">
<div dir="ltr"
class="gmail_attr">On Tue, Jul
19, 2022 at 8:56 AM James
Abernathy <<a
href="mailto:jfabernathy@gmail.com"
target="_blank"
moz-do-not-send="true"
class="moz-txt-link-freetext">jfabernathy@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote"
style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">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.
<div><br>
</div>
<div>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:</div>
<div><br>
</div>
<div>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<br>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>
<div
style="font-family:monospace,monospace">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..?</div>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Jim A</div>
</div>
</div>
<br>
</blockquote>
<div><br>
</div>
<div style="font-family:monospace,monospace">Unsure
- "<span>Fatal error: Uncaught
mysqli_sql_exception: Table
'mythconverg.music_songs' doesn't exist"</span>
is why it is crashing. You could try on
both systems:</div>
<div style="font-family:monospace,monospace"><br>
</div>
<div style="font-family:monospace,monospace">mysql
-u mythtv -pmythtv mythconverg -e
"describe <span>music_songs;\g"</span></div>
<div style="font-family:monospace,monospace"><span><br>
</span></div>
<div style="font-family:monospace,monospace"><span>and
see if they both return data. This
assumes your db u/p is mythtv<br>
</span></div>
</div>
</div>
<br>
</blockquote>
<div><br>
</div>
<div>I get the same results on both systems:</div>
<div><br>
</div>
im@den-pc:~$ mysql -u mythtv -pmythtv mythconverg
-e "describe music_songs;\g"<br>
ERROR 1146 (42S02) at line 1: Table
'mythconverg.music_songs' doesn't exist<br>
<div><br>
</div>
<div>Jim <span class="gmail_default"
style="font-family:monospace,monospace">A</span></div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div style="font-family:monospace,monospace">Sounds like
some sort of packaging issue if MythWeb should have
checks for the plugin, but is fatally erroring out
when it is not installed...?</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>Okay, here's what I found. On the VM for bookworm, I
built mythplugins and when I tried to use it I got the
message about no Music Group setup. Then I remembered that
I only setup the storage for recording(default) and
DB_backup. When I tried to run mythtv-setup, I got an
immediate seg fault. So I rebooted the VM and then I could
setup the storage directories for Music and Musicart with
mythtv-setup. The in mythfrontend I could scan for music,
even though there was none, but it setup the database and
Mythweb now works. Output of mysql below from Bookworm VM.</div>
mysql -u mythtv -pmythtv mythconverg -e "describe
music_songs;\g"<br>
+-----------------+----------------------+------+-----+---------+----------------+<br>
| Field | Type | Null | Key |
Default | Extra |<br>
+-----------------+----------------------+------+-----+---------+----------------+<br>
| song_id | int(11) unsigned | NO | PRI | NULL
| auto_increment |<br>
| filename | text | NO | | NULL
| |<br>
| name | varchar(255) | NO | MUL |
| |<br>
| track | smallint(6) unsigned | NO | | 0
| |<br>
| artist_id | int(11) unsigned | NO | MUL | 0
| |<br>
| album_id | int(11) unsigned | NO | MUL | 0
| |<br>
| genre_id | int(11) unsigned | NO | MUL | 0
| |<br>
| year | smallint(6) | NO | | 0
| |<br>
| length | int(11) unsigned | NO | | 0
| |<br>
| numplays | int(11) unsigned | NO | | 0
| |<br>
| rating | tinyint(4) unsigned | NO | | 0
| |<br>
| lastplay | datetime | YES | | NULL
| |<br>
| date_entered | datetime | YES | | NULL
| |<br>
| date_modified | datetime | YES | | NULL
| |<br>
| format | varchar(4) | NO | | 0
| |<br>
| mythdigest | varchar(255) | YES | MUL | NULL
| |<br>
| size | bigint(20) unsigned | YES | | NULL
| |<br>
| description | varchar(255) | YES | | NULL
| |<br>
| comment | varchar(255) | YES | | NULL
| |<br>
| disc_count | smallint(5) unsigned | YES | | 0
| |<br>
| disc_number | smallint(5) unsigned | YES | | 0
| |<br>
| track_count | smallint(5) unsigned | YES | | 0
| |<br>
| start_time | int(10) unsigned | YES | | 0
| |<br>
| stop_time | int(10) unsigned | YES | | NULL
| |<br>
| eq_preset | varchar(255) | YES | | NULL
| |<br>
| relative_volume | tinyint(4) | YES | | 0
| |<br>
| sample_rate | int(10) unsigned | YES | | 0
| |<br>
| bitrate | int(10) unsigned | YES | | 0
| |<br>
| bpm | smallint(5) unsigned | YES | | NULL
| |<br>
| directory_id | int(20) | NO | MUL | 0
| |<br>
| hostname | varchar(255) | NO | |
| |<br>
+-----------------+----------------------+------+-----+---------+----------------+<br>
jim@debian-testing:~$
<div class="gmail-adL"><br>
</div>
<div class="gmail-adL">Not sure why it worked on my real LMDE5
system, except that all those directories exist even though
I don't have the mythplugins built?</div>
<div class="gmail-adL"><br>
</div>
<div class="gmail-adL">Jim A</div>
<div class="gmail-adL"><br>
</div>
</div>
</div>
<br>
</blockquote>
<p><br>
</p>
<p>It's a change in behavior in PHP 8.1</p>
<p><a class="moz-txt-link-freetext" href="https://lists.archive.carbon60.com/mythtv/users/640729#640729">https://lists.archive.carbon60.com/mythtv/users/640729#640729</a><br>
</p>
<p><br>
</p>
<p>Paul H.<br>
</p>
</body>
</html>