[GNC] Currency Database empty

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Currency Database empty

Keith Bellairs
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?

Keith
_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

John Ralls-2


> On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]> 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

_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

Keith Bellairs
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 <[hidden email]> wrote:

>
>
> > On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]> 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
>
>
_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

John Ralls-2
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 <[hidden email]> 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 <[hidden email]> wrote:
>
>
> > On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]> 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
>

_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

ChrisGood
In reply to this post by Keith Bellairs
Message: 11
Date: Sat, 16 Feb 2019 11:40:52 -0500
From: Keith Bellairs <[hidden email]>
To: John Ralls <[hidden email]>
Cc: gnucash-user email group <[hidden email]>
Subject: Re: [GNC] Currency Database empty
Message-ID:
        <CAALV8s=[hidden email]>
Content-Type: text/plain; charset="UTF-8"

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 <[hidden email]> wrote:

>
>
> > On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]> 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
>
>

Hi Keith & John,

(John probably already knows this but just in case)

Maybe this is https://bugs.gnucash.org/show_bug.cgi?id=797046 ?
Is there a 3.4 build for MacOS after the original 3.4?

Regards, Chris Good

_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

John Ralls-2
In reply to this post by John Ralls-2
The only reason to not CC the list is if you're specifically invited to send confidential data to a developer.

You're right, it's bug 797046. I'd mistaken that for Windows only this morning when looking over the bug reports, but Mike Alexander had seen it on MacOS too. As you probably surmised it's fixed in git. Unfortunately there aren't any MacOS nightlies for you to try so your best bet is to use GnuCash 3.3 until 3.5 comes out.

Regards,
John Ralls



> On Feb 16, 2019, at 3:20 PM, Keith Bellairs <[hidden email]> wrote:
>
> John,
>
> As you might expect, fixing the broken date  allowed gnc to start without adding warnings to the trace file. Thanks for the pointer.
>
> The currency error in the price db is still there - currency exchange rates do not display and cannot be added (or maybe are added and do not display). I ran gnc with --debug, but the 23M file is a little unwieldy.
>
> Related to the https://bugs.gnucash.org/show_bug.cgi?id=797046 bug? I am using MacOS.
>
> I stopped cc to the Gnucash users while this works out.
>
> Keith
>
> On Sat, Feb 16, 2019 at 3:11 PM John Ralls <[hidden email]> wrote:
> 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 <[hidden email]> 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 <[hidden email]> wrote:
> >
> >
> > > On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]> 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
> >
>

_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

Keith Bellairs
Thanks, guys.

I have reverted to

Version: 3.3
Build ID: 3.3+ (2018-09-29)
Finance::Quote: 1.47

and currencies show up correctly in the price tool. Also, a couple that I
entered and could not see when running 3.4 in MacOS were actually entered
correctly. When using 3.3 I can see the new exchange rates.

GNC is the best.

Keith





On Sat, Feb 16, 2019 at 6:36 PM John Ralls <[hidden email]> wrote:

> The only reason to not CC the list is if you're specifically invited to
> send confidential data to a developer.
>
> You're right, it's bug 797046. I'd mistaken that for Windows only this
> morning when looking over the bug reports, but Mike Alexander had seen it
> on MacOS too. As you probably surmised it's fixed in git. Unfortunately
> there aren't any MacOS nightlies for you to try so your best bet is to use
> GnuCash 3.3 until 3.5 comes out.
>
> Regards,
> John Ralls
>
>
>
> > On Feb 16, 2019, at 3:20 PM, Keith Bellairs <[hidden email]> wrote:
> >
> > John,
> >
> > As you might expect, fixing the broken date  allowed gnc to start
> without adding warnings to the trace file. Thanks for the pointer.
> >
> > The currency error in the price db is still there - currency exchange
> rates do not display and cannot be added (or maybe are added and do not
> display). I ran gnc with --debug, but the 23M file is a little unwieldy.
> >
> > Related to the https://bugs.gnucash.org/show_bug.cgi?id=797046 bug? I
> am using MacOS.
> >
> > I stopped cc to the Gnucash users while this works out.
> >
> > Keith
> >
> > On Sat, Feb 16, 2019 at 3:11 PM John Ralls <[hidden email]> wrote:
> > 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 <[hidden email]>
> 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 <[hidden email]>
> wrote:
> > >
> > >
> > > > On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]>
> 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
> > >
> >
>
>
_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

