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 555182 - Security Type template hidden
Security Type template hidden
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: User Interface General
2.2.x
Other All
: High normal
: ---
Assigned To: David Hampton
Chris Shoemaker
Depends on:
Blocks:
 
 
Reported: 2008-10-06 07:07 UTC by Mixu
Modified: 2018-06-29 22:11 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description Mixu 2008-10-06 07:07:08 UTC
When a security type is changed to template (instead of Nasdaq, eurex, custom) gnucash allows to Update the data.  The security will not show in the Security Editor afterwards and cannot be reverted.

The interface should not allow you to change the security type to template, or will not restrict the listing in the security list.

Other information:
Comment 1 Andrew Rose 2009-04-05 01:22:50 UTC
Just got bitten by this one, too.

Gnucash 2.2.6
r17427 on 2008-10-02

How do I get the security back, or delete it, as it's throwing my numbers out.
Comment 2 biermeister 2012-10-08 00:27:52 UTC
I'm having the same issue as mentioned. I can't see, delete or edit the template type security in the Security Editor (the other security types are available). I believe it is causing pricing errors in the Pricing Editor as well. 

This continues to be an identified issue on the gnucash-user list here: https://lists.gnucash.org/pipermail/gnucash-user/2012-March/044071.html

Gnucash 2.4.2
r20253M on 2011-02-14.

Looking for a resolution please.

Biermeister
Comment 3 David Carlson 2012-10-08 01:41:35 UTC
I am having the same problem.  From the reference in comment 2 you can see that somewhere I saw advice to manually edit it out of the data file, but I have not seen instructions detailed enough for me to be confident about not corrupting the file.  In any case, that is not really a satisfactory solution.  

The solution needs two parts.  One to fix previously corrupted files and one to prevent new corruptions.

David C
Comment 4 John Ralls 2014-01-16 22:53:52 UTC
r23688 prevents you from creating more commodities in namespace "template", and r23699 changes the namespace from "template" to "User" so that you can fix anything that you've managed to create in the past.

This will be in 2.6.1.
Comment 5 Geert Janssens 2014-03-07 17:31:32 UTC
John, is your fix supposed to save the changed namespace as well or does it explicitly require a user to go in and modify the faulty securities ?

I'm asking because I get these warnings each time I start an sqlite based book:

* 18:20:34  WARN <gnc.commodity> [gnc_commodity_table_insert()] Converting commodity Au from namespace template to namespace User
* 18:20:34  WARN <gnc.commodity> [gnc_commodity_new()] Converting commodity Au from namespace template to namespace User
* 18:20:34  WARN <gnc.commodity> [gnc_commodity_new()] Converting commodity Au from namespace template to namespace User

Should the fix be wrapped in some kind of BeginEdit/CommitEdit pair ?
Comment 6 Geert Janssens 2014-03-07 17:40:49 UTC
Hmm, I should be more precise: the 3 warnings above came from opening an old xml based file. After saving this file the warnings don't return.

When opening the sqlite file I get only one warning:
* 18:20:34  WARN <gnc.commodity> [gnc_commodity_table_insert()] Converting commodity Au from namespace template to namespace User

But contrary to the xml file it keeps recurring on each reload. There is no "save" option for sqlite so probably the only way to get rid of it would be to save as xml once and then save as sqlite again. Not doing this now just to keep the possible bug visible.
Comment 7 John Ralls 2018-06-29 22:11:03 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=555182. Please update any external references or bookmarks.