[GNC] Currency Database empty

[John Ralls]

Seems you've got a bad date in your price database and it's messed up the in-memory pricedb. Make a copy of your data file, decompress it if necessary, and open it in a text editor. search for "201-12-11" and correct it. Be sure to save as plain text if you're using TextEdit. Open the saved file in GnuCash and see if that's fixed it.

Regards,
John Ralls

> On Feb 16, 2019, at 8:40 AM, Keith Bellairs <keith at bellairs.org> wrote:
> 
> John,
> 
> xml backend.
> 
> not running with -debug but trace has some of these:
> * 10:50:08  WARN <qof.engine> [gnc_dmy2time64_internal()] Date computation error from Y-M-D 201-12-11: Year is out of valid range: 1400..9999
> * 10:56:13  CRIT <gnc.backend.xml> xmlNodePtr time64_to_dom_tree(const char *, const time64): assertion 'time != INT64_MAX' failed
> * 10:56:13  CRIT <gnc.backend.xml> xmlNodePtr time64_to_dom_tree(const char *, const time64): assertion 'time != INT64_MAX' failed
> 
> But the date error does not seem to be coming from the Price Database tool. (Restarted gnc, went to price tool, tired to add currency exchange, failed - but no CRIT trace. The WARN appeared when gnc was started and before using price tool.)
> 
> Keith
> 
> 
> 
> On Sat, Feb 16, 2019 at 11:25 AM John Ralls <jralls at ceridwen.us> wrote:
> 
> 
> > On Feb 16, 2019, at 8:02 AM, Keith Bellairs <keith at bellairs.org> wrote:
> > 
> > Version: 3.4
> > Build ID: 3.4+ (2018-12-30)
> > Finance::Quote: 1.47
> > MacOS 10.14.3 (recent update)
> > 
> > Recently moved up from gnc 2 to 3.4. Opened Price Database tool and ran get
> > quotes, as I have done for years. Got the alert box that it couldn't get
> > CAD. That's not a surprise. Update to prices was completed and I went to
> > hand enter a new CAD/USD price. No CAD or USD price history shows (there
> > should have been 15 years worth). So I selected ADD to at least have the
> > current exchange rate. After clicking Apply and / or OK, no exchange rate
> > was added and the set of exchange rates is still empty.
> > 
> > Is this known? Is there a fix?
> 
> I thought that I'd seen something similar from last month but I can't find it. What backend are you using? Are there any useful messages in the trace file [1]?
> 
> Regards,
> John Ralls
> 
> [1] https://wiki.gnucash.org/wiki/Tracefile
>