[mythtv-users] Database upgrade fails - 1300 to 1301 - Table 'iptv_channel' already exists

[Per Jessen]

Stephen Worthington wrote:

> On Tue, 17 Dec 2019 17:16:45 +0100, you wrote:
> 
>> I am migrating a 0.25 system to 0.29, with a new database machine.  I
>> have restored a database backup to the new db machine, and I
>> start "mythsetup" on a new backend machine.  Look like schema 1299 to
>> 1300 works fine, but then it fails doing 1300 to 1301 ?
>>
>> For restoring the 0.25 backup to the new database machine, I did not
>> use the mythconverg_restore script, is that important?  Did I skip
>> something?
> 
> Have you checked all the release notes for the versions from 0.25 to
> 0.29?  I think there is a manual change you need to do for the
> timezones in the database - that could be causing problems.  What was
> the exact error message you got?

Admittedly, I have not checked the release notes ...  I did however load
the timezone definitions.  They go into "mysql". 

The exact error really is:  Table 'iptv_channel' already exists. 

Anyway, I have started over - restored my 0.25 database dump to the new
database machine and started up "mythtvsetup".  Sofar it has reached
schema 1304. 

Got another error, but it didn't stop:

2019-12-18 09:13:59.548440 C  Upgrading to MythTV schema version 1302
2019-12-18 09:13:59.710013 E  DB Error (UPDATE/INSERT record):
Query was:
INSERT INTO record SET type = 11, search = 0, recpriority = 0, prefinput
= 0, startoffset = 5, endoffset = 5, dupmethod = 8, dupin = 15, filter
= 0, inactive = 0, profile = 'Default', recgroup = 'Default',
recgroupid = 1, storagegroup = 'Default', playgroup = 'Default',
autoexpire = 1, maxepisodes = 0, maxnewest = 0, autocommflag = 0,
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 = '08:13:59',
startdate = '2019-12-18', endtime = '08:13:59', enddate = '2019-12-18',
seriesid = '', programid = '', inetref = '', chanid = 0, station = '',
findday = 0, findtime = '00:00:00', findid = 737776, next_record =
NULL, last_record = NULL, last_delete = NULL, avg_delay = 100 ;
Bindings were:
:AUTOCOMMFLAG=false, :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=2019-12-18, :ENDOFFSET=5,
:ENDTIME=08:13:59, :EPISODE=0, :FILTER=0, :FINDDAY=0, :FINDID=737776,
: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="Default", :RECGROUPID=1,
:RECPRIORITY=0, :RECPROFILE="Default", :SEARCHTYPE=0, :SEASON=0, :SERIESID="",
:STARTDATE=2019-12-18, :STARTOFFSET=5, :STARTTIME=08:13:59, :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'

2019-12-18 09:13:59.712719 C  Upgrading to MythTV schema version 1303
2019-12-18 09:14:18.247574 C  Upgrading to MythTV schema version 1304



-- 
Per Jessen, Zürich (9.0°C)