Problem #1677346529

janneblomqvist
Hi, I was directed to post to the forum to get somebody to look at my issue. I'm trying to import an old Mendeley database (seems I last updated it in 2014). I haven't started the current version of Mendeley, as I read recent versions encrypts my data (one BIG reason for moving to Zotero, thanks Elsevier!).

Cheers,
Janne
  • bwiernik
    What exactly happens when you try to import your Mendeley database?
  • janneblomqvist
    It says it failed, when I click details I get

    Warning: NetUtil.newChannel(uri) deprecated, please provide argument 'aWhatToLoad'

    Warning: NetUtil.newChannel(uri) deprecated, please provide argument 'aWhatToLoad'

    [JavaScript Error: "Component returned failure code: 0x80470002 (NS_BASE_STREAM_CLOSED) [nsIConverterOutputStream.writeString]" {file: "chrome://zotero/content/xpcom/server.js" line: 556}]

    [JavaScript Error: "NS_ERROR_NOT_AVAILABLE: Component returned failure code: 0x80040111 (NS_ERROR_NOT_AVAILABLE) [nsIXPCComponents_Utils.import]" {file: "resource://services-common/kinto-http-client.js" line: 61}]

    [JavaScript Error: "Error: Error(s) encountered during statement execution: no such column: RF.remoteUuid [QUERY: SELECT F.id, F.uuid, F.name, CASE WHEN F.parentId=0 THEN -1 ELSE F.parentId END AS parentId, RF.remoteUuid FROM Folders F JOIN RemoteFolders RF ON (F.id=RF.folderId) WHERE groupId=?] [PARAMS: 0] [ERROR: no such column: RF.remoteUuid]" {file: "chrome://zotero/content/xpcom/db.js" line: 721}]

    [JavaScript Error: "Error: Error(s) encountered during statement execution: no such column: RF.remoteUuid [QUERY: SELECT F.id, F.uuid, F.name, CASE WHEN F.parentId=0 THEN -1 ELSE F.parentId END AS parentId, RF.remoteUuid FROM Folders F JOIN RemoteFolders RF ON (F.id=RF.folderId) WHERE groupId=?] [PARAMS: 0] [ERROR: no such column: RF.remoteUuid]" {file: "chrome://zotero/content/xpcom/db.js" line: 721}]

    version => 5.0.54, platform => Linux x86_64, oscpu => Linux x86_64, locale => en-US, appName => Zotero, appVersion => 5.0.54, extensions => Zotero LibreOffice Integration (5.0.14.SA.5.0.54, extension), Shockwave Flash (30.0.0.134, plugin)



    (I didn't include that in the original message, as I understood that to be part of the bug report I submitted...)

    I'd guess the "no such column" error suggests that Zotero doesn't understand old Mendeley databases? But how to proceed? If I start a newer version of Mendeley, will it then encrypt my DB?
  • dstillman
    You can't import an old Mendeley database, only one from the most recent version (pre-encryption), so you'll need to update to 1.18. Download links here:

    https://www.zotero.org/support/kb/mendeley_import#the_import_process
  • bwiernik
    You could try to make a backup of the database, then install Mendeley 1.18 (the last version before they started encryption), as described here:
    https://www.zotero.org/support/kb/mendeley_import

    Open the database with that version, then try to import with Zotero. The Zotero devs might also have other ideas.
  • janneblomqvist
    Installing mendeley 1.18, starting mendeley, letting it do its thing, quitting it, and then importing the library into Zotero worked!

    Thanks!

This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.

Sign In or Register to comment.