Mailing List Archive: Database schema upgrade failed. 1348 -> 1350

Database schema upgrade failed. 1348 -> 1350

Dec 20, 2018, 8:27 AM

Post #1 of 3 (491 views)

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
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: Database schema upgrade failed. 1348 -> 1350 [ In reply to ]

keemllib at gmail

Dec 20, 2018, 8:33 AM

Post #2 of 3 (491 views)

Permalink

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

--
Bill
_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: Database schema upgrade failed. 1348 -> 1350 [ In reply to ]

johnpilk222 at gmail

Dec 20, 2018, 8:41 AM

Post #3 of 3 (491 views)

Permalink

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.

_______________________________________________
mythtv-dev mailing list
mythtv-dev@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-dev
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org