[putting back the bug in CC] Bruce LaZerte <bruce.laze...@gmail.com> writes:
> XML file attached.
> Created with Gnucash 2.4.10 R21973 from Debian's "testing" repository
Thanks for sending me privately your datafile.
I was able to reproduce your problem. When gnucash is run with debug
mode turned on, I get this message in the log:
* 11:34:15 CRIT <gnc.backend.dbi> [sqlite3_error_fn()] DBI error: 19: column
guid is not unique
* 11:34:15 CRIT <gnc.backend.dbi> [conn_execute_nonselect_statement()] Error
executing SQL INSERT INTO
splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom,lot_guid)
VALUES('4e554c4c475549442e454d5054592e00','c88db69375131aa31f12577148974e80','63423f9af9043efd73c57f3392dd600e','','','n',NULL,0,100,0,100,NULL)
* 11:34:15 CRIT <gnc.backend.sql> [gnc_sql_do_db_operation()] SQL error:
INSERT INTO
splits(guid,tx_guid,account_guid,memo,action,reconcile_state,reconcile_date,value_num,value_denom,quantity_num,quantity_denom,lot_guid)
VALUES('4e554c4c475549442e454d5054592e00','c88db69375131aa31f12577148974e80','63423f9af9043efd73c57f3392dd600e','','','n',NULL,0,100,0,100,NULL)
* 11:34:15 CRIT <gnc.backend.sql> [save_transaction()] Transaction dated
07/08/2006 in account Orphan-CAD not saved due to Split save failed. Check
trace log for SQL errors.
So the cause of the problem is that your datafile is corrupted. There is
a duplicate guid.
The good news is that there is an easy fix: in the Orphan-CAD account,
delete the first empty transaction dated 07/08/2006. With that change, I
was able to save your file in sqlite3.
Can you try this out, and tell me if this fixes the problem for you
also?
Best,
--
.''`. Sébastien Villemot
: :' : Debian Maintainer
`. `' http://www.dynare.org/sebastien
`- GPG Key: 4096R/381A7594
pgpbHjHnFXLS9.pgp
Description: PGP signature
