Hello. I’ve been happily using Tropy for about 6 months and was finding it very helpful, but today I find I have no access to my database. I hope you can help, as it’s weeks of work gone into it! I get the message above, and here is the log:
{“level”:30,“time”:1676995657013,“type”:“browser”,“name”:“main”,“args”:[],“opts”:{“env”:“production”,“autoUpdates”:true,“contextIsolation”:true,“webgl”:false,“debug”:false,“trace”:false,“data”:“/Users/sarahthomas/Library/Application Support/Tropy”,“cache”:“/Users/sarahthomas/Library/Caches/Tropy”,“logs”:“/Users/sarahthomas/Library/Logs/Tropy”},“version”:“1.12.0”,“msg”:“main.init 1.12.0 Darwin 21.6.0 (x64)”}
{“level”:30,“time”:1676995657175,“type”:“browser”,“name”:“main”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1676995657178,“type”:“browser”,“name”:“main”,“msg”:“app state restored”}
{“level”:30,“time”:1676995657181,“type”:“browser”,“name”:“main”,“msg”:“open new project window”}
{“level”:30,“time”:1676995657399,“type”:“browser”,“name”:“main”,“msg”:“switch to "light" theme”}
{“level”:30,“time”:1676995657412,“type”:“browser”,“name”:“main”,“msg”:“checking for updates…”}
{“level”:30,“time”:1676995658342,“type”:“renderer”,“name”:“project”,“dpx”:0.75,“opts”:{“env”:“production”,“documents”:“/Users/sarahthomas/Documents”,“pictures”:“/Users/sarahthomas/Pictures”,“theme”:“light”,“contrast”:false,“dark”:false,“scrollbars”:true,“vibrancy”:false,“recent”:[“/Users/sarahthomas/Documents/Slavery and the British Art Collector, 1768-1833.tpy”],“data”:“/Users/sarahthomas/Library/Application Support/Tropy”,“debug”:false,“dev”:false,“cache”:“/Users/sarahthomas/Library/Caches/Tropy”,“plugins”:“/Users/sarahthomas/Library/Application Support/Tropy/plugins”,“fontSize”:“16px”,“frameless”:true,“level”:“info”,“locale”:“en”,“log”:“/Users/sarahthomas/Library/Logs/Tropy/tropy.log”,“uuid”:“7ce3a9b0-5128-11ed-9a73-a3f91988e4da”,“update”:{},“version”:“1.12.0”,“webgl”:true,“zoom”:0.75,“maximizable”:true,“minimizable”:true},“msg”:“project.init”}
{“level”:30,“time”:1676995658377,“type”:“renderer”,“name”:“project”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1676995658377,“type”:“renderer”,“name”:“project”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1676995658408,“type”:“browser”,“name”:“main”,“msg”:“ready after 1155.5380859375ms”}
{“level”:30,“time”:1676995658901,“type”:“renderer”,“name”:“project”,“msg”:“restoring recent@tropy”}
{“level”:30,“time”:1676995658905,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1676995658905,“type”:“renderer”,“name”:“project”,“msg”:“restoring ui@tropy”}
{“level”:30,“time”:1676995658921,“type”:“renderer”,“name”:“project”,“mode”:“w+”,“msg”:“open db /Users/sarahthomas/Library/Application Support/Tropy/ontology.db”}
{“level”:30,“time”:1676995659203,“type”:“renderer”,“name”:“project”,“msg”:“project ready 1877ms [dom:1022ms win:256ms req:295ms]”}
{“level”:30,“time”:1676995667977,“type”:“browser”,“name”:“main”,“msg”:“no updates available”}
{“level”:30,“time”:1676995673337,“type”:“renderer”,“name”:“project”,“msg”:“Esper.instance created using webgl renderer”}
{“level”:30,“time”:1676995673516,“type”:“renderer”,“name”:“project”,“mode”:“r”,“msg”:“open db /Users/sarahthomas/Documents/Slavery and the British Art Collector, 1768-1833.tpy”}
{“level”:40,“time”:1676995673555,“type”:“renderer”,“name”:“project”,“stack”:“Error: SQLITE_CANTOPEN: unable to open database file”,“msg”:“db error”}
{“level”:40,“time”:1676995673556,“type”:“renderer”,“name”:“project”,“action”:“project.close”,“meta”:{“seq”:8,“now”:1676995673556},“msg”:“project.close failed: SQLITE_CANTOPEN: unable to open database file”,“stack”:“Error: SQLITE_CANTOPEN: unable to open database file”}
It’s possible that you moved or renamed your project file (maybe by accident):
Can you check if this file exists?
Ah, you’re right. I’ve just found it in another strange place and been able to restore it, so disaster averted! It’s a separate issue with accidentally moving folders. Thanks very much. Sarah