Hi, I just installed v3.8 on my Windows 10 machine (not sure exactly which version I had previously, but it was at least v3.6). I save in the sqlite format.
When I open my file, all the account have zero balances. Double-clicking on an account brings up an empty register (i.e. no transactions). Closing the account generates the message 'unable to save to database'. Here's what I've done so far: 1. A google search got me to this post experiencing a similar error message: http://gnucash.1415818.n4.nabble.com/GNC-Unable-to-save-to-database-Build-ID-3-2-2018-06-24-td4702739.html. 2. I took a look at https://wiki.gnucash.org/wiki/Tracefile to find the trace file on my system. 3. Took a look at the trace file. It had lots of errors like this /* 06:14:22 ERROR <gnc.backend.dbi> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL SELECT * FROM transactions WHERE guid IN (SELECT DISTINCT tx_guid FROM splits WHERE account_guid = 'fd3362e93c5d4c55977254dfd1ee61a9') * 06:14:22 ERROR <gnc.backend.dbi> [error_handler()] DBI *error: 1: no such table: splits*/ 4. Opened up my sqlite gnucash file in a viewer and noted that the *splits* table no longer exists, but there is a *splits_new* table. My question is, is there any harm in just dropping the *_new* suffix to rename the table back to *splits*? brob2684 -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _______________________________________________ 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.
