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 747300 - SQL backend missing from most recent DMG?
SQL backend missing from most recent DMG?
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: MacOS
2.6.6
Other Mac OS
: Normal normal
: ---
Assigned To: John Ralls
gnucash-mac-maint
Depends on:
Blocks:
 
 
Reported: 2015-04-03 14:09 UTC by j.a.burgoyne
Modified: 2018-06-29 23:40 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description j.a.burgoyne 2015-04-03 14:09:10 UTC 
Is the SQL backend missing from the most recent Mac OS X DMS (2.6.6-2)? After upgrading from 2.6.5, my usual file no longer opens, with the message: 'No suitable backend was found for file MYFILE.gnucash.' Downgrading back to 2.6.5, there are no problems. 

(I should note that I'm not 100 percent certain that my file uses the SQL backend, but I *think* I upgraded a while back. Is there a relatively easy way to check?)
Comment 1 John Ralls 2015-04-03 15:39:42 UTC 
Not missing, just borked. Gnucash.app/Contents/Resources/etc/gnucash/environment is over-riding the GNC_DBD_DIR setting in Gnucash.app/Contents/MacOS/Gnucash to the wrong value.

I'll get a new dmg up shortly, but in the meantime you can edit Gnucash.app/Resources/etc/gnucash/environment to remove the GNC_DBD_DIR line. 
Right-click on Gnucash.app in Finder and select "Show Package Contents", which will change the window to show the Contents folder. Navigate to Resources/etc/gnucash and open "environment" with TextEdit. Remove the line beginning with "GNC_DBD_DIR" and save the file. (Ignore the file named "environment~"). Restart Gnucash and it should happily open your file.
Comment 2 John Ralls 2015-04-03 16:30:24 UTC 
New dmgs are in place.
Comment 3 John Ralls 2015-04-03 22:34:01 UTC 
Commit 1d6fd55 does away with the need to set GNC_DBD_DIR in either the launcher script or etc/gnucash/environment and offers a fallback if it is set but invalid. That should permanently prevent this problem recurring.
Comment 4 John Ralls 2018-06-29 23:40:05 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=747300. Please update any external references or bookmarks.