[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