Can't import new photo's into Tropy


#1

I’m trying to import photo’s from the ‘Photo’s’ programme on my mac into my Tropy Project but Tropy says it failed to import them and gives the following error notification:
TypeError: Cannot read property ‘fields’ of undefined
at getTemplateProperties (/Applications/Tropy.app/Contents/Resources/app.asar/lib/selectors/ontology.js:152:52)
at Import.getImageMetadata (/Applications/Tropy.app/Contents/Resources/app.asar/lib/commands/import.js:83:17)
at Import.getMetadata (/Applications/Tropy.app/Contents/Resources/app.asar/lib/commands/import.js:76:25)
at getMetadata.next ()
at Import.exec (/Applications/Tropy.app/Contents/Resources/app.asar/lib/commands/item.js:157:28)
at exec.next ()
at next (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/@redux-saga/core/dist/redux-saga-core.prod.cjs.js:1096:27)
at currCb (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/@redux-saga/core/dist/redux-saga-core.prod.cjs.js:1190:7)
at runSelectEffect (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/@redux-saga/core/dist/redux-saga-core.prod.cjs.js:682:5)
at runEffect (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/@redux-saga/core/dist/redux-saga-core.prod.cjs.js:1143:7)
at digestEffect (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/@redux-saga/core/dist/redux-saga-core.prod.cjs.js:1210:5)
at next (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/@redux-saga/core/dist/redux-saga-core.prod.cjs.js:1100:9)
at currCb (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/@redux-saga/core/dist/redux-saga-core.prod.cjs.js:1190:7)
at tryCatcher (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/bluebird/js/release/util.js:16:23)
at Promise._settlePromiseFromHandler (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/bluebird/js/release/promise.js:512:31)
at Promise._settlePromise (/Applications/Tropy.app/Contents/Resources/app.asar/node_modules/bluebird/js/release/promise.js:569:18)


#2

Can you check in the preferences window what your default item and photo templates are? (And that they were not deleted by any chance).


#3

Preferences for photo’s or Tropy? And where do I find what the default photo templates are?


#4

I think they are stored as JPEG


#5

Please try this:

  1. Restart Tropy
  2. Open Tropy’s Preferences and check the default templates in the Settings pane:
    Screenshot%20from%202019-03-27%2012-15-51
  3. If none of the default templates show up as red, it should be fine
  4. Close the preferences and try to import a photo
  5. If it fails like above, please select Help -> Show log files from the menu and copy and upload the project.log file here – this might help us debug the issue.

Thanks!


#6

Apparently it’s fine now, I’ll restart the programme more often from now now on prior to asking questions. Sorry I can’t help find the bug that caused it.


#7

I’ve been having this problem as well lately. I’ll try to import a file and the program will crash. My default templates are fine, however.

