Can't start Tropy due to SQLIGHT_CORRUPT error

I’m new to Tropy and have recently installed it. Multiple times, over and over, I get an error message & then I can’t access my new project. I’ve deleted the project three times and started over, but then I just get the error message again.

Each time, I make one new list, into which I put 5 images. None are especially large. I have filled in the information for them. I then went to close the project, received the error message and once again can’t open the project :frowning:

I’m not sure what I’m doing wrong.

(I have Windows 11 64-bit). I’ve installed Tropy on pCloud and have created a separate folder for images adjacent to it (also in pCloud, in the same folder).

This is the current error message log:
{“level”:30,“time”:1706963826247,“type”:“browser”,“name”:“main”,“args”:,“opts”:{“env”:“production”,“autoUpdates”:true,“contextIsolation”:true,“webgl”:false,“verbose”:false,“trace”:false,“data”:“C:\Users\Markha\AppData\Roaming\Tropy”,“cache”:“C:\Users\Markha\AppData\Roaming\Tropy\cache”,“logs”:“C:\Users\Markha\AppData\Roaming\Tropy\log”},“version”:“1.15.2”,“msg”:“main.init 1.15.2 Windows_NT 10.0.22631 (x64)”}
{“level”:30,“time”:1706963826275,“type”:“browser”,“name”:“main”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1706963826280,“type”:“browser”,“name”:“main”,“msg”:“app state restored”}
{“level”:30,“time”:1706963826281,“type”:“browser”,“name”:“main”,“file”:“P:\TROPY\BOOK - Culture Wars - Religion, Race, Democracy.tropy”,“msg”:“open new project window”}
{“level”:30,“time”:1706963826556,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:30,“time”:1706963826651,“type”:“renderer”,“name”:“project”,“dpx”:1,“args”:{“frameless”:true,“locale”:“en”,“webgl”:true,“zoom”:1},“msg”:“project.init”}
{“level”:30,“time”:1706963826676,“type”:“renderer”,“name”:“project”,“msg”:“plugins scanned: 0”}
{“level”:30,“time”:1706963826676,“type”:“renderer”,“name”:“project”,“msg”:“plugins loaded: 0”}
{“level”:30,“time”:1706963826940,“type”:“renderer”,“name”:“project”,“msg”:“restoring projectFiles@tropy”}
{“level”:30,“time”:1706963826947,“type”:“browser”,“name”:“main”,“msg”:“ready after 369.970947265625ms”}
{“level”:30,“time”:1706963826940,“type”:“renderer”,“name”:“project”,“msg”:“restoring recent@tropy”}
{“level”:30,“time”:1706963826940,“type”:“renderer”,“name”:“project”,“msg”:“restoring settings@tropy”}
{“level”:30,“time”:1706963826941,“type”:“renderer”,“name”:“project”,“msg”:“restoring ui@tropy”}
{“level”:30,“time”:1706963826943,“type”:“renderer”,“name”:“project”,“mode”:“w+”,“msg”:“open db C:\Users\Markha\AppData\Roaming\Tropy\ontology.db”}
{“level”:30,“time”:1706963826959,“type”:“renderer”,“name”:“project”,“msg”:“project ready 589ms [dom:298ms init:24ms load:251ms]”}
{“level”:30,“time”:1706963827067,“type”:“renderer”,“name”:“project”,“mode”:“webgl”,“resolution”:1,“msg”:“Esper.instance created with webgl renderer”}
{“level”:30,“time”:1706963827084,“type”:“renderer”,“name”:“project”,“mode”:“w”,“msg”:“open db P:\TROPY\BOOK - Culture Wars - Religion, Race, Democracy.tropy\project.tpy”}
{“level”:30,“time”:1706963827104,“type”:“renderer”,“name”:“project”,“msg”:“db query took 124ms”,“query”:“\n SELECT count(*) AS count FROM sqlite_schema”,“ms”:124}
{“level”:40,“time”:1706963827125,“type”:“renderer”,“name”:“project”,“stack”:“Error: SQLITE_CORRUPT: vtable constructor failed: fts_notes”,“msg”:“unexpected error in *project.open”}
{“level”:30,“time”:1706963886282,“type”:“browser”,“name”:“main”,“msg”:“checking for updates…”}
{“level”:30,“time”:1706963887204,“type”:“browser”,“name”:“main”,“msg”:“no updates available”}
{“level”:30,“time”:1706963946627,“type”:“browser”,“name”:“main”,“status”:{“2d_canvas”:“enabled”,“canvas_oop_rasterization”:“enabled_on”,“direct_rendering_display_compositor”:“disabled_off_ok”,“gpu_compositing”:“enabled”,“multiple_raster_threads”:“enabled_on”,“opengl”:“enabled_on”,“rasterization”:“enabled”,“raw_draw”:“disabled_off_ok”,“video_decode”:“enabled”,“video_encode”:“enabled”,“vulkan”:“disabled_off”,“webgl”:“enabled”,“webgl2”:“enabled”,“webgpu”:“enabled”},“msg”:“gpu-info-update”}
{“level”:40,“time”:1706964081538,“type”:“renderer”,“name”:“project”,“action”:“project.closed”,“meta”:{“ipc”:true,“seq”:9,“now”:1706964081538},“msg”:“project.closed failed: SQLITE_CORRUPT: vtable constructor failed: fts_notes”,“stack”:“Error: SQLITE_CORRUPT: vtable constructor failed: fts_notes”}
{“level”:30,“time”:1706964081592,“type”:“renderer”,“name”:“project”,“mode”:“r”,“msg”:“open db P:\TROPY\BOOK - Culture Wars - Religion, Race, Democracy.tropy\project.tpy”}
{“level”:40,“time”:1706964081605,“type”:“renderer”,“name”:“project”,“stack”:“Error: SQLITE_CORRUPT: database disk image is malformed”,“msg”:“failed to stat project file ‘P:\TROPY\BOOK - Culture Wars - Religion, Race, Democracy.tropy’”}

There’s got to be something about the the way pCloud syncs your file that interefers with Tropy. When you open the project Tropy opens the project.tpy file in your project folder. As you make changes to the project, Tropy writes these changes to the file. If your computer is idle, Tropy will close the file handles and open them again if you keep making changes. It’s important that while Tropy has an open handle to the file no other application changes the file. I’d suspect that pCloud does something to the file when it syncs it – that interferes with the subsequent write by Tropy. Could you try verifying this by creating a project in a folder outside of pCloud?

Thank you so much for getting back to me quickly. What you say makes sense (unfortunately). I’ve now tried it with a tropy project and its associated image bank stored on my desktop instead of in pCloud and everything is working like a dream.

I still have the problem then of how to access my project across multiple devices (work/home/travel). I originally set my project up in pCloud so that I could access it everywhere. Since that won’t work, would you happen to know a different solution?