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

Adrien Monteleone adrien.monteleone at lusfiber.net
Sun Mar 15 17:36:08 EDT 2020


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 <adrien.monteleone at lusfiber.net> wrote:
> 
> sqlite files also have a .gnucash extension.
> 
> Regards,
> Adrien
> 
>> On Mar 15, 2020 w12d75, at 4:19 PM, David H <hellvee at gmail.com> 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.
> 




More information about the gnucash-user mailing list