{“dpx”:1,“environment”:“production”,“locale”:“en”,“system”:“Windows_NT 10.0.17134 (x64)”,“version”:“1.4.5”,“level”:“info”,“message”:“log.init 1.4.5”,“label”:“project”,“timestamp”:“2019-04-10T11:49:58.661Z”}
{“level”:“verbose”,“message”:“initializing project window…”,“label”:“project”,“timestamp”:“2019-04-10T11:49:58.738Z”}
{“level”:“debug”,“message”:“init db C:\Users\Lenovo\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.770Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.773Z”}
{“level”:“verbose”,“message”:“restoring recent@tropy…”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.776Z”}
{“level”:“verbose”,“message”:“restoring settings@tropy…”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.787Z”}
{“level”:“verbose”,“message”:“restoring ui@tropy…”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.787Z”}
{“level”:“verbose”,“message”:“recent.restore \u001b[90m#1\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.788Z”}
{“level”:“verbose”,“message”:“settings.restore \u001b[90m#2\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.789Z”}
{“level”:“verbose”,“message”:“ui.restore \u001b[90m#3\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.789Z”}
{“level”:“debug”,“message”:“open resource C:\Users\Lenovo\AppData\Local\tropy\app-1.4.5\resources\app.asar\res\strings\renderer.en.yml”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.790Z”}
{“level”:“debug”,“message”:“open resource C:\Users\Lenovo\AppData\Local\tropy\app-1.4.5\resources\app.asar\res\keymaps\project.en.yml”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.790Z”}
{“level”:“verbose”,“message”:“project ready after 1210.5ms (1045.5ms)”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.793Z”}
{“level”:“verbose”,“message”:“keymap.update \u001b[90m#4\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.822Z”}
{“level”:“verbose”,“message”:“intl.update \u001b[90m#5\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.850Z”}
{“level”:“verbose”,“message”:“project.open \u001b[90m#6\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.850Z”}
{“level”:“debug”,“message”:“init db C:\Users\Lenovo\Downloads\Chile.tpy”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.850Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\Downloads\Chile.tpy”,“label”:“project”,“timestamp”:“2019-04-10T11:49:59.851Z”}
{“query”:"\n SELECT count(*) AS count FROM sqlite_master",“time”:12,“level”:“debug”,“message”:“db query took 12ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.068Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.126Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.126Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\AppData\Roaming\Tropy\ontology.db”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.126Z”}
{“level”:“verbose”,“message”:“plugins scanned: 0”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.131Z”}
{“level”:“verbose”,“message”:“plugins loaded: 0”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.131Z”}
{“query”:“PRAGMA user_version”,“time”:59,“level”:“debug”,“message”:“db query took 59ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.132Z”}
{“query”:"\n SELECT\n vocabulary_id AS id,\n prefix,\n title,\n description,\n comment,\n see_also AS seeAlso,\n protected AS isProtected\n FROM vocabularies\n WHERE deleted is NULL",“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.136Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\Downloads\Chile.tpy”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.137Z”}
{“query”:“PRAGMA user_version”,“time”:4,“level”:“debug”,“message”:“db query took 4ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.139Z”}
{“query”:"\n SELECT\n template_id AS id,\n template_type AS type,\n name,\n version,\n creator,\n description,\n protected AS isProtected,\n created\n FROM templates\n “,“time”:2,“level”:“debug”,“message”:“db query took 2ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.144Z”}
{“query”:“PRAGMA busy_timeout = 5000;”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.146Z”}
{“query”:“PRAGMA foreign_keys = on;”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.146Z”}
{“query”:”\n SELECT\n datatype_id AS id,\n vocabulary_id AS vocabulary,\n dt.description,\n dt.comment,\n label\n FROM datatypes dt\n JOIN vocabularies v USING (vocabulary_id)\n LEFT OUTER JOIN labels ON (datatype_id = id AND language = ?)\n WHERE deleted is NULL",“time”:2,“level”:“debug”,“message”:“db query took 2ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.146Z”}
{“query”:"\n SELECT\n class_id AS id,\n vocabulary_id AS vocabulary,\n c.description,\n c.comment,\n label\n FROM classes c\n JOIN vocabularies v USING (vocabulary_id)\n LEFT JOIN labels ON (class_id = id AND language = ?)\n WHERE deleted is NULL",“time”:3,“level”:“debug”,“message”:“db query took 3ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.147Z”}
{“query”:"\n SELECT\n property_id AS id,\n vocabulary_id AS vocabulary,\n p.description,\n p.comment,\n label\n FROM properties p\n JOIN vocabularies v USING (vocabulary_id)\n LEFT JOIN labels ON (property_id = id AND language = ?)\n WHERE deleted is NULL",“time”:4,“level”:“debug”,“message”:“db query took 4ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.148Z”}
{“query”:"\n SELECT vocabulary_id AS id, property_id AS prop\n FROM properties JOIN vocabularies USING (vocabulary_id)\n WHERE deleted is NULL",“time”:2,“level”:“debug”,“message”:“db query took 2ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.148Z”}
{“query”:"\n SELECT project_id AS id, name, base FROM project LIMIT 1",“time”:4,“level”:“debug”,“message”:“db query took 4ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.149Z”}
{“query”:"\n SELECT vocabulary_id AS id, class_id AS klass\n FROM classes JOIN vocabularies USING (vocabulary_id)\n WHERE deleted is NULL",“time”:2,“level”:“debug”,“message”:“db query took 2ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.152Z”}
{“query”:"\n SELECT class_id AS klass, template_id AS tpl\n FROM domains\n \n ORDER BY position",“time”:1,“level”:“debug”,“message”:“db query took 1ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.154Z”}
{“query”:"\n SELECT vocabulary_id AS id, datatype_id AS datatype\n FROM datatypes JOIN vocabularies USING (vocabulary_id)\n WHERE deleted is NULL",“time”:1,“level”:“debug”,“message”:“db query took 1ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.154Z”}
{“query”:"\n SELECT COUNT (id) AS total\n FROM items LEFT OUTER JOIN trash USING (id)\n WHERE deleted IS NULL",“time”:4,“level”:“debug”,“message”:“db query took 4ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.154Z”}
{“level”:“verbose”,“message”:“ontology.load \u001b[90m#7\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.156Z”}
{“query”:"\n SELECT\n f.field_id AS id,\n template_id AS tpl,\n property_id AS property,\n label,\n datatype_id AS datatype,\n required AS isRequired,\n hint,\n value,\n constant AS isConstant\n FROM fields f\n LEFT OUTER JOIN field_labels l\n ON (f.field_id = l.field_id AND language = ?)\n \n ORDER BY position, f.field_id",“time”:1,“level”:“debug”,“message”:“db query took 1ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.170Z”}
{“query”:"\n INSERT INTO access (uuid, version, path) VALUES (?, ?, ?)",“time”:126,“level”:“debug”,“message”:“db query took 126ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.285Z”}
{“level”:“verbose”,“message”:“project.opened \u001b[90m#8\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.286Z”}
{“level”:“verbose”,“message”:“restoring nav@d003338d-dccc-49d2-a129-dfdd5eac0734…”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.305Z”}
{“level”:“verbose”,“message”:“restoring notepad@d003338d-dccc-49d2-a129-dfdd5eac0734…”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.305Z”}
{“level”:“verbose”,“message”:“restoring esper@d003338d-dccc-49d2-a129-dfdd5eac0734…”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.305Z”}
{“level”:“verbose”,“message”:“restoring imports@d003338d-dccc-49d2-a129-dfdd5eac0734…”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.310Z”}
{“level”:“verbose”,“message”:“restoring sidebar@d003338d-dccc-49d2-a129-dfdd5eac0734…”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.310Z”}
{“level”:“verbose”,“message”:“restoring panel@d003338d-dccc-49d2-a129-dfdd5eac0734…”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.310Z”}
{“level”:“verbose”,“message”:“nav.restore \u001b[90m#9\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.311Z”}
{“level”:“verbose”,“message”:“notepad.restore \u001b[90m#10\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.330Z”}
{“level”:“verbose”,“message”:“esper.restore \u001b[90m#11\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.335Z”}
{“level”:“verbose”,“message”:“imports.restore \u001b[90m#12\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.345Z”}
{“level”:“verbose”,“message”:“sidebar.restore \u001b[90m#13\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.347Z”}
{“level”:“verbose”,“message”:“panel.restore \u001b[90m#14\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.348Z”}
{“level”:“verbose”,“message”:“history.drop \u001b[90m#15\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.351Z”}
{“level”:“verbose”,“message”:“list.load \u001b[90m#16\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.352Z”}
{“level”:“verbose”,“message”:“tag.load \u001b[90m#17\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.357Z”}
{“level”:“verbose”,“message”:“item.load \u001b[90m#18\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.360Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\Downloads\Chile.tpy”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.365Z”}
{“level”:“verbose”,“message”:“photo.load \u001b[90m#19\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.368Z”}
{“level”:“verbose”,“message”:“opening db C:\Users\Lenovo\Downloads\Chile.tpy”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.381Z”}
{“level”:“verbose”,“message”:“metadata.load \u001b[90m#20\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.381Z”}
{“level”:“verbose”,“message”:“selection.load \u001b[90m#21\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.397Z”}
{“level”:“verbose”,“message”:“note.load \u001b[90m#22\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.399Z”}
{“query”:“SELECT list_id AS id, parent_list_id AS parent, name FROM lists ORDER BY parent, position”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.419Z”}
{“level”:“verbose”,“message”:“tag.load \u001b[90m#23(17) Δ74ms\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.431Z”}
{“level”:“verbose”,“message”:“list.load \u001b[90m#24(16) Δ381ms\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.733Z”}
{“query”:“SELECT tag_id AS id, name, color, created, modified FROM tags”,“time”:6,“level”:“debug”,“message”:“db query took 6ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.987Z”}
{“query”:"\n SELECT id, property, text, datatype AS type\n FROM subjects\n JOIN metadata USING (id)\n JOIN metadata_values USING (value_id) ORDER BY id, metadata.created ASC",“time”:87,“level”:“debug”,“message”:“db query took 87ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:00.987Z”}
{“level”:“verbose”,“message”:“item.load \u001b[90m#25(18) Δ674ms\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.034Z”}
{“query”:"\n SELECT id AS photo, item_id AS id\n FROM photos\n LEFT OUTER JOIN trash USING (id)\n WHERE \n deleted IS NULL\n ORDER BY item_id, position",“time”:13,“level”:“debug”,“message”:“db query took 13ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.064Z”}
{“query”:"\n SELECT id, list_id AS list\n FROM list_items",“time”:12,“level”:“debug”,“message”:“db query took 12ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.064Z”}
{“query”:"\n SELECT\n id,\n template,\n datetime(created, “localtime”) AS created,\n datetime(modified, “localtime”) AS modified,\n deleted\n FROM subjects\n JOIN items USING (id)\n LEFT OUTER JOIN trash USING (id)",“time”:19,“level”:“debug”,“message”:“db query took 19ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.064Z”}
{“query”:"\n SELECT id, tag_id AS tag\n FROM taggings",“time”:28,“level”:“debug”,“message”:“db query took 28ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.064Z”}
{“query”:"\n SELECT id AS selection, photo_id AS id\n FROM selections\n LEFT OUTER JOIN trash USING (id)\n WHERE \n deleted IS NULL\n ORDER BY photo_id, position",“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.131Z”}
{“query”:"\n SELECT id, note_id AS note\n FROM notes\n WHERE deleted IS NULL\n ORDER BY id, created",“time”:5,“level”:“debug”,“message”:“db query took 5ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.132Z”}
{“query”:"\n SELECT\n id,\n item_id AS item,\n template,\n datetime(created, “localtime”) AS created,\n datetime(modified, “localtime”) AS modified,\n angle,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n width,\n height,\n path,\n page,\n size,\n protocol,\n mimetype,\n checksum,\n orientation\n FROM subjects\n JOIN images USING (id)\n JOIN photos USING (id)",“time”:32,“level”:“debug”,“message”:“db query took 32ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.132Z”}
{“level”:“verbose”,“message”:“photo.load \u001b[90m#26(19) Δ765ms\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.133Z”}
{“query”:"\n SELECT\n id,\n photo_id AS photo,\n x,\n y,\n width,\n height,\n angle,\n mirror,\n negative,\n brightness,\n contrast,\n hue,\n saturation,\n sharpen,\n template,\n datetime(created, “localtime”) AS created,\n datetime(modified, “localtime”) AS modified\n FROM subjects\n JOIN images USING (id)\n JOIN selections USING (id)",“time”:2,“level”:“debug”,“message”:“db query took 2ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.163Z”}
{“query”:"\n SELECT id, note_id AS note\n FROM notes JOIN selections USING (id)\n WHERE \n deleted IS NULL\n ORDER BY id, created",“time”:2,“level”:“debug”,“message”:“db query took 2ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.163Z”}
{“level”:“verbose”,“message”:“selection.load \u001b[90m#27(21) Δ766ms\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.163Z”}
{“level”:“verbose”,“message”:“metadata.load \u001b[90m#28(20) Δ855ms\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.236Z”}
{“level”:“verbose”,“message”:“note.load \u001b[90m#29(22) Δ886ms\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.285Z”}
{“query”:"\n SELECT\n note_id AS note,\n photos.id AS photo,\n selections.id AS selection,\n state,\n text,\n language,\n datetime(modified, “localtime”) AS modified\n FROM notes\n LEFT OUTER JOIN photos USING (id)\n LEFT OUTER JOIN selections USING (id)\n WHERE deleted IS NULL\n ORDER BY created ASC",“time”:5,“level”:“debug”,“message”:“db query took 5ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.289Z”}
{“level”:“verbose”,“message”:"*search query took 900ms",“label”:“project”,“timestamp”:“2019-04-10T11:50:01.302Z”}
{“level”:“verbose”,“message”:“qr.update \u001b[90m#30\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.302Z”}
{“query”:"\n \n SELECT DISTINCT id, added\n FROM list_items\n JOIN subjects USING (id)\n \n LEFT OUTER JOIN items USING (id)\n LEFT OUTER JOIN trash USING (id)\n WHERE\n list_id = $list AND list_items.deleted IS NULL AND\n \n \n trash.deleted IS NULL\n \n ORDER BY list_items.added ASC, id ASC",“time”:1,“level”:“debug”,“message”:“db query took 1ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:01.378Z”}
{“level”:“verbose”,“message”:“item.import \u001b[90m#33\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:33.030Z”}
{“level”:“verbose”,“message”:“nav.update \u001b[90m#34\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.324Z”}
{“level”:“verbose”,“message”:“activity.update \u001b[90m#35(33) Δ9s\u001b[39m”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.327Z”}
{“query”:"\n SELECT p.id, item_id AS item\n FROM photos p\n LEFT OUTER JOIN trash tp USING (id)\n LEFT OUTER JOIN trash ti ON (ti.id = item_id)\n WHERE checksum = ?\n AND tp.deleted IS NULL\n AND ti.deleted IS NULL",“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.447Z”}
{“query”:“BEGIN IMMEDIATE TRANSACTION”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.450Z”}
{“query”:"\n INSERT INTO subjects (template) VALUES (?)",“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.458Z”}
{“query”:"\n INSERT INTO items (id) VALUES (?)",“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.460Z”}
{“query”:"\n DELETE FROM metadata WHERE id IN (3495) AND property IN (“http://purl.org/dc/elements/1.1/title")",“time”:0,“level”:“debug”,“message”:"db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.460Z”}
{“query”:"\n SELECT value_id AS id\n FROM metadata_values\n WHERE datatype = ? AND text = ?",“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.460Z”}
{“query”:“PRAGMA ‘main’.data_version”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.461Z”}
{“query”:“SELECT k, v FROM ‘main’.‘fts_metadata_config’”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.461Z”}
{“query”:“PRAGMA ‘main’.data_version”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.463Z”}
{“query”:“REPLACE INTO ‘main’.‘fts_metadata_docsize’ VALUES(?,?)”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.463Z”}
{“query”:“REPLACE INTO ‘main’.‘fts_metadata_data’(id, block) VALUES(?,?)”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.463Z”}
{“query”:“PRAGMA ‘main’.data_version”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.463Z”}
{“query”:“REPLACE INTO ‘main’.‘fts_metadata_data’(id, block) VALUES(?,?)”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.463Z”}
{“query”:“INSERT INTO ‘main’.‘fts_metadata_idx’(segid,term,pgno) VALUES(?,?,?)”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.463Z”}
{“query”:"\n INSERT INTO metadata_values (datatype, text)\n VALUES (?, ?)",“time”:5,“level”:“debug”,“message”:“db query took 5ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.475Z”}
{“query”:“ROLLBACK TRANSACTION”,“time”:0,“level”:“debug”,“message”:“db query took 0ms”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.475Z”}
{“date”:“Wed Apr 10 2019 12:50:42 GMT+0100 (hora de verano británica)”,“process”:{“pid”:6052,“uid”:null,“gid”:null,“cwd”:“C:\Users\Lenovo\AppData\Local\tropy\app-1.4.5”,“execPath”:“C:\Users\Lenovo\AppData\Local\tropy\app-1.4.5\tropy.exe”,“version”:“v10.11.0”,“argv”:[“C:\Users\Lenovo\AppData\Local\tropy\app-1.4.5\tropy.exe”,"–type=renderer","–no-sandbox","–enable-features=SharedArrayBuffer","–service-pipe-token=16620054349419392738","–lang=es","–app-user-model-id=com.squirrel.tropy.tropy","–app-path=C:\Users\Lenovo\AppData\Local\tropy\app-1.4.5\resources\app.asar","–node-integration=true","–webview-tag=true","–no-sandbox","–preload=C:\Users\Lenovo\AppData\Local\tropy\app-1.4.5\resources\app.asar\lib\bootstrap.js","–background-color=#ffffff","–device-scale-factor=1","–num-raster-threads=2","–enable-main-frame-before-activation","–service-request-channel-token=16620054349419392738","–renderer-client-id=4","–mojo-platform-channel-handle=1896","/prefetch:1"],“memoryUsage”:{“rss”:237772800,“heapTotal”:73388032,“heapUsed”:60479448,“external”:41038125}},“os”:{“loadavg”:[0,0,0],“uptime”:5440},“trace”:[],“stack”:[“Error: SQLITE_ERROR: cannot rollback - no transaction is active”],“level”:“error”,“message”:“uncaughtException: SQLITE_ERROR: cannot rollback - no transaction is active”,“label”:“project”,“timestamp”:“2019-04-10T11:50:42.494Z”}


#8

You’re trying to import just a single file, right? Could you possibly share this file with us? Does the import fail for other files as well? Thanks!