<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">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">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">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">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">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">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></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-yj6qo"></div><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></div></div>