After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 796088 - Can't open associated file/locations with sqlite backend.
Can't open associated file/locations with sqlite backend.
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Register
3.1
Other Linux
: Normal normal
: future
Assigned To: gnucash-ui-maint
gnucash-ui-maint
Depends on:
Blocks:
 
 
Reported: 2018-05-14 04:45 UTC by Tim Vail
Modified: 2018-06-30 00:10 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Tim Vail 2018-05-14 04:45:35 UTC
When using the sqlite backend, right clicking on a transaction that already has an associated file/location does not allow us to open the associated file/location.

Easily reproducible:
1. You must be using sqlite backend.
2. Right click a transaction, associate with a file/location.
3. After associating, you can verify that it is associated by opening it (right clicking again, open it).
4. Quit gnucash (might work to just open another gnucash file then come back).
5. Open the sqlite file again in gnucash.
6. Go back to the transaction where you made the association.  The "open file/location" option is grayed out.

When I examined the sqlite database, it looks like the association record *does* show up in the slots table, so it seems like it is saving the association, but not loading it properly when first opening up the file.
Comment 1 John Ralls 2018-05-26 19:31:23 UTC
This may be related to Bug 796369. Can you build maint HEAD and see if the problem is fixed?
Comment 2 Tim Vail 2018-05-27 21:03:03 UTC
Yup, maint HEAD build is showing all the associated locations for transactions again.  Thanks!
Comment 3 John Ralls 2018-05-28 00:09:16 UTC
Super. Thanks for reporting back.
Comment 4 John Ralls 2018-06-30 00:10:04 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=796088. Please update any external references or bookmarks.