HOW-TO: safely install or upgrade PlexKodiConnect

[croneter]

Some Kodi skins like Titan BINGIE MOD and probably also AuraMod use further Kodi add-ons in a way that messes with PlexKodiConnect's logic to reset and resync the Kodi database.

How to safely install or update PlexKodiConnect:

1. Switch to the Standard Kodi skin Estuary
2. Install or upgrade PlexKodiConnect
3. Let PlexKodiConnect (re-)sync the Plex database to the Kodi database completely
4. Switch back to your skin of choice

How to recover if PKC-installation or -update went awry

If all else fails and you're getting hammered with error messages:

1. Deactivate the add-on PlexKodiConnect: Add-ons -> My add-ons -> PlexKodiConnect -> toggle enable
2. Switch to the Standard Kodi skin Estuary
3. Exit Kodi
4. Navigate to the Kodi userdata folder
5. Enter the directory called Database
6. Delete everything except Addons33.db (or AddonsXY.db)
7. Restart Kodi
8. Activate PlexKodiConnect again: Add-ons -> My add-ons -> PlexKodiConnect -> toggle enable
9. Wait until PlexKodiConnect finished its initial sync
10. Switch to your skin of choice

Symptoms of this issue occuring

Symptoms you could encounter when installing/upgrading PKC:

sqlite3.OperationalError: database is locked

sqlite3.IntegrityError: UNIQUE constraint failed: writer_link.media_id, writer_link.media_type, writer_link.actor_id
sqlite3.IntegrityError: UNIQUE constraint failed: country_link.media_id, country_link.media_type, country_link.country_id

and other violated UNIQUE constraints (see e.g. #1480). Seems like e.g. the Kodi add-on script.skin.helper.widgets is still active in the background while PKC tries to wipe and resync the DBs.