John Ralls,
That did the trick!
Thanks!
On 10/31/2025 11:32 AM, John Ralls wrote:
I merged Sherlock’s PR yesterday so it should be included in today’s
nightly:
https://code.gnucash.org/builds/win32/stable/gnucash-5.13-2025-10-31-git-5.13-32-g3956d7e52f+.setup.exe
If you haven’t already, please try that. If you have and it still
doesn’t open your SQLite3 file then we have some more work to do.
Regards,
John Ralls
On Oct 31, 2025, at 07:54, Xe Roy <[email protected]> wrote:
I still cannot use gnucash.
Should I keep downloading the latest stable version or is the "No
suitable backend was found for [sqlite3.gnucash file]" not on the fix
list any time soon?
Or should I just fall back to 5.12?
If I install 5.12, will it overwrite 5.13?
-------- Forwarded Message --------
Subject: Re: [GNC] Sluggish after 5.13
Date: Thu, 30 Oct 2025 11:11:42 -0700
From: John Ralls <[email protected]>
To: Sherlock <[email protected]>
CC: [email protected]
Sherlock,
Fixing the code is always the right answer. Setting GNC_DBD_DIR in
the Mac bundle file does no harm so there’s no rush to remove it.
Regards,
John Ralls
On Oct 30, 2025, at 10:31 AM, Sherlock <[email protected]> wrote:
John,
Thanks. That explains why only Windows appears broken.
So, is the intent to use GNC_DBD_DIR on Windows as well or should we
fix the code and not use GNC_DBD_DIR to work around the issue on Mac?
Regards,
Sherlock
On 10/30/25 8:28 AM, John Ralls wrote:
Sherlock,
It doesn’t affect the Mac Bundle because that defines GNC_DBD_DIR
to point to the bundle’s Resources/lib/dbd in the environment file.
Mingw64 doesn’t provide libdbi so it’s built by jhbuild. We set the
dbd-driver directory to the installation prefix,
https://github.com/Gnucash/gnucash-on-windows/blob/668227c9651224bd0a0f9ce87713546ccfca9af8/jhbuildrc.in#L82.
Regards,
John Ralls
On Oct 29, 2025, at 20:02, Sherlock <[email protected]> wrote:
I've been trying to understand why this hasn't been an issue on
the other platforms that have been on libdbi 0.9.1 for sometime.
The generic bug was introduced 2 years ago (commit b011c81). I
suspect the issue isn't seen on Linux where libdbi is installed in
the system location or on a Mac build machine. I think the issue
should appear on non-build Macs but, of course, the issue won't be
apparent to a user unless they aren't using the xml format.
Regards,
Sherlock
On 10/29/25 6:54 PM, Sherlock wrote:
I maybe wrong about the c:\libdbi\lib\dbd folder as there are
compile time definition that will override the location which
appears to be something like /mingw32/lib/dbd but that should
still typically miss in a typical user's gnucash installation.
Setting GNC_DBD_DIR to something like C:\Program Files
(x86)\gnucash\lib\dbd should work around the issue.
Regards,
Sherlock
On 10/29/25 4:32 PM, Sherlock wrote:
Hi John,
I suspect the Windows nightly builds have not been properly
supporting databases since libdbi was updated to 0.9.1 on
October 5th unless the drivers are in the c:\libdbi\lib\dbd
folder or the folder to which the GNC_DBD_DIR environment
variable is set.
For example, attempt to save as sqlite3.
It appears there is a generic bug in
gnc_module_init_backend_dbi() when HAVE_LIBDBI_R is defined.
Specifically, when the initial dbi_initialize_r() returns no
drivers, the dbi_instance variable is still set.
So, instead of:
#if HAVE_LIBDBI_R
if (dbi_instance)
return;
#endif
the code should be:
#if HAVE_LIBDBI_R
if (dbi_instance)
{
dbi_shutdown_r (dbi_instance);
dbi_instance = nullptr;
}
#endif
Regards,
Sherlock
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
