Error importing notes from format: enex

Support
1

Operating system

macOS

Joplin version

2.14.6

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?

Body

  • 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).

Errors

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/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database-driver-node.js:23:18)
    at JoplinDatabase.sqliteErrorToJsError (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database.js:34:30)
    at JoplinDatabase.<anonymous> (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database.js:138:36)
    at Generator.throw (<anonymous>)
    at rejected (/Applications/Joplin.app/Contents/Resources/app.asar/node_modules/@joplin/lib/database.js:6:65)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
2

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.

3

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).

4

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