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

[Eric H. Bowen via gnucash-user]

Well, if it's that simple then just hit me over the head with a wet fish 
and say "D'oh!"


I have re-saved the file. Waiting to get some fresh transactions from 
the checking account to import in order to see if that does the trick. 
Should have some in the morning. Fingers crossed. Thanks, allEric.


On 3/15/20 10:26 PM, John Ralls wrote:

You're using a SQLite3 database, not and XML file, and SQLIte3 thinks that its 
file has gotten corrupted. If you have backups you should make sure that the 
one or two from just ´before the first time you encountered the error are safe 
and available. If you don't have backups then this is a message from your deity 
to start keeping regular ones.

I think the simplest fix is to re-save to a new file using File>Save As... I 
suggest doing it twice, one XML and the other SQLite3. You pick which one with the 
list box on the top of the Save As dialog box.

Regards,
John Ralls



On Mar 15, 2020, at 4:53 PM, Eric H. Bowen via gnucash-user 
 wrote:

I'm seeing the error on all three operating systems, although it first appeared on the 
Windows 10 computer. The pop-up error message does appear only when importing 
transactions, and only from one specific account (my personal checking account) at that, 
and since it seemed as though the transaction records were not affected I put up with it 
for several months as just a nuisance. However, recently I've been trying to reconcile a 
loan account for a vehicle which was totaled and paid off by insurance, and when I try to 
balance the liability of the loan off against the asset for the value of the vehicle it 
seems to post properly for that session...but when I restart Gnucash for the next 
session, the amount has moved back to "Imbalance". A couple of other 
transactions are doing this as well, but the auto payoff is the big'un. I want to get the 
known error taken care of first, and then when the imports are back to working properly I 
want to see if I'm still having problems balancing out these transactions and, if I do, 
I'll post a separate request to the listEric.

On 3/15/20 6:30 PM, David H wrote:

Hi Eric,

Yep saw that.  What OS are you seeing the error on, or is it on all of them ? 
Just saw your other post, so you are getting this when trying to import 
transactions NOT when saving your Gnucash data file.

Cheers David.


On Mon, 16 Mar 2020 at 09:19, Eric H. Bowen mailto:e...@ehbowen.net>> wrote:

Hello, David. More info in the message I just posted. I do use ISO
date format (-mm-dd) for all of my computer-related workEric


On 3/15/20 4:22 PM, David H wrote:


On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger
mailto:frank.h.ellenber...@gmail.com>> wrote:

> * 15:01:20 WARN  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).

Hmm transaction dates can be in the future, this looks like 6th
Feb 2020 to me in ccyy-m-d format ?

Cheers David.


___
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.

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

[John Ralls]

You're using a SQLite3 database, not and XML file, and SQLIte3 thinks that its 
file has gotten corrupted. If you have backups you should make sure that the 
one or two from just ´before the first time you encountered the error are safe 
and available. If you don't have backups then this is a message from your deity 
to start keeping regular ones.

I think the simplest fix is to re-save to a new file using File>Save As... I 
suggest doing it twice, one XML and the other SQLite3. You pick which one with 
the list box on the top of the Save As dialog box. 

Regards,
John Ralls


> On Mar 15, 2020, at 4:53 PM, Eric H. Bowen via gnucash-user 
>  wrote:
> 
> I'm seeing the error on all three operating systems, although it first 
> appeared on the Windows 10 computer. The pop-up error message does appear 
> only when importing transactions, and only from one specific account (my 
> personal checking account) at that, and since it seemed as though the 
> transaction records were not affected I put up with it for several months as 
> just a nuisance. However, recently I've been trying to reconcile a loan 
> account for a vehicle which was totaled and paid off by insurance, and when I 
> try to balance the liability of the loan off against the asset for the value 
> of the vehicle it seems to post properly for that session...but when I 
> restart Gnucash for the next session, the amount has moved back to 
> "Imbalance". A couple of other transactions are doing this as well, but the 
> auto payoff is the big'un. I want to get the known error taken care of first, 
> and then when the imports are back to working properly I want to see if I'm 
> still having problems balancing out these transactions and, if I do, I'll 
> post a separate request to the listEric.
> 
> On 3/15/20 6:30 PM, David H wrote:
>> Hi Eric,
>> 
>> Yep saw that.  What OS are you seeing the error on, or is it on all of them 
>> ? Just saw your other post, so you are getting this when trying to import 
>> transactions NOT when saving your Gnucash data file.
>> 
>> Cheers David.
>> 
>> 
>> On Mon, 16 Mar 2020 at 09:19, Eric H. Bowen > > wrote:
>> 
>>Hello, David. More info in the message I just posted. I do use ISO
>>date format (-mm-dd) for all of my computer-related workEric
>> 
>> 
>>On 3/15/20 4:22 PM, David H wrote:
>>> 
>>> 
>>>On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger
>>>>>> wrote:
>>> 
>>>> * 15:01:20 WARN  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).
>>> 
>>>Hmm transaction dates can be in the future, this looks like 6th
>>>Feb 2020 to me in ccyy-m-d format ?
>>> 
>>>Cheers David.
>>> 
>> 
> 
> ___
> 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.

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

[Eric H. Bowen via gnucash-user]

