[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