[virtuallysafe]

Did I say it was a PITA?

Nasty , thanks for the detailed info.

After cleaning up 18 actors the upgrade has completed successfully. Basically I performed the following:

Found duplicate entries in 'actors' table:

Code:

mysql> select strActor from actors group by strActor having count(*) > 1:

Determined the multiple 'idActor' values:

Code:

mysql> select * from actors where strActor = "INSERT ACTOR NAME HERE";

Updated the 'actorlinkepisode' table to a single 'idActor' vlaue:

Code:

mysql> update actorlinkepisode set idActor=12345 where idActor=67890;

Deleted the no longer required entry in 'actors' table:

Code:

mysql> delete from actors where idActor = 67890;

Unfortunately I too have dropped a bunch of old databases recently (since the Kodi rename), however, have been using the same DB and upgrading for years. My DB backups indicate since at least v77...