jlegewie/zotfile — Issue #29: Extraction of annotation crashes in group libraries
Author: jlegewie
Created: 2012-02-17 07:12:52+00:00
State: open
Labels: bug

"I am using Zotfile to extract annotations from PDF's inside my group library, and I keep getting the error message:

Error: uncaught exception: [Exception... "Component returned failure code: 0x80630003 (NS_ERROR_STORAGE_CONSTRAINT) [mozIStorageStatement.execute]" nsresult: "0x80630003 (NS_ERROR_STORAGE_CONSTRAINT)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: :: line 145" data: no] [QUERY: INSERT INTO itemNotes (itemID, sourceItemID, note, title) VALUES (?,?,?,?)] [ERROR: insert on table "itemNotes" violates foreign key constraint "fki_itemNotes_libraryID"]

I double checked the following already:
1) I can manually create notes as a child of this zotero library item
2) I have admin permissions
3) I tried to extract annotations to the exact same pdf copied in my local library, and it works every time.
4) Every pdf in my group library (I have 2 diff groups, 1 with admin, 1 with ownership) I get this exception error."