[mythtv] Database schema upgrade failed. 1348 -> 1350
keemllib at gmail.com
Thu Dec 20 16:33:42 UTC 2018
On 12/20/18 10:27 AM, John Pilkington wrote:
> 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
Fix committed 40 minutes ago. v30-Pre-1047-gaea1635b95
More information about the mythtv-dev