[mythtv] Database schema upgrade failed. 1348 -> 1350

John Pilkington johnpilk222 at gmail.com
Thu Dec 20 16:27:47 UTC 2018


Another trap for the unwary.  rpmfusion el7 had updates today that 
couldn't be applied because mythtv and other packages required different 
versions of x265.  So I rebuilt myth, applying Gary's specfile patch to 
remove a reference to mythlogserver.  Build and installation were 
apparently ok, but a schema problem.  Reversion will be awkward because 
of the interdependencies.

I don't use HOMERUN - or x265.

Can I patch the capturecard table?  New build is 
30.Pre.1046.g687b219c1c, old was 30.Pre.1010.g98156d696b

{{{

2018-12-20 15:48:52.520335 C  Backed up database to file: 
'/home/john/SGs/MythDBbak/mythconverg-1348-20181220154805.sql.gz'
2018-12-20 15:49:31.965924 C  Upgrading to MythTV schema version 1349
2018-12-20 15:49:32.009522 E  DB Error (Performing database upgrade):
Query was: update capturecard     set 
videodevice=regexp_replace(videodevice, '-.*$', '')     where 
cardtype='HDHOMERUN'
Error was: Driver error was [2/1305]:
QMYSQL: Unable to execute query
Database error was:
FUNCTION mythconverg.regexp_replace does not exist

}}}

Thanks,

John P


More information about the mythtv-dev mailing list