John Ralls-2
In reply to this post by ChrisGood


> On Feb 16, 2019, at 2:29 PM, Chris Good <[hidden email]> wrote:
>
> Message: 11
> Date: Sat, 16 Feb 2019 11:40:52 -0500
> From: Keith Bellairs <[hidden email]>
> To: John Ralls <[hidden email]>
> Cc: gnucash-user email group <[hidden email]>
> Subject: Re: [GNC] Currency Database empty
> Message-ID:
> <CAALV8s=[hidden email]>
> Content-Type: text/plain; charset="UTF-8"
>
> 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 <[hidden email]> wrote:
>>
>>
>>> On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]> 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
>>
>>
>
> Hi Keith & John,
>
> (John probably already knows this but just in case)
>
> Maybe this is https://bugs.gnucash.org/show_bug.cgi?id=797046 ?
> Is there a 3.4 build for MacOS after the original 3.4?

Chris,

No, there are no nightlies for MacOS.

Regards,
John Ralls
_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Currency Database empty

Keith Bellairs
In reply to this post by Keith Bellairs
Well I reverted to version 3.3. But it had serious stability problems and
kept crashing out on me. So I'll use 3.4 and just not worry about my CAD
exchange rates. Looking forward to 3.5.

Tempted to restart my linux box.

Keith


On Sat, Feb 16, 2019 at 9:18 PM Keith Bellairs <[hidden email]> wrote:

> Thanks, guys.
>
> I have reverted to
>
> Version: 3.3
> Build ID: 3.3+ (2018-09-29)
> Finance::Quote: 1.47
>
> and currencies show up correctly in the price tool. Also, a couple that I
> entered and could not see when running 3.4 in MacOS were actually entered
> correctly. When using 3.3 I can see the new exchange rates.
>
> GNC is the best.
>
> Keith
>
>
>
>
>
> On Sat, Feb 16, 2019 at 6:36 PM John Ralls <[hidden email]> wrote:
>
>> The only reason to not CC the list is if you're specifically invited to
>> send confidential data to a developer.
>>
>> You're right, it's bug 797046. I'd mistaken that for Windows only this
>> morning when looking over the bug reports, but Mike Alexander had seen it
>> on MacOS too. As you probably surmised it's fixed in git. Unfortunately
>> there aren't any MacOS nightlies for you to try so your best bet is to use
>> GnuCash 3.3 until 3.5 comes out.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>> > On Feb 16, 2019, at 3:20 PM, Keith Bellairs <[hidden email]> wrote:
>> >
>> > John,
>> >
>> > As you might expect, fixing the broken date  allowed gnc to start
>> without adding warnings to the trace file. Thanks for the pointer.
>> >
>> > The currency error in the price db is still there - currency exchange
>> rates do not display and cannot be added (or maybe are added and do not
>> display). I ran gnc with --debug, but the 23M file is a little unwieldy.
>> >
>> > Related to the https://bugs.gnucash.org/show_bug.cgi?id=797046 bug? I
>> am using MacOS.
>> >
>> > I stopped cc to the Gnucash users while this works out.
>> >
>> > Keith
>> >
>> > On Sat, Feb 16, 2019 at 3:11 PM John Ralls <[hidden email]> wrote:
>> > 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 <[hidden email]>
>> 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 <[hidden email]>
>> wrote:
>> > >
>> > >
>> > > > On Feb 16, 2019, at 8:02 AM, Keith Bellairs <[hidden email]>
>> 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
>> > >
>> >
>>
>>
_______________________________________________
gnucash-user mailing list
[hidden email]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.