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 742461 - SQL backend doesn't update customer info
SQL backend doesn't update customer info
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Backend - SQL
unspecified
Other All
: Normal normal
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2015-01-06 14:49 UTC by John Ralls
Modified: 2018-06-29 23:37 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description John Ralls 2015-01-06 14:49:00 UTC
I have following problem; When I try to update phone number or something
else in customers data the changes is not saved. It is gone next time I log
into Gnucash.
I am useing Latest version (2.6.5) of Gnucash, Windows7  and Mysql as
backend. 
The same problem is present also when I use Kubuntu with mysql. I have to
use Mysql Workbench or someting else to change data in the database. Does
anybody have a solution on this?
Comment 1 John Ralls 2016-08-22 19:24:43 UTC
Not able to replicate. Since this is copied from the mailing list no reporter will see the status change, so I'll ask there.
Comment 2 John Ralls 2016-08-22 20:32:01 UTC
Actually, yes I can: I missed a step. There's some weird state issue going on: If the customer is created and then edited in the same GnuCash session then address edits are committed to the DB, but when editing in a later session the address edits are not committed, though other changes (like customer name) are.
Comment 3 John Ralls 2016-08-22 22:22:52 UTC
Found it, fixed it. load_address wasn't passing through the parent to the constructor, and mark_address wasn't dirtying the parent. Since addresses don't have their own table they rely on the parent object to write them out to the DB, but of course it won't if it doesn't think it's dirty.
Comment 4 John Ralls 2018-06-29 23:37:29 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=742461. Please update any external references or bookmarks.