Cannot add the new file

luongthang1908

Report ID: 287131231.

Dear everyone,

I have a big problem with my zotero.
When I cited a new paper from Google chrome, my zotero did not work.
Additionally, I could not creat a new file in the zotero library.
Could you please give me some suggestion to fix this issue?

Thank you

dstillman

[JavaScript Error: "[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 :: Zotero.DBConnection.prototype.query :: line 145" data: no] [QUERY: INSERT OR IGNORE INTO collectionItems VALUES (?,?,?)] [ERROR: insert on table "collectionItems" violates foreign key constraint "fki_collectionItems_itemID_sourceItemID"]"]

Check your database integrity from the Advanced → Files and Folders pane of the Zotero preferences.

Are you getting this saving from all pages, or a specific one? If the latter, provide an example URL.

Additionally, I could not creat a new file in the zotero library.

What do you mean by this, exactly?

https://www.zotero.org/support/reporting_problems#provide_steps_to_reproduce

luongthang1908

Thanks for your advice.

Zotero reports that "Errors were found in your Zotero database.
You can use the database repair tool at http://zotero.org/utils/dbfix to attempt to correct these errors."
What is the next step since I cannot open the link?

dstillman

I'll fix the link, but you can access it here:

https://www.zotero.org/utils/dbfix

luongthang1908

Thank you.

I have tried this online tool three times but my database cannot be fixed.
Could you give me an orientation?

dstillman

You'll have to provide more details about what you're doing and what's not working.

luongthang1908

I uploaded my zotero.sqlite file to zotero link.
After that, I download the new files (.zip) from zotero, extracted it and copy to my zotero installation folder where I copied and zipped my zotero.sqlite file.
However, when I check the database integrity, the same error was reported again.

dstillman

From your other thread, which I've deleted:

[JavaScript Error: "Component returned failure code: 0x8052000b (NS_ERROR_FILE_CORRUPTED) [mozIStorageStatement.executeStep]" {file: "chrome://zotero/content/xpcom/db.js" line: 208}]"

If you're still getting this, you likely didn't correctly replace your existing zotero.sqlite file with the repaired one.

luongthang1908

Dear Dan,

I have fixed my problem.
There are some files named zotero.sqlite (conflict) and my zotero become normal after I deleted these files.

Thank you for your supports.

dstillman

Do you have your data directory within Dropbox or a similar syncing system? If so, you should move it out immediately and point Zotero at the new location.

luongthang1908

Thank you for your suggestion.