Hello! I'm unable to read my MariaDB database since GnuCash has been updated to version 2.6.20-1. My environment: Fedora Linux 27 x86_64, GnuCash 2.6.20-1, mariadb 10.2.14-1, libdbi 0.9.0-9. Error message is: "GnuCash could not complete a critical test for the presence of a bug in the "libdbi" library. This may be caused by a permissions misconfiguration of your SQL database. Please see https://bugzilla.gnome.org/show_bug.cgi?id=645216 for more information." In a fact, GnuCash is trying to recreate 'numtest' table. Exactly this thing has changed since 2.6.18 (previous package version in Fedora repos). Now GnuCash is trying to recreate table by using strange SINGLE query 'DROP TABLE IF EXISTS numtest;CREATE TEMPORARY TABLE numtest ( test_int BIGINT, test_unsigned BIGINT, test_double FLOAT8 )'. MariaDB doesn't understand it and returns 'syntax error' response. As I think, recreation of this table should be performed by executing of TWO separate queries: DROP TABLE IF EXISTS numtest CREATE TEMPORARY TABLE numtest ( test_int BIGINT, test_unsigned BIGINT, test_double FLOAT8 ) In this case everything will work fine. Thanks in advance, Alexey Kosilin
I forgot to mention that I went back to version 2.6.19 and saved the database using the xml format. I tried to open that in version 3.0 and ran into the same error. So it's not anything specific to the database.
(In reply to Jim Y from comment #1) > I forgot to mention that I went back to version 2.6.19 and saved the > database using the xml format. I tried to open that in version 3.0 and ran > into the same error. So it's not anything specific to the database. Are you commenting on the wrong bug?
I've got a fix for this committed but not pushed because it turns out that it doesn't affect unstable. I want to confer with Geert about whether we should have a 2.6.21.
I think, in this case we should.
Fixed. We'll release 2.6.21 shortly.
(In reply to John Ralls from comment #5) > Fixed. We'll release 2.6.21 shortly. Ok. Thank you very much! Best regards, Alexey Kosilin
*** Bug 795206 has been marked as a duplicate of this bug. ***
