Invalid date value for item

JeremiahAY

Hi, I've been having trouble syncing my documents because of an invalid date value which shows up as "Invalid date value '2079-12-15 18:10:50' for item 7GIXK4LR"". For some context on the date, my PC is pretty old and sometimes starts up with the wrong date and time so I probably added a file without changing the date on my system first and that's why it's 2079. I can't find the file based on the item number and I don't want to mass delete my old references because I might need to use them in the near future , although I will if it's necessary. Any help on this would be great :) Report ID:2106692099

dstillman

Paste 7GIXK4LR into the search bar in All Field & Tags mode in your library root.

If it's not there, it's in the trash.

JeremiahAY

Thanks for the suggestion, I tried searching, but I wasn't able to find anything and after clearing my bin, the problem still persists. I realised the issue is for multiple items not just "7GIXK4LR". The full report is as follows:
"
[JavaScript Error: "Error 400 for item 7GIXK4LR in My Library:

ZoteroObjectUploadError: Invalid date value '2079-12-15 18:10:50' for item 7GIXK4LR"]

[JavaScript Error: "Invalid date value '2079-12-15 18:10:50' for item 7GIXK4LR" {file: "chrome://zotero/content/xpcom/sync/syncEngine.js" line: 1357}]

[JavaScript Error: "Error 400 for item EREH78ZP in My Library:

ZoteroObjectUploadError: Invalid date value '2079-12-15 18:10:59' for item EREH78ZP"]

[JavaScript Error: "Invalid date value '2079-12-15 18:10:59' for item EREH78ZP" {file: "chrome://zotero/content/xpcom/sync/syncEngine.js" line: 1357}]

[JavaScript Error: "Error 400 for item JYI75V3M in My Library:

ZoteroObjectUploadError: Invalid date value '2079-12-15 18:11:03' for item JYI75V3M"]

[JavaScript Error: "Invalid date value '2079-12-15 18:11:03' for item JYI75V3M" {file: "chrome://zotero/content/xpcom/sync/syncEngine.js" line: 1357}]

[JavaScript Error: "Error 400 for item NB96D59Z in My Library:

ZoteroObjectUploadError: Invalid date value '2079-12-15 18:11:15' for item NB96D59Z"]

[JavaScript Error: "Invalid date value '2079-12-15 18:11:15' for item NB96D59Z" {file: "chrome://zotero/content/xpcom/sync/syncEngine.js" line: 1357}]

[JavaScript Error: "Error 400 for item IQ23CCKF in My Library:

ZoteroObjectUploadError: Invalid date value '2079-12-15 18:11:35' for item IQ23CCKF"]

[JavaScript Error: "Invalid date value '2079-12-15 18:11:35' for item IQ23CCKF" {file: "chrome://zotero/content/xpcom/sync/syncEngine.js" line: 1357}]

[JavaScript Error: "Made no progress during upload -- stopping" {file: "chrome://zotero/content/xpcom/sync/syncEngine.js" line: 1416}]

[JavaScript Error: "Made no progress during upload -- stopping" {file: "chrome://zotero/content/xpcom/sync/syncEngine.js" line: 1416}]

version => 6.0.26, platform => Win32, oscpu => Windows NT 10.0; WOW64, locale => en-GB, appName => Zotero, appVersion => 6.0.26, extensions => Zotero LibreOffice Integration (6.0.4.SA.6.0.26, extension), Zotero Word for Windows Integration (6.0.3.SA.6.0.26, extension)
"

I've tried to find the directory "chrome://zotero/content/xpcom/sync/syncEngine.js" because it seems to be an issue with the chrome extension but I haven't been able to find it.

dstillman

You’ll need to fix the dates on all those items. Searching by item key will definitely work, but you can also just search for “2079”, again in All Fields & Tags mode.

That’s not a directory and not related to the Chrome extension. Don’t worry about messages in error reports — those are for us.

JeremiahAY

I've tried searching both the year and the item codes in the search bar, but was unable to find anything. I've deleted the most recent documents added which are likely to be the cause of the issue (I roughly remember the last time I manually synced) but the error still shows.

dstillman

OK, sorry, it looks like it's actually 5 annotations on the attachment 9K9JW2FX. Search for that and it will show up.

To fix this, first close Zotero and make a backup of the zotero.sqlite file in your Zotero data directory. Then restart Zotero, go to Tools → Developer → Run JavaScript, and run this code:

await Zotero.DB.queryAsync("UPDATE items SET dateAdded=CURRENT_TIMESTAMP, dateModified=CURRENT_TIMESTAMP WHERE dateAdded LIKE ?", '2079%')

It will say "undefined".

Then restart Zotero and try to sync.

JeremiahAY

It worked. Thank you so much for the help. I wasn't able to identify the annotations using the codes, but just restarting Zotero after running the javascript fixed the syncing issue. Thanks!