Hi Eric, You may need to provide further info on this, i.e what version of gnucash are you using and on what OS ?
You say your file is saved as xml so I'm a bit surprised to see sql dbi related error messages in your trace file. So just to remove all doubt - your file is definitely xml and has a ".gnucash" suffix on the file name ??? Seems that it doesn't like your date of 2020/2/6 - 6th Feb 2020 ? If your file is definitely xml it's probably compressed so can't be searched. You can go to Preferences >>General >> Files and uncheck "Compress Files" and save it as an uncompressed file which will allow you to open it with a text editor and search for the 2020/2/6 and compare it with other dates and see if they look the same. If you do this copy your data file and work on a copy until you find the problem. Regards David. On Mon, 16 Mar 2020 at 06:31, Eric H. Bowen via gnucash-user < gnucash-user@gnucash.org> wrote: > 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 > * 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]. > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.