GNOME Bugzilla – Bug 599151
Unable save to database.
Last modified: 2018-06-29 22:29:59 UTC
"Unable save to database" message after creating a new account.
What steps did you do? Is this reproducible? Is this a new file or existing file? Is it an external mysql or postgresql db?
Do you know how to find your trace file (look in C:\Documents and Settings\<username>\LocalSettings\Temp for a gnucash.trace.XXXXXX file (XXXXXX is a 6-char string? Find one from around that time and see if there is anything in it (it's just a text file and can be opened with notepad or wordpad). If so, please attach it.
Created attachment 145968 [details] stack trace
Sorry, I was in hurry and didn't write it down: - It's reproducible, It shows up in a lot of moments. Also when creating a loan repayment whit a druid. I mentioned about it in 598425 bug. - I just clicked on a Current Assets and New Account - It's a existing file - It's a sql lite file Stack trace: In attachment.
From the info in the trace log, it looks as though this sqlite db was created in a previous version of gnucash. If it is just dummy data, delete it and recreate it with 2.3.7. You can also use "Save As" to save as an XML file. Then delete the sqlite3 file, load the XML file and "Save As" again to save as sqlite3. The trace log shows that while trying to create a account, it is trying to access a database field which was added in 2.3.4 (I think). 2.3.4 had a number of database schema changes. Now that the schema is settled, if there is a further change, gnucash will automatically update the database. However, that was not true in 2.3.4.
OK, It will be cool if it work. Unfortunately it does not. Gnucash is crashing after loading xml. Trace log in attachment.
Created attachment 146019 [details] stack trace after reading xml
So, what should I do?
Can you e-mail me the XML file?
There are a number of known bugs in earlier 2.3.X versions which caused commodities to be lost. I was able to open and read your xml file in gnucash, but for some reason, was *not* able to unzip it using gunzip. If you want, I can try to fix it by adding back the missing currencies. What are the currencies for the accounts? If it is Euros for the accounts with "EUR" and Swiss Francs for "CHF", then I can fix the xml file and e-mail it back to you.
Yes, that's right for those two are CHF and EUR, there are plenty of accounts in PLN but don't know if you need this info. Thanks,
I see lots in PLN but those 2 accounts don't have any commodity.
So it's ok. Those two are in CHF and EUR.
Problem was missing currencies which was fixed in a previous version.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=599151. Please update any external references or bookmarks.