[MLZ] Can't sync

wonblee · November 28, 2014

"[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/data/item.js :: Zotero.Item.prototype._replaceMainOrAlt :: line 2784" data: no] [ERROR: Date field must begin with SQL date]"

I've tried resetting to the server and uninstalling and re-installing MLZ.

Nothing has worked.

I have a deadline coming up.

Prof. Bennett?

aurimas · November 29, 2014

I suspect a debug log for a sync attempt that fails may be helpful. https://www.zotero.org/support/debug_output

wonblee · November 30, 2014

Ok, I followed the instruction on https://www.zotero.org/support/debug_output.

But when I click "Submit to Zotero Server" button, the button is grayed out momentarily, the green bar to the right is filled, and the "Submit to Zotero Server" button becomes active again.

But Zotero is not providing a Debut ID number!

Where do I go from here? The Preference pane says "231775 lines logged", which seems pretty long too.

aurimas · November 30, 2014

That might be too long to submit. You can open the debug log (this might take a while), right-click the page -> Save Page As, and send the saved file to fbennett if he provides an email address.

fbennett · November 30, 2014

(I was on the road during the weekend, just picking this up)

@wonblee: I think I've spotted a likely cause. If I'm right, it's a bug in the MLZ client; no action will be required at your end.

Stand by, more news soon.

fbennett · November 30, 2014

I've put up a fresh version of MLZ. See if the new version clears the sync error.

wonblee · November 30, 2014

Yes, it worked! Thanks!

fbennett · November 30, 2014

That's very good news. Thanks for reporting back.