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

John Pilkington johnpilk222 at gmail.com
Thu Dec 20 16:41:57 UTC 2018


On 20/12/2018 16:33, Bill Meek wrote:
> 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
> 
Thanks Bill!  Restarting the build.



More information about the mythtv-dev mailing list