> On May 25, 2018, at 3:42 PM, maniek <settl...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
