[mythtv-users] DB Error (Performing database upgrade)

Ken Mandelberg km at mathcs.emory.edu
Sat Sep 23 20:33:00 UTC 2017


I'm trying to upgrade from a trunk build a while back to the current 
one. I'm on Ubuntu 16.04 and in terms of the backend is from

mythbackend version: master [v29-pre-380-g83c67a0-dirty] www.mythtv.org
   (schema 1346)

to

mythbackend version: master [v30-Pre-56-g01a3b5f-dirty] www.mythtv.org
    (schema 1347)

The build is clean, but when I start the new backend and it tries to 
update the database the log shows

  DB Error (Performing database upgrade):
Query was: Upgrading to MythTV schema version 1347
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 'Upgrading to 
MythTV schem
a version 1347' at line 1

2017-09-23 16:18:51.378318 E [21072/21072] CoreContext dbcheck.cpp:519 
(UpgradeT
VDatabaseSchema) - Database schema upgrade failed.
2017-09-23 16:18:51.378589 E [21072/21072] CoreContext 
main_helpers.cpp:571 (run
_backend) - Couldn't upgrade database to new schema

Any suggestions?



More information about the mythtv-users mailing list