Upgrade StorageURGENT: if you are using Better BibTeX and are on the zotero 8 beta, DO NOT UPGRADE yet
It looks like pinned keys are lost on upgrade of the zotero beta to 8.0-beta.23+58baa44ad+. I am working on a fix, but in the meantime, my advice is to turn off automatic updates of Zotero (not of plugins).
Work is being tracked at https://github.com/retorquere/zotero-better-bibtex/issues/3362
Work is being tracked at https://github.com/retorquere/zotero-better-bibtex/issues/3362
It might be helpful to suggest a way for those with access to a backup of zotero.sqlite to know what their pinned keys were. I'm sure there's a much cleaner query, but the following worked for me:
select v_title.value as Title, v_extra.value as Extra
from items i
join itemData d_title on i.itemID = d_title.itemID
join itemData d_extra on i.itemID = d_extra.itemID
join itemDataValues v_title on d_title.valueID = v_title.valueID
join itemDataValues v_extra on d_extra.valueID = v_extra.valueID
where
d_title.fieldID = 1 -- title
and d_extra.fieldID = 16 -- extra
and v_extra.value like '%Citation key%'
SELECT item.itemID, item.key as itemKey, item.libraryID,
MAX(CASE WHEN f.fieldName = 'title' THEN idv.value END) AS title,
MAX(CASE WHEN f.fieldName = 'extra' THEN idv.value END) AS extra
FROM items item
LEFT JOIN itemData id ON item.itemID = id.itemID
LEFT JOIN fields f ON id.fieldID = f.fieldID AND f.fieldName IN ('title', 'extra')
LEFT JOIN itemDataValues idv ON id.valueID = idv.valueID
WHERE item.itemID NOT IN (SELECT itemID FROM deletedItems)
AND item.itemTypeID NOT IN (SELECT itemTypeID FROM itemTypes WHERE typeName IN ('attachment', 'note', 'annotation'))
AND item.itemID NOT IN (SELECT itemID from feedItems)
GROUP BY item.itemID
(for key restoration you will need the library ID and the item ID and/or key)
but 7.0.71 also secures pinned keys structurally
Just to be sure... Does it mean that we can already update the beta? I success to stop at beta.21