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

Frank H. Ellenberger frank.h.ellenberger at gmail.com
Sun Mar 15 17:07:47 EDT 2020


Hello Eric,

with the trace file your request looks slightly better. How about your
Gnucash version, selected backend, region ...?

From

Am 15.03.20 um 21:29 schrieb Eric H. Bowen via gnucash-user:
> 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

I fear, you have to consult the manual for the backend you are using
(SQLite, MySQL, PostgreSQL, ...) or ask the corresponding community.

> * 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].

That date is in the future. It seems, somebody changed the date format
(order of day and month).

Regards
Frank


More information about the gnucash-user mailing list