GNOME Bugzilla – Bug 555182
Security Type template hidden
Last modified: 2018-06-29 22:11:03 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:
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.
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
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
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.
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 ?
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.
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.