[mythtv-users] Database fails to upgrade

[Paul Harrison]

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).

Paul H.