Error importing notes from format: enex

Support
1

Operating system

macOS

Joplin version

2.14.22

Desktop version info

Joplin 2.14.22 (prod, darwin)

Client ID: 75745a580b434ed5902951e96af75b8a
Sync Version: 3
Profile Version: 46
Keychain Supported: Yes

Revision: e579eb9

Backup: 1.4.0

What issue do you have?

Body

  • Input format: enex
  • Output format: md

Errors

Error on note "Unfortunately, It's Very Hard to Forget Anyone By Drinking Root Beer!!": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 193d0d92b9e357d05244cebc6a32737c,Picture.jpeg,image/jpeg,Picture.jpeg,1718210121855,1718210121855,jpeg,55631,1718210121855,1718210121855,1718210121855
    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

Operating system

macOS

Joplin version

2.14.22

Desktop version info

Joplin 2.14.22 (prod, darwin)

Client ID: 75745a580b434ed5902951e96af75b8a
Sync Version: 3
Profile Version: 46
Keychain Supported: Yes

Revision: e579eb9

Backup: 1.4.0

What issue do you have?

Body

  • Input format: enex
  • Output format: md

Errors

Error on note "March": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 81d044f333c565e182f296a3ea113493,March.jpg,image/jpeg,March.jpg,1718231781827,1718231781827,jpg,93105,1718231781827,1718231781827,1718231781827
    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)

Error on note "Peanuts at the Museum Wall Calendar 2014 Cover": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): a3f01f099ee718ff511b6dcbb0a2f5bd,Peanuts at the Museum Wall Calendar 2014 Cover.jpg,image/jpeg,Peanuts at the Museum Wall Calendar 2014 Cover.jpg,1718231798665,1718231798665,jpg,141304,1718231798665,1718231798665,1718231798665
    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)
3

Operating system

macOS

Joplin version

2.14.22

Desktop version info

Joplin 2.14.22 (prod, darwin)

Client ID: 75745a580b434ed5902951e96af75b8a
Sync Version: 3
Profile Version: 46
Keychain Supported: Yes

Revision: e579eb9

Backup: 1.4.0

What issue do you have?

Body

  • Input format: enex
  • Output format: md

Errors

Error on note "Prince Snoopy": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 3489d9d2010ad2c11a178535c4918cf5,Prince Snoopy.jpg,image/jpeg,Prince Snoopy.jpg,1718232132228,1718232132228,jpg,73912,1718232132228,1718232132228,1718232132228
    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)
4

Operating system

macOS

Joplin version

2.14.22

Desktop version info

Joplin 2.14.22 (prod, darwin)

Client ID: 75745a580b434ed5902951e96af75b8a
Sync Version: 3
Profile Version: 46
Keychain Supported: Yes

Revision: e579eb9

Backup: 1.4.0

What issue do you have?

Body

  • Input format: enex
  • Output format: md

Errors

Error on note "Hungry for a Day pin   H4AD.com": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): e06db8742bc401bfb2ad1a6dd23a94ce,,image/png,,1718231731919,1718231731919,,235021,1718231731919,1718231731919,1718231731919
    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)

Error on note "Jewelry from Stan": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 906fe761d4e28b9db2af49a37c4fa86f,Picture,image/jpeg,Picture,1718231820946,1718231820946,,873033,1718231820946,1718231820946,1718231820946
    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)

Error on note "misc USA flag with other flag pigs": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 387efb74b5325ed0e1dadedae2d660fb,Image.png,image/png,Image.png,1718232260691,1718232260691,png,1330614,1718232260691,1718232260691,1718232260691
    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)

Error on note "USA flag and USA thin blue line FLAG pin": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 5ecdeca6f1ed44ef229711dc8b9cb664,,image/png,,1718232501418,1718232501418,,1642269,1718232501418,1718232501418,1718232501418
    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)

Error on note "WWP pin": Error: Error: SQLITE_CONSTRAINT: UNIQUE constraint failed: resources.id: INSERT INTO `resources` (`id`, `title`, `mime`, `filename`, `created_time`, `updated_time`, `file_extension`, `size`, `blob_updated_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 076db87fe154969bec2eca28299be79d,,image/png,,1718232503327,1718232503327,,251936,1718232503327,1718232503327,1718232503327
    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)
5

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