Import nested folders not working
in progress
Jamie Carl
I have switched OSes from Windows to Linux. On Windows I exported all my workspaces from Yaak. No issues there.
However importing them on Linux gives me the error:
Import failed
error returned from database: (code: 787) FOREIGN KEY constraint failed
Linux distro is KDE Neon.
Yaak is a fresh "install". ie: running AppImage but I tried purging all the configs and cache.
The workspaces are imported, however they are all empty except for one which contains a folder, but nothing else.
I'm not sure if this is part of another problem as I haven't really used Yaak on Linux just yet, but my usual poking around has not revealed any other issues.
Please help! Many thanks.
É
Étienne Lévesque
I ran into a similar issue that I think might share the same root cause. When importing a json file previously exported from Yaak, insertion can fail if the folders are not sorted hierarchically in the json file.
See the attached Yaak export as an example.
Trying to import this into Yaak results in a "SQL Error" for me because the first folder depends on the second, leading to a foreign key error in SQLite. If you swap the folders in the json export it can then be imported successfully.
Also note that this bug is easy to miss when tested for naively (exporting a workspace and immediately importing it back) because the folders are already present in the database so there's no foreign key issue. The simplest way to test this is to export a workspace, delete it, and then import it back in.
MacOS, M2 Pro, Yaak 2024.8.0-beta.2
nit: it would be nice if the backend errors were logged somewhere. I managed to debug this through trial-and-error and inspection of the SQLite DB but having access to the actual SQL error message would have made this a fair bit easier.
Gregory Schier
in progress
Gregory Schier
planned
É
Étienne Lévesque
I ran into a similar issue that I think might share the same root cause. When importing a json file previously exported from Yaak, insertion can fail if the folders are not sorted hierarchically in the json file.
See the attached Yaak export as an example.
Trying to import this into Yaak results in a "SQL Error" for me because the first folder depends on the second, leading to a foreign key error in SQLite. If you swap the folders in the json export it can then be imported successfully.
Also note that this bug is easy to miss when tested for naively (exporting a workspace and immediately importing it back) because the folders are already present in the database so there's no foreign key issue. The simplest way to test this is to export a workspace, delete it, and then import it back in.
MacOS, M2 Pro, Yaak 2024.8.0-beta.2
nit: it would be nice if the backend errors were logged somewhere. I managed to debug this through trial-and-error and inspection of the SQLite DB but having access to the actual SQL error message would have made this a fair bit easier.
Gregory Schier
Étienne Lévesque: thank you for the detailed explanation! I never thought of this but it makes perfect sense
Gregory Schier
under review
Is this still an issue in the latest release?
Jamie Carl
Gregory Schier Yes. Same issue. No change.
Gregory Schier
Jamie Carl any chance you could provide a sample export that reproduces it?
Jamie Carl
Gregory Schier I have a file I'm happy to provide. Canny will not let me attach anything other than an image though and it is over the 2500 character limit to post as a comment. Is there another way I can get it to you?
Jamie Carl
Gregory Schier Actually, try this: https://drive.google.com/file/d/1XHGXQh0HyA9GoZo5d36oL2VYOghwO0wQ/view?usp=drive_link
Gregory Schier
Jamie Carl: Requested access 👍