DB Upgrade fails on fresh install
Posted: Fri May 07, 2021 9:24 pm
Hello,
I've just installed myth on a freshly built Xubuntu 20.04 LTS box after which I installed "mythtv" followed by "mythmusic" (last time I installed myth I'm sure mythmusic was installed by default ?). Obviously I did this via:
Following this whenever I try to run the front end it keeps wanting to upgrade the schema for the "music" plugin from 1015 to 1024. I therefore click the "Upgrade" button but it fails. When I run "mythfrontend" from a command line I can see there's a SQL syntax error message being output:
As this is a completely fresh install, onto a new blank HD, using only a Xubuntu live CD followed by "sudo apt-get" I've not tried to do much troubleshootig myself - it might be more useful for a developer to find what the actual bug is if I don't add to it by attempting to fix it myself
All advice gratefully received.
I've just installed myth on a freshly built Xubuntu 20.04 LTS box after which I installed "mythtv" followed by "mythmusic" (last time I installed myth I'm sure mythmusic was installed by default ?). Obviously I did this via:
Code: Select all
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install mythtv
sudo apt-get install mythmusic
Code: Select all
2021-05-07 21:52:33.731347 N Upgrading to MythMusic schema version 1016
2021-05-07 21:52:33.785167 E DB Error (Performing database upgrade):
Query was: ALTER TABLE music_albumart DEFAULT CHARACTER SET default, MODIFY filename varchar(255) CHARACTER SET utf8 NOT NULL default '';
Error was: Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default, MODIFY filename varchar(255) CHARACTER SET utf8 NOT NULL default ''' at line 1
new version: 1016
2021-05-07 21:52:33.785194 E Database schema upgrade failed.
2021-05-07 21:52:33.785527 E Couldn't upgrade music database schema, exiting.
2021-05-07 21:52:33.785551 E Unable to initialize plugin 'mythmusic'.
All advice gratefully received.