[GNC] Gnucash 3.1 and fedora 28

[John Ralls]

> On May 25, 2018, at 3:42 PM, maniek <settlerk at gmail.com> wrote:
> 
> Hello,
> 
> I've been using GnuCash for 6 years now. Today I upgraded my fedora from 27
> to 28 so GnuCash as well (from 2.6.x to 3.1). Unfortunately, it does not
> work correctly. My database is automatically cleaned. After typing a
> password to the database, I can see an only blank page. 
> 
> I generated a gnucash.trace and I found:
> 
> 00:34:16  INFO <gnc.backend.sql> [query_transactions] Query SELECT * FROM
> transactions returned no results
> 
> the most interesting thing is that after restoring the database from a
> backup I can run above command and see all transactions. Then I open
> gnucash, see blank page, close and again output of above command returns:
> MariaDB [gnucash_2018]> SELECT * FROM transactions;
> Empty set (0.00 sec)
> 
> GnuCash or sth erases all records from the databases.
> I have this problem only with my latest database (for 2018, created a few
> months ago and worked properly under 2.6.x), old databases such 2017, 2016
> are opening correctly and no data is erased.
> MariaDB version is 10.2.14-1.fc28.x86_64
> 
> Any idea?


https://bugzilla.gnome.org/show_bug.cgi?id=796117 <https://bugzilla.gnome.org/show_bug.cgi?id=796117>, which is next on my list. The bit about it only being the newest database is interesting. Can you try running GnuCash with --log gnc.backend.dbi=debug? That will still eat your database but it will write to the trace file every query, which should give some clues about what’s happening.

Regards,
John Ralls