Re: [GNC] Restoring "Unable to save to database" error?

[Eric H. Bowen via gnucash-user]

Yes, that's exactly what I did...made a copy of the Gnucash file in
another directory as a backup, then "Save As" over the old file. Worked
like a charm.


Eric H. Bowen
e...@ehbowen.net 
On 5/1/2020 9:48 AM, Derek Atkins wrote:
> Hi Eric,
>
> Sorry to respond to an old message but I didn't see any responses and I
> am currently catching up on ~2 months of email..
>
> "Eric H. Bowen via gnucash-user"  writes:
>
>> I've been getting the "Unable to save to database" error whenever I
>> import and/or save transactions in one of my asset accounts. I haven't
>> lost any transactions, but it appears that the database which
>> automatically matches imported transactions (or attempts to) is
>> corrupted. I'd be perfectly happy to drop the old database and begin
>> again with a new one, as long as I can keep my previously saved
>> transactions, but I haven't yet found a (newbie friendly) way to do
>> this. Any assistance?Eric.
> Assuming you have not solved this, yet -- have you tried to use File ->
> Save As to save it to a new database or an XML file?
>
> That should at least get you going.  Another option is File -> Save As
> to XML, delete your (SQL?) database, and then File -> Save As back to
> the SQL database to get it to rebuild.
>
> Hope this helps,
>
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> -derek
>


smime.p7s
Description: S/MIME Cryptographic Signature
___
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] Restoring "Unable to save to database" error?

[Derek Atkins]

Hi Eric,

Sorry to respond to an old message but I didn't see any responses and I
am currently catching up on ~2 months of email..

"Eric H. Bowen via gnucash-user"  writes:

> I've been getting the "Unable to save to database" error whenever I
> import and/or save transactions in one of my asset accounts. I haven't
> lost any transactions, but it appears that the database which
> automatically matches imported transactions (or attempts to) is
> corrupted. I'd be perfectly happy to drop the old database and begin
> again with a new one, as long as I can keep my previously saved
> transactions, but I haven't yet found a (newbie friendly) way to do
> this. Any assistance?Eric.

Assuming you have not solved this, yet -- have you tried to use File ->
Save As to save it to a new database or an XML file?

That should at least get you going.  Another option is File -> Save As
to XML, delete your (SQL?) database, and then File -> Save As back to
the SQL database to get it to rebuild.

Hope this helps,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant
___
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] Restoring "Unable to save to database" error?

[Eric H. Bowen via gnucash-user]

I've been getting the "Unable to save to database" error whenever I 
import and/or save transactions in one of my asset accounts. I haven't 
lost any transactions, but it appears that the database which 
automatically matches imported transactions (or attempts to) is 
corrupted. I'd be perfectly happy to drop the old database and begin 
again with a new one, as long as I can keep my previously saved 
transactions, but I haven't yet found a (newbie friendly) way to do 
this. Any assistance?Eric.


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