[GNC] How to fix "Unable to Save to Database" error - Second Request

[David H]

Hi Eric,

You may need to provide further info on this, i.e what version of gnucash
are you using and on what OS ?

You say your file is saved as xml so I'm a bit surprised to see sql dbi
related error messages in your trace file. So just to remove all doubt -
your file is definitely xml and has a ".gnucash" suffix on the file name
???  Seems that it doesn't like your date of 2020/2/6  - 6th Feb 2020 ?

If your file is definitely xml it's probably compressed so can't be
searched.  You can go to Preferences >>General >> Files and uncheck
"Compress Files" and save it as an uncompressed file which will allow you
to open it with a text editor and search for the 2020/2/6 and compare it
with other dates and see if they look the same.  If you do this copy your
data file and work on a copy until you find the problem.

Regards David.



On Mon, 16 Mar 2020 at 06:31, Eric H. Bowen via gnucash-user <
gnucash-user at gnucash.org> wrote:

> I still have not been able to repair my "Unable to Save to Database"
> error in GnuCash. I've found the gnucash.trace file, which has the error
> messages, but so far I haven't been able to find any clue for repairing
> a database saved in .xml format. Assistance requested.
>
> Trace file follows:
>
> * 14:57:56  WARN <gnc.scm> qif-parse:parse-date/format: format is y-d-m
> but date is [2020/2/6].
> * 15:00:34 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR <gnc.backend.dbi>
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
> * 15:00:34 ERROR <gnc.backend.dbi> [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:00:34 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR <gnc.backend.dbi>
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM splits
> WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))
> * 15:00:34 ERROR <gnc.backend.dbi> [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:01:20  WARN <gnc.scm> qif-parse:parse-date/format: format is y-d-m
> but date is [2020/2/6].
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>