[mythtv-users] Recordedid conflict in attempted MythArchive import

John Pilkington J.Pilk at tesco.net
Tue Jan 3 18:22:12 UTC 2017


I have occasionally used the MythArchive export/import tools to transfer 
recordings between independent Myth installations - not via DVDs but 
using rsync.  Today one transfer worked, one didn't. The bad log shows

Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '9789' for key 'PRIMARY'

and then goes on to say that markup and recordedseek details have been 
inserted and the Import completed OK.  The file is there, but doesn't 
show in the recordings list.

I suspect that I could replace the Recordedid value in the xml file with 
some other randomish value, or perhaps just remove that line, but 
haven't yet tried either.  Recent Recordedids on the target box approach 
12000.  Recommendations welcome.

The source installation is 'buntu ppa 0.28-fixes, target is el7 0.29-pre.

John P




More information about the mythtv-users mailing list