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.