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 671323 - Scheduled monthly transactions lose "except on weekends" setting when using MySQL
Scheduled monthly transactions lose "except on weekends" setting when using M...
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.4.x
Other All
: Normal normal
: ---
Assigned To: Geert Janssens
Geert Janssens
Depends on:
Blocks:
 
 
Reported: 2012-03-04 21:08 UTC by Bruce Leary
Modified: 2018-06-29 23:07 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Bruce Leary 2012-03-04 21:08:38 UTC 
When the data file is stored in a MySQL database instead of the default GnuCash file the "except on weekends" option setting for a monthly transaction is not retained when GnuCash is stopped and restarted.  In other words, it appears that the option requesting previous weekday or next weekday is not written to the MySQL database or is not read back in when the database is opened.

In testing this problem I totally uninstalled GnuCash (2.4.10-1) and reinstalled (2.4.10-1) on my Windows 7 32-bit system.  There was no change in behavior.
Comment 1 Geert Janssens 2012-06-21 12:57:37 UTC 
Confirmed. This also happens with the other SQL backends and on linux.

I am reassigning this to the SQL backend component as this seems to be a backend problem, not a problem with scheduled transactions themselves.
Comment 2 Geert Janssens 2012-06-21 12:58:25 UTC 
Oh, and I forgot to mention this also happens in trunk, not only in 2.4.x.
Comment 3 Geert Janssens 2012-06-21 15:23:42 UTC 
I have just committed a fix in trunk. The parameter was effectively ignored by the sql backend.

The fix updated the sql table format. So once you use the fixed gnucash version with your data, an older version of gnucash will probably refuse to load it (or read-only at best).

I'm not sure if I am allowed to backport this fix to the stable branch of gnucash, due to this compatibility issue. I have asked on the mailing list and will go by the feedback there.
Comment 4 Geert Janssens 2012-06-22 15:44:46 UTC 
And backported to 2.4 in r22232.

After a test, it turns out that 2.4.10 will load an updated data file just fine, but won't let you change the weekly_adjust parameter or create new scheduled transactions. For the rest it will continue to work as before.
Comment 5 John Ralls 2017-09-24 22:44:30 UTC 
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 6 John Ralls 2018-06-29 23:07:06 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=671323. Please update any external references or bookmarks.