Report id 1133439797

edited August 3, 2021
Hello,

I'm trying to sync a group library for the first time and I'm having an error.
The error is back when I'm manually synchronizing the group library.
There's 12723 items in online library whereas there is 12722 items locally.

Here's the error log, (I removed some VALUES and PARAMS as the body of the post is limited) :

Error(s) encountered during statement execution: too many SQL variables [QUERY: INSERT INTO itemRelations (itemID, predicateID, object) VALUES (?, ?, ?), ....] [PARAMS: 16402, 2, "http://zotero.org/groups/683778/items/F2UKWM3X", 16402, 2, "http://zotero.org/groups/683778/items/IQ9SPQKR", 16402, 2, ...] [ERROR: too many SQL variables]

the Debug id : D2021548370

Can you please help me,
Best Regards
  • You seem to have one item that you've marked as related to hundreds of other items. That's not expected and is breaking things.

    To see the item in question, go to one of your groups and paste HRE2UKZ8 into the search bar in All Fields & Tags mode. We'll look into fixing this at some point, but for now you should unrelate all those items or delete this item and empty the trash.
  • Thank you for your reply.

    We need the relation between those items in our database so we can't use this solution.
    We'll manage without this item in the client for the moment.

    Best regards
Sign In or Register to comment.