Can't sync on OSX (Report ID 2010614287)

kjamison

I haven't been able to sync my Macbook since the end of January (I didn't realize until more recently). I can sync from my windows machine at work just fine, but I can't sync my mac at work or at home. I have restarted the computer, reinstalled Zotero, disabled all other firefox extensions, and it is still happening. I don't really mind the prospect of wiping and doing a fresh sync from the server, but are there any major risks associated with that? And will that solve the problem?

I'm using:
Zotero 2.0.9
Firefox 3.6.13
OSX 10.6.6

I would prefer not to upgrade to FF4 and Zotero 2.1 until they're out of beta and I can be sure my other extensions are compatible.

Here is the error:

[JavaScript Error: "[Exception... "'Invalid integer value 'NULL' [QUERY: UPDATE itemAttachments SET sourceItemID=?, linkMode=?, mimeType=?, charsetID=?, path=?, syncState=? WHERE itemID=?]' when calling method: [nsIDOMEventListener::handleEvent]" nsresult: "0x8057001e (NS_ERROR_XPC_JS_THREW_STRING)" location: "<unknown>" data: no]"]

[JavaScript Error: "Invalid integer value 'NULL' [QUERY: UPDATE itemAttachments SET sourceItemID=?, linkMode=?, mimeType=?, charsetID=?, path=?, syncState=? WHERE itemID=?]" {file: "chrome://zotero/content/xpcom/sync.js" line: 872}]

Thanks
Keith

kjamison

So I tried a couple of additional things to see what the problem was, and can provide more information about it..... Apparently my last sync was 1/24/2011

I tried twice and generated two error reports:
720116095

The error is the same as the one in the OP, and the debug output ends with:

[unrelated output removed — D.S.]

Leading up to this was a series of Binding operations for creators 1-1965

kjamison

Oops... and the second report is # 660750366 .

The debug output for this one was identical to above, but the above text was followed by:

[unrelated output removed — D.S.]

NOTE: I restarted firefox and tried again and got this same output (with the itemData binding things...) Not sure why they didn't show up the first time.

dstillman

Provide a Debug ID for a sync attempt that produces the error. Don't copy and paste debug output.

kjamison

Oops sorry. Debug ID D1690396548

dstillman

That's a strange error. Does this still happen if you disable all your other Firefox extensions?

kjamison

Yes sync still fails when I disable all my extensions. Here's the debug ID for that case: D1415439120

dstillman

Could you upload your database to the DB Repair Tool and send the Upload ID to support@zot....org, with a link to this thread? You can ignore the download link the tool provides. Don't post your Upload ID publicly.

kjamison

sent.

dstillman

So there are some invalid values in the itemAttachments table in your database. Given that no one else has reported this and I can't figure out any way it could have occurred, I think you may have done this to your own database (either via ZoteRename or something else gone wrong). You can fix it with the following SQL:

UPDATE itemAttachments SET charsetID=NULL WHERE charsetID='NULL';
I'll also update the DB Repair Tool to fix it, but we don't have any indication that anyone else is experiencing it.

kjamison

Success! thanks for looking into that. Seeing that it came down to charsetID, I bet it is related to problems I was having some time back with ZoteRename and unicode titles/filenames. I'll have to look into that. Sorry for making extra work for you. Really appreciate all your help. Is there a Zotero tip jar anywhere?