Upgrade StorageSync error: Error(s) encountered during statement execution: too many terms in compound
Hi,
I recently turned on Zotero storage, but files still weren't syncing. So I reset the file sync on both computers. On one of them I now get:
Report 1141228560
An error occurred during syncing:
Error(s) encountered during statement execution: too many terms in compound SELECT [QUERY: SELECT data FROM syncCache SC JOIN (SELECT 'S4JCJWFZ' AS key, 6622 AS version UNION SELECT 'J5D9S4TU' AS key, 6622 AS version .... this goes on for a while
Best,
Ruben
I recently turned on Zotero storage, but files still weren't syncing. So I reset the file sync on both computers. On one of them I now get:
Report 1141228560
An error occurred during syncing:
Error(s) encountered during statement execution: too many terms in compound SELECT [QUERY: SELECT data FROM syncCache SC JOIN (SELECT 'S4JCJWFZ' AS key, 6622 AS version UNION SELECT 'J5D9S4TU' AS key, 6622 AS version .... this goes on for a while
Best,
Ruben
-
dstillmanThanks for reporting — this should be fixed in 5.0.2, available now via Help -> Check for Updates.
-
rubenarslanOk, error is gone. Didn't get the file, but will first update on the other machine also before I complain.
This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.