After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 599151 - Unable save to database.
Unable save to database.
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.3.x
Other Windows
: Normal critical
: ---
Assigned To: Phil Longstaff
Chris Shoemaker
Depends on:
Blocks:
 
 
Reported: 2009-10-21 09:13 UTC by przemmaj
Modified: 2018-06-29 22:29 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
stack trace (122.69 KB, text/plain)
2009-10-21 18:08 UTC, przemmaj
Details
stack trace after reading xml (755 bytes, text/plain)
2009-10-22 07:12 UTC, przemmaj
Details

Description przemmaj 2009-10-21 09:13:05 UTC
"Unable save to database" message after creating a new account.
Comment 1 Phil Longstaff 2009-10-21 15:25:04 UTC
What steps did you do?  Is this reproducible?  Is this a new file or existing file?  Is it an external mysql or postgresql db?
Comment 2 Phil Longstaff 2009-10-21 15:26:46 UTC
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.
Comment 3 przemmaj 2009-10-21 18:08:02 UTC
Created attachment 145968 [details]
stack trace
Comment 4 przemmaj 2009-10-21 18:08:41 UTC
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.
Comment 5 Phil Longstaff 2009-10-21 19:26:28 UTC
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.
Comment 6 przemmaj 2009-10-22 07:11:29 UTC
OK, It will be cool if it work. Unfortunately it does not. 
Gnucash is crashing after loading xml. 
Trace log in attachment.
Comment 7 przemmaj 2009-10-22 07:12:37 UTC
Created attachment 146019 [details]
stack trace after reading xml
Comment 8 przemmaj 2009-10-23 08:39:43 UTC
So, what should I do?
Comment 9 Phil Longstaff 2009-11-10 02:23:31 UTC
Can you e-mail me the XML file?
Comment 10 Phil Longstaff 2009-11-12 01:54:36 UTC
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.
Comment 11 przemmaj 2009-11-12 14:34:02 UTC
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,
Comment 12 Phil Longstaff 2009-11-12 15:49:51 UTC
I see lots in PLN but those 2 accounts don't have any commodity.
Comment 13 przemmaj 2009-11-12 15:51:32 UTC
So it's ok. Those two are in CHF and EUR.
Comment 14 Phil Longstaff 2009-11-24 00:30:28 UTC
Problem was missing currencies which was fixed in a previous version.
Comment 15 John Ralls 2018-06-29 22:29:59 UTC
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.