I'm seeing the error on all three operating systems, although it first 
appeared on the Windows 10 computer. The pop-up error message does 
appear only when importing transactions, and only from one specific 
account (my personal checking account) at that, and since it seemed as 
though the transaction records were not affected I put up with it for 
several months as just a nuisance. However, recently I've been trying to 
reconcile a loan account for a vehicle which was totaled and paid off by 
insurance, and when I try to balance the liability of the loan off 
against the asset for the value of the vehicle it seems to post properly 
for that session...but when I restart Gnucash for the next session, the 
amount has moved back to "Imbalance". A couple of other transactions are 
doing this as well, but the auto payoff is the big'un. I want to get the 
known error taken care of first, and then when the imports are back to 
working properly I want to see if I'm still having problems balancing 
out these transactions and, if I do, I'll post a separate request to the 
listEric.


On 3/15/20 6:30 PM, David H wrote:

Hi Eric,

Yep saw that.  What OS are you seeing the error on, or is it on all of 
them ? Just saw your other post, so you are getting this when trying 
to import transactions NOT when saving your Gnucash data file.


Cheers David.


On Mon, 16 Mar 2020 at 09:19, Eric H. Bowen > wrote:


Hello, David. More info in the message I just posted. I do use ISO
date format (-mm-dd) for all of my computer-related workEric


On 3/15/20 4:22 PM, David H wrote:



On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger
mailto:frank.h.ellenber...@gmail.com>> wrote:

> * 15:01:20 WARN  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).

Hmm transaction dates can be in the future, this looks like 6th
Feb 2020 to me in ccyy-m-d format ?

Cheers David.





___
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.

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

[David H]

Hi Eric,

Yep saw that.  What OS are you seeing the error on, or is it on all of them
? Just saw your other post, so you are getting this when trying to import
transactions NOT when saving your Gnucash data file.

Cheers David.


On Mon, 16 Mar 2020 at 09:19, Eric H. Bowen  wrote:

> Hello, David. More info in the message I just posted. I do use ISO date
> format (-mm-dd) for all of my computer-related workEric
>
> On 3/15/20 4:22 PM, David H wrote:
>
>
>
> On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger <
> frank.h.ellenber...@gmail.com> wrote:
>
>> > * 15:01:20  WARN  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).
>>
>
> Hmm transaction dates can be in the future, this looks like 6th Feb 2020
> to me in ccyy-m-d format ?
>
> Cheers David.
>
>
>
___
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.

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

[Eric H. Bowen via gnucash-user]

On 3/15/20 4:36 PM, Christopher Lam wrote:


On Sun, 15 Mar 2020 at 20:31, Eric H. Bowen via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


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

___
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.

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

[Eric H. Bowen via gnucash-user]

Hello, David. More info in the message I just posted. I do use ISO date 
format (-mm-dd) for all of my computer-related workEric



On 3/15/20 4:22 PM, David H wrote:



On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger 
mailto:frank.h.ellenber...@gmail.com>> 
wrote:


> * 15:01:20  WARN  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).

Hmm transaction dates can be in the future, this looks like 6th Feb 
2020 to me in ccyy-m-d format ?


Cheers David.



___
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.

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

[Christopher Lam]

On Sun, 15 Mar 2020 at 20:31, Eric H. Bowen via gnucash-user <
gnucash-user@gnucash.org> wrote:

> * 14:57:56  WARN  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.
___
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.

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

[Adrien Monteleone]

Open the file with a text editor, if sqlite, you’ll see:

"SQLite format 3"

at the beginning of the file, otherwise, you’re looking at a compressed (or 
uncompressed) XML.

Regards,
Adrien

> On Mar 15, 2020 w12d75, at 4:33 PM, Adrien Monteleone 
>  wrote:
> 
> sqlite files also have a .gnucash extension.
> 
> Regards,
> Adrien
> 
>> On Mar 15, 2020 w12d75, at 4:19 PM, David H  wrote:
>> 
>> 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.
> 


___
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.

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

[Adrien Monteleone]

sqlite files also have a .gnucash extension.

Regards,
Adrien

> On Mar 15, 2020 w12d75, at 4:19 PM, David H  wrote:
> 
> 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.


___
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.

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

[David H]

On Mon, 16 Mar 2020 at 07:10, Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> > * 15:01:20  WARN  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).
>

Hmm transaction dates can be in the future, this looks like 6th Feb 2020 to
me in ccyy-m-d format ?

Cheers David.
___
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.

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

[David H]

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  qif-parse:parse-date/format: format is y-d-m
> but date is [2020/2/6].
> * 15:00:34 ERROR  [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR 
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
> * 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:00:34 ERROR  [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR 
> [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  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:01:20  WARN  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.

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

[Frank H. Ellenberger]

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  qif-parse:parse-date/format: format is y-d-m
> but date is [2020/2/6].
> * 15:00:34 ERROR  [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 
> [GncDbiSqlConnection::execute_select_statement()] Error executing SQL
> SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
> * 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:00:34 ERROR  [error_handler()] DBI error: 11:
> database disk image is malformed
> * 15:00:34 ERROR 
> [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  [GncDbiSqlResult::~GncDbiSqlResult()]
> Error 11 in dbi_result_free() result.
> * 15:01:20  WARN  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
___
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.

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

[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  qif-parse:parse-date/format: format is y-d-m 
but date is [2020/2/6].
* 15:00:34 ERROR  [error_handler()] DBI error: 11: 
database disk image is malformed
* 15:00:34 ERROR  
[GncDbiSqlConnection::execute_select_statement()] Error executing SQL 
SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid FROM accounts)
* 15:00:34 ERROR  [GncDbiSqlResult::~GncDbiSqlResult()] 
Error 11 in dbi_result_free() result.
* 15:00:34 ERROR  [error_handler()] DBI error: 11: 
database disk image is malformed
* 15:00:34 ERROR  
[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  [GncDbiSqlResult::~GncDbiSqlResult()] 
Error 11 in dbi_result_free() result.
* 15:01:20  WARN  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.