Your changes could not be saved - Movie tagging

[KierDarby]

This appears to be the same errors as was seen here, though that topic received no responses. I’ve attached the errors that were generated around the time of a failed tagging event - it looks like the queries being generated are being rejected by SQLite for some reason?

I’m hoping that someone has an idea what to do about this?

Server Version#:1.15.0.659

Logs:

Feb 15, 2019 17:04:30.996 [0x7f8b8b447700] Error — QueryParser: Invalid field 'onlyTransient' found, ignoring.
Feb 15, 2019 17:04:31.029 [0x7f8b8b447700] Error — QueryParser: Invalid field 'onlyTransient' found, ignoring.
Feb 15, 2019 17:04:32.607 [0x7f8b899e9700] Error — LPE: unknown item 65264.
Feb 15, 2019 17:04:32.607 [0x7f8b899e9700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F65264%2Fchildren in sync item 21734878
Feb 15, 2019 17:04:32.608 [0x7f8b899e9700] Error — Sync: skipping items for sync list 13113028, sync item 21734878: unable to generate sync set query
Feb 15, 2019 17:04:32.609 [0x7f8b899e9700] Error — LPE: unknown item 75283.
Feb 15, 2019 17:04:32.609 [0x7f8b899e9700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F75283%2Fchildren in sync item 21734882
Feb 15, 2019 17:04:32.609 [0x7f8b899e9700] Error — Sync: skipping items for sync list 13113028, sync item 21734882: unable to generate sync set query
Feb 15, 2019 17:04:32.611 [0x7f8b899e9700] Error — LPE: unknown item 79107.
Feb 15, 2019 17:04:32.611 [0x7f8b899e9700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F79107%2Fchildren in sync item 21734888
Feb 15, 2019 17:04:32.611 [0x7f8b899e9700] Error — Sync: skipping items for sync list 13113028, sync item 21734888: unable to generate sync set query
Feb 15, 2019 17:04:32.613 [0x7f8b899e9700] Error — LPE: unknown item 78820.
Feb 15, 2019 17:04:32.613 [0x7f8b899e9700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F78820%2Fchildren in sync item 21734895
Feb 15, 2019 17:04:32.613 [0x7f8b899e9700] Error — Sync: skipping items for sync list 13113028, sync item 21734895: unable to generate sync set query
Feb 15, 2019 17:04:32.616 [0x7f8b899e9700] Error — LPE: unknown item 72759.
Feb 15, 2019 17:04:32.616 [0x7f8b899e9700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F72759%2Fchildren in sync item 21734897
Feb 15, 2019 17:04:32.616 [0x7f8b899e9700] Error — Sync: skipping items for sync list 13113028, sync item 21734897: unable to generate sync set query
Feb 15, 2019 17:04:32.618 [0x7f8b899e9700] Error — LPE: unknown item 72747.
Feb 15, 2019 17:04:32.618 [0x7f8b899e9700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F72747%2Fchildren in sync item 21734898
Feb 15, 2019 17:04:32.618 [0x7f8b899e9700] Error — Sync: skipping items for sync list 13113028, sync item 21734898: unable to generate sync set query
Feb 15, 2019 17:04:33.145 [0x7f8baba2d700] Error — SQLITE3:(nil), 1, statement aborts at 168: [update metadata_items set extra_data=? where metadata_type=? and library_section_id=? and `index`=?] SQL logic error
Feb 15, 2019 17:04:33.145 [0x7f8baba2d700] Error — Exception inside transaction (inside=1) (../Library/MetadataCollection.cpp:236): sqlite3_statement_backend::loadOne: SQL logic error

Feb 15, 2019 17:04:33.145 [0x7f8baba2d700] Error — JobManager: Caught an exception notifying process 22165: sqlite3_statement_backend::loadOne: SQL logic error
Feb 15, 2019 17:04:33.173 [0x7f8b8940d700] Error — downloadContainer: expected MediaContainer element, found html
Feb 15, 2019 17:04:33.176 [0x7f8b2b159700] Error — downloadContainer: expected MediaContainer element, found html
Feb 15, 2019 17:04:33.182 [0x7f8b896fb700] Error — downloadContainer: expected MediaContainer element, found html
Feb 15, 2019 17:04:33.184 [0x7f8b2a88f700] Error — downloadContainer: expected MediaContainer element, found html
Feb 15, 2019 17:05:01.714 [0x7f8b89cd7700] Error — LPE: unknown item 65264.
Feb 15, 2019 17:05:01.714 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F65264%2Fchildren in sync item 21734878
Feb 15, 2019 17:05:01.714 [0x7f8b89cd7700] Error — Sync: skipping items for sync list 13113028, sync item 21734878: unable to generate sync set query
Feb 15, 2019 17:05:01.715 [0x7f8b89cd7700] Error — LPE: unknown item 75283.
Feb 15, 2019 17:05:01.715 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F75283%2Fchildren in sync item 21734882
Feb 15, 2019 17:05:01.715 [0x7f8b89cd7700] Error — Sync: skipping items for sync list 13113028, sync item 21734882: unable to generate sync set query
Feb 15, 2019 17:05:01.716 [0x7f8b89cd7700] Error — LPE: unknown item 79107.
Feb 15, 2019 17:05:01.716 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F79107%2Fchildren in sync item 21734888
Feb 15, 2019 17:05:01.717 [0x7f8b89cd7700] Error — Sync: skipping items for sync list 13113028, sync item 21734888: unable to generate sync set query
Feb 15, 2019 17:05:01.718 [0x7f8b89cd7700] Error — LPE: unknown item 78820.
Feb 15, 2019 17:05:01.718 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F78820%2Fchildren in sync item 21734895
Feb 15, 2019 17:05:01.718 [0x7f8b89cd7700] Error — Sync: skipping items for sync list 13113028, sync item 21734895: unable to generate sync set query
Feb 15, 2019 17:05:01.719 [0x7f8b89cd7700] Error — LPE: unknown item 72759.
Feb 15, 2019 17:05:01.719 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F72759%2Fchildren in sync item 21734897
Feb 15, 2019 17:05:01.719 [0x7f8b89cd7700] Error — Sync: skipping items for sync list 13113028, sync item 21734897: unable to generate sync set query
Feb 15, 2019 17:05:01.720 [0x7f8b89cd7700] Error — LPE: unknown item 72747.
Feb 15, 2019 17:05:01.721 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F72747%2Fchildren in sync item 21734898
Feb 15, 2019 17:05:01.721 [0x7f8b89cd7700] Error — Sync: skipping items for sync list 13113028, sync item 21734898: unable to generate sync set query
Feb 15, 2019 17:05:01.811 [0x7f8b89cd7700] Error — LPE: unknown item 65264.
Feb 15, 2019 17:05:01.811 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F65264%2Fchildren in sync item 21734878
Feb 15, 2019 17:05:01.812 [0x7f8b89cd7700] Error — LPE: unknown item 75283.
Feb 15, 2019 17:05:01.812 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F75283%2Fchildren in sync item 21734882
Feb 15, 2019 17:05:01.814 [0x7f8b89cd7700] Error — LPE: unknown item 79107.
Feb 15, 2019 17:05:01.814 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F79107%2Fchildren in sync item 21734888
Feb 15, 2019 17:05:01.815 [0x7f8b89cd7700] Error — LPE: unknown item 78820.
Feb 15, 2019 17:05:01.815 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F78820%2Fchildren in sync item 21734895
Feb 15, 2019 17:05:01.816 [0x7f8b89cd7700] Error — LPE: unknown item 72759.
Feb 15, 2019 17:05:01.816 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F72759%2Fchildren in sync item 21734897
Feb 15, 2019 17:05:01.818 [0x7f8b89cd7700] Error — LPE: unknown item 72747.
Feb 15, 2019 17:05:01.818 [0x7f8b89cd7700] Error — Sync: failed to generate query for path library://97e60895-34f9-49b1-8bcb-8203c1178c2e/directory/%2Flibrary%2Fmetadata%2F72747%2Fchildren in sync item 21734898

[anon18523487]

That could be caused by your database being out of date. PMS will try to update a database, but it’s possible that update failed for you so newer SQL statements that require the update won’t work. Have you restarted PMS recently, that’s when the updates occur. If you can, restart PMS, let it sit for 3 minutes without doing anything, then retry editing that tag. Get me the PMS logs if it fails.

[KierDarby]

Thanks for your reply @anon18523487

I’ve restarted both PMS and the server itself several times, but no amount of waiting seems to enable to tagging facility, I always end up with the same “Your changes could not be saved.” error in the dialog.

I’ve attached the logs in the hope that you can see what might be going wrong.

Thanks again for your time.

Plex Media Server Logs_2019-02-15_19-51-42.zip (3.1 MB)