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

[Eric H. Bowen]

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
eric at ehbowen.net <mailto:eric at 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" <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
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3993 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20200501/c852ef55/attachment.p7s>