[mythtv-users] Database fails to upgrade
mythtv at sky.com
Sun Oct 15 09:11:41 UTC 2017
On 15/10/17 05:16, David Highley wrote:
> After upgrading to Mythtv version 29 via rpmfusion packages for Fedora
> the backend will not run because the database upgrade is failing with a
> log message about invalid sql. From the log file below:
> 2017-10-13 03:45:08.076380 C [16990/16990] CoreContext dbcheck.cpp:437 (performActualUpdate) - Upgrading to MythTV schema version 1347
> 2017-10-13 03:45:08.076484 E [16990/16990] CoreContext dbcheck.cpp:411 (performUpdateSeries) - DB Error (Performing database upgrade):
> Query was: @ï¿½^F^B
> 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 MariaDB server version for the right syntax to use near '@ï¿½^F^B' at line 1
> 2017-10-13 03:45:08.076490 E [16990/16990] CoreContext dbcheck.cpp:519 (UpgradeTVDatabaseSchema) - Database schema upgrade failed.
> 2017-10-13 03:45:08.076671 E [16990/16990] CoreContext main_helpers.cpp:571 (run_backend) - Couldn't upgrade database to new schema
The query looks very strange!
Try shutting the backend down then run 'mythtv-setup -v database:debug'
(you may have to ensure you use the same user the backend uses so it
picks up the correct config.xml). Hopefully that will narrow down which
query that is (there are a few in the 1347 update).
More information about the mythtv-users