Kodi14 to Kodi15 Upgrade


In the v90 database I had to work out which actors were duplicates:

Found duplicate entries in 'actors' table:

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

Determined the multiple 'idActor' values:

Code:
select * from actors where strActor = "INSERT ACTOR NAME HERE";

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

Code:
update actorlinkepisode set idActor=12345 where idActor=67890;

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

Code:
delete from actors where idActor = 67890;

 

http://forum.kodi.tv/showthread.php?tid=211501&pid=1868907

Last update:
20-01-2016 12:45
Author:
Karl Hudgell
Revision:
1.0
Average rating:0 (0 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.

Latest FAQs RSS

  1. Clone theme config (12-07-2019 15:47)
  2. Simple Cheap LED Control (29-04-2019 13:26)
  3. Freeing disk space on your Linux server (20-04-2019 12:48)
  4. Dockerized Download VM (30-01-2019 20:26)
  5. Jmeter + Performance Plugin + Jenkins Pipeline (16-02-2018 12:49)