<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>On 07/11/2022 04:58, Bob Sully wrote:<br>
</p>
<blockquote type="cite"
cite="mid:CAMicziTh+q46BDTNTEyr5hXZ9DuUHjkoWAKUnDVAOibGyz4j7Q@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr" class="gmail_signature"
data-smartmail="gmail_signature">
<div dir="ltr">
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">Hi, Stephen -</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">Following your instructions in the
previous message:[rcs@vader: ~]$ <br>
</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">sudo mysql mythconverg -p<br>
Enter password: <br>
Reading table information for completion of table and
column names<br>
You can turn off this feature to get a quicker startup
with -A<br>
...<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 2307<br>
Server version: 8.0.31-0ubuntu0.22.04.1 (Ubuntu)<br>
...<br>
mysql> drop table if exists music_albumart;<br>
Query OK, 0 rows affected, 1 warning (0.00 sec)<br>
<br>
mysql> source /home/rcs/music_albumart.sql; <--
this is what I called the dump from your database<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.01 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected, 1 warning (0.00 sec)<br>
ERROR 1813 (HY000): Tablespace
'`mythconverg`.`music_albumart`' exists.<br>
Query OK, 0 rows affected (0.00 sec)<br>
ERROR 1146 (42S02): Table 'mythconverg.music_albumart'
doesn't exist<br>
ERROR 1146 (42S02): Table 'mythconverg.music_albumart'
doesn't exist<br>
ERROR 1146 (42S02): Table 'mythconverg.music_albumart'
doesn't exist<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.01 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
Query OK, 0 rows affected (0.00 sec)<br>
mysql> \q</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">Bye</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">This didn't go according to plan.</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">The frontend did ask the question
about upgrading the schema again, which it had stopped
doing for a while.</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default"><br>
</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">However, the log shows that the
table was not re-created:</div>
<br>
</div>
<div dir="ltr">Nov 5 22:44:22 vader mythfrontend.real:
mythfrontend[2578611]: I CoreContext schemawizard.cpp:117
(Compare) Current MythTV Schema Version (DBSchemaVer): 1376<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: N CoreContext mythmainwindow.cpp:1478
(RegisterMediaPlugin) Registering Internal as a media
playback plugin.<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: A CoreContext
mediamonitor-unix.cpp:209 (CheckMountable)
MMUnix:CheckMountable: DBus interface error: The name
org.freedesktop.UDisks was not provided by any .service
files<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: W CoreContext
mediamonitor-unix.cpp:217 (CheckMountable) MMUnix:UDisks2
service found. Media Monitor does not support this yet!<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: I CoreContext mythtranslation.cpp:62
(load) Loading en_us translation for module mytharchive<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: N CoreContext mythmainwindow.cpp:1478
(RegisterMediaPlugin) Registering WebBrowser as a media
playback plugin.<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: I CoreContext mythtranslation.cpp:62
(load) Loading en_us translation for module mythbrowser<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: I CoreContext mythtranslation.cpp:62
(load) Loading en_us translation for module mythgame<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: I CoreContext schemawizard.cpp:117
(Compare) Current MythMusic Schema Version
(MusicDBSchemaVer): 1024<br>
Nov 5 22:44:23 vader mythfrontend.real:
mythfrontend[2578611]: E CoreContext dbutil.cpp:599
(DoBackup) Backing up database with script:
'/usr/share/mythtv/<a href="http://mythconverg_backup.pl"
moz-do-not-send="true">mythconverg_backup.pl</a>'<br>
Nov 5 22:44:35 vader mythfrontend.real:
mythfrontend[2578611]: C CoreContext dbutil.cpp:621
(DoBackup) Database Backup complete.<br>
Nov 5 22:44:35 vader mythfrontend.real:
mythfrontend[2578611]: C CoreContext dbutil.cpp:651
(DoBackup) Backed up database to file:
'/misc/dbbackup/mythconverg-1376-20221106054423.sql.gz'<br>
Nov 5 22:44:35 vader mythfrontend.real:
mythfrontend[2578611]: I CoreContext bonjourregister.cpp:117
(BonjourCallback) Bonjour: Service registration complete:
name 'Mythfrontend on vader' type '_mythfrontend._tcp.'
domain: 'local.'<br>
Nov 5 22:45:35 vader mythfrontend.real:
mythfrontend[2578611]: C CoreContext dbcheckcommon.cpp:119
(performActualUpdate) Upgrading to MythMusic schema version
1025<br>
Nov 5 22:45:35 vader mythfrontend.real:
mythfrontend[2578611]: E CoreContext dbcheckcommon.cpp:95
(performUpdateSeries) DB Error (Performing MythMusic
database upgrade): #012Query was: ALTER TABLE music_albumart
DEFAULT CHARACTER SET utf8; #012Error was: Driver error was
[2/1146]:#012QMYSQL: Unable to execute query#012Database
error was:#012Table 'mythconverg.music_albumart' doesn't
exist<br>
Nov 5 22:45:35 vader mythfrontend.real:
mythfrontend[2578611]: E CoreContext musicdbcheck.cpp:77
(UpgradeMusicDatabaseSchema) Database schema upgrade failed.<br>
Nov 5 22:45:35 vader mythfrontend.real:
mythfrontend[2578611]: E CoreContext main.cpp:885
(mythplugin_init) Couldn't upgrade music database schema,
exiting.<br>
Nov 5 22:45:35 vader mythfrontend.real:
mythfrontend[2578611]: E CoreContext mythplugin.cpp:140
(init_plugin) Unable to initialize plugin 'mythmusic'.</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">Scratching my head.</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">What's next?</div>
<div style="font-family:arial,sans-serif;font-size:small"
class="gmail_default">Thanks!</div>
<div dir="ltr"><b>__________________________________</b>
<div><font face="garamond, times new roman, serif"><b>Bob
Sully</b></font></div>
<div><br>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<p><br>
</p>
<p>I would try starting with a clean slate and drop all the music_*
tables, delete the MusicDBSchemaVer setting and allow MythMusic to
recreate them the next time you run the frontend. You will of
cause loose any music metadata but it sounds like any existing
data is likely corrupt anyway.</p>
<p><br>
</p>
<p>Paul H. <br>
</p>
</body>
</html>