[mythtv-users] Incompatible versions

Thu Nov 24 17:26:12 UTC 2022

Hi All,

I wonder if someone can give me a pointer here. I have a friend with a 
0.32 installation on a Rocky Linux host.

If I configure it with its capture cards as a completely new system all 
works well.

But, if I migrate the database from his old 0.25 system, using 
mythconverg_restore.pl to restore the database and also change the 
hostname I get this error from MythWeb ->

User Notice at /usr/share/mythtv/bindings/php/MythBackend.php, line 109:
!!NoTrans: Incompatible protocol version (mythweb=91, backend=72)!!

User Notice at /usr/share/mythtv/bindings/php/MythBackend.php, line 133:
!!NoTrans: Failed to set php timezone to !!

If I restore the mysqldump I made of the database prior to the restore 
of the 0.25 database all returns to normal.

The upgrade process produced logs and errors like this:-

2022-11-24 17:10:58.227785 I [37019/37019] CoreContext 
schemawizard.cpp:119:Compare  Current MythTV Schema Version 
(DBSchemaVer): 1299
2022-11-24 17:10:58.237949 E [37019/37019] CoreContext 
storagegroup.cpp:696:FindNextDirMostFree  SG(Default): 
FindNextDirMostFree: '/media/store3/store' does not exist!
2022-11-24 17:10:58.237962 E [37019/37019] CoreContext 
storagegroup.cpp:696:FindNextDirMostFree  SG(Default): 
FindNextDirMostFree: '/mnt/store0/store' does not exist!
2022-11-24 17:10:58.237970 E [37019/37019] CoreContext 
storagegroup.cpp:696:FindNextDirMostFree  SG(Default): 
FindNextDirMostFree: '/mnt/store1/store' does not exist!
2022-11-24 17:10:58.237977 E [37019/37019] CoreContext 
storagegroup.cpp:696:FindNextDirMostFree  SG(Default): 
FindNextDirMostFree: '/mnt/store2/store' does not exist!
2022-11-24 17:10:58.239599 E [37019/37019] CoreContext 
dbutil.cpp:600:DoBackup  Backing up database with script: 
'/usr/share/mythtv/mythconverg_backup.pl'
2022-11-24 17:11:22.803018 C [37019/37019] CoreContext 
dbutil.cpp:621:DoBackup  Database Backup complete.
2022-11-24 17:11:22.803724 C [37019/37019] CoreContext 
dbutil.cpp:652:DoBackup  Backed up database to file: 
'/tmp/mythconverg-1299-20221124171058.sql.gz'
2022-11-24 17:11:22.846105 I [37019/37019] CoreContext 
mythcommandlineparser.cpp:2920:operator()  Qt: QXcbConnection: XCB 
error: 1 (BadRequest), sequence: 417, resource id: 1363, major code: 155 
(Unknown), minor code: 1
2022-11-24 17:12:41.845299 C [37019/37019] CoreContext 
dbcheckcommon.cpp:120:performActualUpdate  Upgrading to MythTV schema 
version 1300
2022-11-24 17:12:41.852326 C [37019/37019] CoreContext 
dbcheckcommon.cpp:120:performActualUpdate  Upgrading to MythTV schema 
version 1301
2022-11-24 17:12:41.868098 C [37019/37019] CoreContext 
dbcheck.cpp:1966:doUpgradeTVDatabaseSchema  Upgrading to MythTV schema 
version 1302
2022-11-24 17:12:41.883707 E [37019/37019] CoreContext 
mythdb.cpp:229:DBError  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

2022-11-24 17:12:41.884502 E [37019/37019] CoreContext 
mythdb.cpp:229:DBError  DB Error (UPDATE/INSERT record):
Query was:
INSERT INTO record SET type = 11, search = 0, recpriority = 0, prefinput 
= 0, startoffset = 0, endoffset = 0, dupmethod = 8, dupin = 15, filter = 
0, autoextend = 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 = '17:12:41', 
startdate = '2022-11-24', endtime = '17:12:41', enddate = '2022-11-24', 
seriesid = '', programid = '', inetref = '', chanid = 0, station = '', 
findday = 0, findtime = '00:00:00', findid = 738848, next_record = NULL, 
last_record = NULL, last_delete = NULL, avg_delay = 100 ;
Bindings were:
:AUTOCOMMFLAG=true, :AUTOEXPIRE=true, :AUTOEXTEND=0, :AUTOMETADATA=true,
:AUTOTRANSCODE=false, :AUTOUSERJOB1=false, :AUTOUSERJOB2=false,
:AUTOUSERJOB3=false, :AUTOUSERJOB4=false, :AVGDELAY=100, 
:CATEGORY="Default",
:CHANID=0, :DESCRIPTION="", :DUPIN=15, :DUPMETHOD=8, :ENDDATE=2022-11-24,
:ENDOFFSET=0, :ENDTIME=17:12:41.868, :EPISODE=0, :FILTER=0, :FINDDAY=0,
:FINDID=738848, :FINDTIME=00:00:00.000, :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=2022-11-24, :STARTOFFSET=0, :STARTTIME=17:12:41.868, :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 'autoextend' in 'field list'

I know about the store errors and will create the right folders for it, 
but later in the process there are many errors like this.....

2022-11-24 16:35:11.817658 E [35594/35594] CoreContext 
mythdb.cpp:229:DBError  DB Error (LoadProgramFromRecorded):
Query was:
SELECT r.title,            r.subtitle,     r.description, 
r.season,           r.episode,      r.category, r.chanid,           
c.channum,      c.callsign, c.name,             
c.outputfilters,r.recgroup, r.playgroup,        r.storagegroup, 
r.basename, r.hostname,         r.recpriority,  r.seriesid, 
r.programid,        r.inetref,      r.filesize, r.progstart,        
r.progend,      r.stars, r.starttime,        r.endtime,      
p.airdate+0, r.originalairdate,  r.lastmodified, r.recordid, 
c.commmethod,       r.commflagged,  r.previouslyshown, 
r.transcoder,       r.transcoded,   r.deletepending, r.preserve,         
r.cutlist,      r.autoexpire, r.editing,          r.bookmark,     
r.watched, p.audioprop+0,      p.videoprop+0,  p.subtitletypes+0, 
r.findid,           rec.dupin,      rec.dupmethod, 
p.syndicatedepisodenumber, p.partnumber, p.parttotal, 
p.season,           p.episode,      p.totalepisodes, p.category_type,    
r.recordedid,   r.inputname, r.bookmarkupdate,   
r.lastplay                         FROM recorded AS r LEFT JOIN channel 
AS c ON (r.chanid    = c.chanid) LEFT JOIN recordedprogram AS p ON 
(r.chanid    = p.chanid AND     r.progstart = p.starttime) LEFT JOIN 
record AS rec ON (r.recordid = rec.recordid) WHERE r.chanid    = 15220 
AND       r.starttime = '2020-11-24T21:00:00Z'
Bindings were:
:CHANID=15220, :RECSTARTTS=2020-11-24T21:00:00.000Z
Driver error was [2/1054]:
QMYSQL: Unable to execute query
Database error was:
Unknown column 'r.lastplay' in 'field list'

Table 'mythconverg.recgroups' doesn't exist in the original database 
from 0.25.

If this is hard to work around is there are simple way to transfer the 
records of previous recordings from the old database to the new. 
Everything else, capture cards etc etc has changed.

Interestingly I did a similar migration from my old 0.24 system earlier 
in the year without any issues.

Any pointers would be much appreciated.

Thanks

Ken

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.