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

Derek Atkins derek at ihtfp.com
Fri May 1 10:48:14 EDT 2020


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" <gnucash-user at gnucash.org> 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
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant


More information about the gnucash-user mailing list