Error: has 13 columns but 14 values were supplied

[Malcolmest]

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]

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]

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.