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 758910 - Using --add-price-quote erases all stock quotes
Using --add-price-quote erases all stock quotes
Status: RESOLVED DUPLICATE of bug 756339
Product: GnuCash
Classification: Other
Component: Currency and Commodity
2.6.9
Other Linux
: Normal critical
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2015-12-01 17:19 UTC by David Hampton
Modified: 2018-06-29 23:44 UTC
See Also:
GNOME target: ---
GNOME version: ---



Description David Hampton 2015-12-01 17:19:44 UTC
I have a cron job to update my stock quotes on the first of every month.  Whenever this job runs it erases all my stock quotes.  This first happened November 2015 and erased many years of stock quotes.  Something in the code must have changed around that time frame and been published into the Fedora repositories.  I am running gnucash-2.6.9-1.fc21.x86_64 and perl-Finance-Quote-1.38-1.fc21.noarch from the Fedora 21 repositories.  I am using a SQL database for my data.

This is trivial for me to recreate.  The steps are:

1) create a stock quote from within gnucash
2) exit the program
3) run "gnucash --add-price-quotes <filename>".

Viola.  The stock quote created in step one has been erased.

Interestingly, when I run "Get Quotes" from the Price Editor I see list of 10 stocks that F::Q is unable to retrieve (which is expected) and the remaining stock quotes are properly added.  When I run --add-price-quotes from the command line I don't see this list of bad stocks (which used to appear) and all I see is the line "Found Finance::Quote version 1.38".  F::Q itself appears to be fine since it works properly from the Price Editor.  Its the gnucash command line processing code that invokes F::Q that is broken.
Comment 1 John Ralls 2015-12-01 19:35:18 UTC
Thanks for taking the time to report this.
This particular bug has already been reported into our bug tracking system, but we are happy to tell you that the problem has already been fixed in the code repository.

*** This bug has been marked as a duplicate of bug 756339 ***
Comment 2 David Hampton 2015-12-01 19:59:36 UTC
Is there any way to recover the historical prices short of re-entering them by hand?  Anything in the log files?
Comment 3 John Ralls 2015-12-01 20:02:58 UTC
Not from GnuCash's log files, but your database logs or backups should have the necessary data.
Comment 4 John Ralls 2018-06-29 23:44:34 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=758910. Please update any external references or bookmarks.