search

Fmstrat / plex-db-sync

Synchronizes the database watched status between two Plex servers. This includes watched times, and works for all users on the system without the need for tokens.
152 stars 24 forks source link

Error: has 13 columns but 14 values were supplied #20

Open Malcolmest opened 4 years ago

Malcolmest commented 4 years ago

Hello and thanks for your work. I used to use the trakt.tv plugin to sync watch status between servers but after my most recent reinstall it seems Plex will no longer let me access any plugin "Channels" making the plugin halfway functional.

I keep getting this error:

Error: near line 1: table tmpdb.metadata_item_settings2 has 13 columns but 14 values were supplied

I noticed through DB browser that the newer DB has a 14th column "last_rated_at" datetime. Is it possible to simply fill that in with "null" on all entry's so the migration works properly between versions?

Fmstrat commented 4 years ago

Hi @Malcolmest, yes, this should work fine. I would accept a PR if you are willing to do so. I haven't been heavily focused on this project because I am about to release a new one that focuses on true Plex cluster management. It will detect when a user watches/stops a show and immediately sync that status to other Plex servers using Plex's built in APIs. I will likely be releasing it within the next month.

Malcolmest commented 4 years ago

Thanks for the quick response. You new project sounds pretty awesome and I might use it in the future if I deploy multiple servers. Unfortunately I don't know how to code very much at all yet and barely know how to use DB Browser. Maybe you could just help me get the "null" 14th column added to my old plex DB that is no longer running? It's not the end of the world but I really would like my watched status back on my new server.