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

Eric H. Bowen eric at ehbowen.net
Sun Mar 15 19:16:45 EDT 2020


Thank you, Frank.

    Version: 3.8
    Build ID: 3.8b+(2019-12-29)
    Finance::Quote: 1.47

    Region: USA

    Attaching screenshot of Preferences/General page
    Attaching screenshot of folder/directory

The files are kept on a NAS drive and I run GnuCash mostly on Linux but 
occasionally on Windows (10 and 7)----Eric.

On 3/15/20 4:07 PM, Frank H. Ellenberger wrote:
> 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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: Settings-General.png
Type: image/png
Size: 128724 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200315/52969c92/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Folder.png
Type: image/png
Size: 193142 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200315/52969c92/attachment-0003.png>


More information about the gnucash-user mailing list