Libray sorting issue
Hello,
i'm experiencing an issue with Zotero 5 (last update) library sorting on my pc (while the same library works on my laptop).
I try to sort elements by date, but the result is still a messy list.
Ex:
7/4/1962
7/6/1962
7/9/1962
14/7/1962
even if in the date scheme is correctly recognised (d m y) in every record.
What can I do?
i'm experiencing an issue with Zotero 5 (last update) library sorting on my pc (while the same library works on my laptop).
I try to sort elements by date, but the result is still a messy list.
Ex:
7/4/1962
7/6/1962
7/9/1962
14/7/1962
even if in the date scheme is correctly recognised (d m y) in every record.
What can I do?
What's the locale of the PC? The above behavior would happen if the locale was set to en-US, because 7/4/1962 would be interpreted as July 4th, while 14/7/1962 would be interpreted as July 14th (because there's no alternative).
PC and Zotero locale is it-IT.
The "strange" thing is that with same settings zotero is perfectly working on my laptop.
- field on laptop: DD-MM-YYYY 05/06/1957
- mouse over on laptop YYYY-MM-DD 1957-06-05
- field on PC: DD-MM-YYYY 05/06/1957
- mouse over on PC: YYYY-DD-MM 1957-05-06.
Maybe I can reset online library from laptop (because I created all these records with it)?
Since the laptop is correct, my best guess for what happened here is that your PC (or Zotero on this PC) was previously set to a different locale, or for some reason the normal locale logic wasn't working. So when you synced this data to the PC, it was parsed differently.
If the PC is fully in sync, what you can do is open the Zotero data directory, close Zotero, and move zotero.sqlite out of the way (e.g., to your desktop). Then reopen Zotero and sync (and say yes when it asks if you want to sync to an empty database). It should then pull down your data with your current locale and parse all the dates again properly. You can then delete the backup of zotero.sqlite.