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 645554 - MySQL backend fails to open after upgrade to 2.4.4 on Wiin 7 (64bit)
MySQL backend fails to open after upgrade to 2.4.4 on Wiin 7 (64bit)
Status: RESOLVED DUPLICATE of bug 645216
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.4.x
Other Windows
: Normal normal
: ---
Assigned To: Phil Longstaff
Geert Janssens
Depends on:
Blocks:
 
 
Reported: 2011-03-22 16:56 UTC by Colin F
Modified: 2018-06-29 22:55 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Colin F 2011-03-22 16:56:20 UTC 
I was using 2.4.0 with MySQL database on Win 7 Home Premium (64 bit).
On upgrading GnuCash to 2.4.4. I get the following error message:
The library "libdbi" installed on your system doesn't correctly store large numbers.  This means GnuCash cannot use SQL databases correctly.  Gnucash will not open or save to SQL databases until this is fixed by installing a different version of "libdbi".  Please see https://bugzilla.gnome.org/show_bug.cgi?id=611936 for more information.

The specified bug report does not help and I have no idea where a "different" version of libdbi for Windows may be obtained. I have tried the files installed with 2.4.0 with 2.4.4 but that didn't help. The same problem occurs with 2.4.2 as well.
I will return to using 2.4.0 for the time being.
Comment 1 John Ralls 2011-03-22 18:24:57 UTC 
Please check that the userid you gave to Gnucash for your MySql database has CREATE TABLE privilege.
Comment 2 Colin F 2011-03-22 18:59:16 UTC 
Userid had CREATE TABLE but not CREATE TEMPORARY TABLE. Adding the later privilege seems to have resolved the problem.

Thanks
Comment 3 John Ralls 2011-03-22 20:47:47 UTC 

*** This bug has been marked as a duplicate of bug 645216 ***
Comment 4 John Ralls 2017-09-24 22:46:23 UTC 
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 5 John Ralls 2018-06-29 22:55:42 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=645554. Please update any external references or bookmarks.