Error importing notes from format: enex

Operating system


Joplin version


Desktop version info

Joplin 2.14.6 (prod, darwin)

Client ID: 7de105d73a6747a2b20b9810d16a5b00
Sync Version: 3
Profile Version: 45
Keychain Supported: No

Revision: 92667ba

Simple Backup: 1.3.5

What issue do you have?


  • Input format: enex
  • Output format: md

I also get the same error in html import mode. If I export the one note from Evernote and import it on its own it works fine. I have 40k Evernote notes spread across multiple enex files and a handful in each seem to fail to import first time. I'm not entirely sure which field it thinks is NULL.

I realize I'm using the dev release (I was trying out OCR).


Error on note "High quality lightweight children’s bikes from Islabikes": Error: Error: SQLITE_CONSTRAINT: NOT NULL constraint failed: note_tags.note_id: INSERT INTO `note_tags` (`note_id`, `tag_id`, `updated_time`, `user_updated_time`, `id`, `created_time`, `user_created_time`) VALUES (?, ?, ?, ?, ?, ?, ?): ,9329b223253145ef8f90fc7853b52512,1704590058653,1704590058653,679b1db2a7a446bb8a83baebeb753d4c,1704590058653,1704590058653
    at DatabaseDriverNode.sqliteErrorToJsError (/Applications/
    at JoplinDatabase.sqliteErrorToJsError (/Applications/
    at JoplinDatabase.<anonymous> (/Applications/
    at Generator.throw (<anonymous>)
    at rejected (/Applications/
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

Thanks for the report. This is going to be fixed in the next pre-release which should be available within the next hour or so.

I installed the update and imported 6000 notes without error. Thanks for that. Then the Renderer crashed on me (I will see if that crash is reported elsewhere).

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.