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

[Eric H. Bowen]

On 3/15/20 4:36 PM, Christopher Lam wrote:
>
> On Sun, 15 Mar 2020 at 20:31, Eric H. Bowen via gnucash-user 
> <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>> wrote:
>
>     * 14:57:56  WARN <gnc.scm> qif-parse:parse-date/format: format is
>     y-d-m
>     but date is [2020/2/6].
>
>
> This warning only appears during QIF imports, and shouldn't appear in 
> regular load/save to/from SQL or XML.

Correct. That particular error occurs only when I am importing 
downloaded transactions from my bank, which does not use ISO date 
format, and is merely a minor inconvenience. The error which I am 
concerned about also involves imported transactions, and appears to be 
related to the database which attempts to automatically match 
transactions to their proper accounts. Here is my most recent 
gnucash.trace file, following such an import:

    * 17:57:27 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 11:
    database disk image is malformed
    * 17:57:27 ERROR <gnc.backend.dbi>
    [GncDbiSqlConnection::execute_select_statement()] Error executing
    SQL SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM
    accounts)
    * 17:57:27 ERROR <gnc.backend.dbi>
    [GncDbiSqlResult::~GncDbiSqlResult()] Error 11 in dbi_result_free()
    result.
    * 17:57:28 ERROR <gnc.backend.dbi> [error_handler()] DBI error: 11:
    database disk image is malformed
    * 17:57:28 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))
    * 17:57:28 ERROR <gnc.backend.dbi>
    [GncDbiSqlResult::~GncDbiSqlResult()] Error 11 in dbi_result_free()
    result.