[mythtv-users] Upgrade errors, (Was: Moved to Intel NUC - no sound & IR receiver needed)

[Simon Hobson]

Iwrote:

>> 2020-03-09 19:26:05.574173 C  Upgrading to MythTV schema version 1277
>> 2020-03-09 19:26:05.635809 E  DB Error (Performing database upgrade): 
>> Query was: INSERT INTO recordfilter (filterid, description, clause, newruledefault)     VALUES (0, 'New episode', 'program.previouslyshown = 0', 0); 
>> Error was: Driver error was [2/1062]:
>> QMYSQL: Unable to execute query
>> Database error was:
>> Duplicate entry '0' for key 'PRIMARY'

Hmmm ...
Tried again, and it sailed past that step, threw another error (but carried on) :
> 2020-03-09 21:28:10.813905 C  Upgrading to MythTV schema version 1302
> 2020-03-09 21:28:10.918829 E  DB Error (GetRecgroupString()):
> Query was:
> SELECT recgroup FROM recgroups WHERE recgroupid = 1
> Bindings were:
> :RECGROUPID=1
> Driver error was [2/1146]:
> QMYSQL: Unable to execute query
> Database error was:
> Table 'mythconverg.recgroups' doesn't exist
> 
> 2020-03-09 21:28:10.919694 E  DB Error (UPDATE/INSERT record):
> Query was:
> INSERT INTO record SET type = 11, search = 0, recpriority = 0, prefinput = 0, startoffset = 5, endoffset = 10, dupmethod = 8, dupin = 15, filter = 0, inactive = 0, profile = 'Default', recgroup = '', recgroupid = 1, storagegroup = 'Default', playgroup = 'Default', autoexpire = 1, maxepisodes = 0, maxnewest = 0, autocommflag = 1, autotranscode = 0, transcoder = 0, autouserjob1 = 0, autouserjob2 = 0, autouserjob3 = 0, autouserjob4 = 0, autometadata = 1, parentid = 0, title = 'Default (Template)', subtitle = '', season = 0, episode = 0, description = '', category = 'Default', starttime = '21:28:10', startdate = '2020-03-09', endtime = '21:28:10', enddate = '2020-03-09', seriesid = '', programid = '', inetref = '', chanid = 0, station = '', findday = 0, findtime = '00:00:00', findid = 737858, next_record = NULL, last_record = NULL, last_delete = NULL, avg_delay = 100 ;
> Bindings were:
> :AUTOCOMMFLAG=true, :AUTOEXPIRE=true, :AUTOMETADATA=true, :AUTOTRANSCODE=false,
> :AUTOUSERJOB1=false, :AUTOUSERJOB2=false, :AUTOUSERJOB3=false,
> :AUTOUSERJOB4=false, :AVGDELAY=100, :CATEGORY="Default", :CHANID=0,
> :DESCRIPTION="", :DUPIN=15, :DUPMETHOD=8, :ENDDATE=2020-03-09, :ENDOFFSET=10,
> :ENDTIME=21:28:10, :EPISODE=0, :FILTER=0, :FINDDAY=0, :FINDID=737858,
> :FINDTIME=00:00:00, :INACTIVE=false, :INETREF="", :INPUT=0, :LASTDELETE=NULL,
> :LASTREC=NULL, :MAXEPISODES=0, :MAXNEWEST=false, :NEXTREC=NULL, :PARENTID=0,
> :PLAYGROUP="Default", :PROGRAMID="", :RECGROUP="", :RECGROUPID=1, :RECPRIORITY=0,
> :RECPROFILE="Default", :SEARCHTYPE=0, :SEASON=0, :SERIESID="",
> :STARTDATE=2020-03-09, :STARTOFFSET=5, :STARTTIME=21:28:10, :STATION="",
> :STORAGEGROUP="Default", :SUBTITLE="", :TITLE="Default (Template)",
> :TRANSCODER=0, :TYPE=11
> Driver error was [2/1054]:
> QMYSQL: Unable to execute query
> Database error was:
> Unknown column 'recgroupid' in 'field list'
> 
> 2020-03-09 21:28:10.921111 C  Upgrading to MythTV schema version 1303



Then it stopped at :
> 2020-03-09 21:29:29.283836 C  Upgrading to MythTV schema version 1347
> 2020-03-09 21:29:29.284005 E  DB Error (Performing database upgrade): 
> Query was: Г�/V 
> 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 MariaDB server version for the right syntax to use near 'Г�/V' at line 1

Very odd !

Simon