How to get rid of "Could not determine the account currency. Using the default currency provided by your system."

[Paul Neuwirth]

On Thu, 4 Jan 2018 06:05:02 +0100
Paul Neuwirth <mail at paul-neuwirth.nl> wrote:

> On Wed, 03 Jan 2018 13:45:46 -0500
> Derek Atkins <warlord at MIT.EDU> wrote:
> 
> > Hi,
> > 
> > Paul Neuwirth <mail at paul-neuwirth.nl> writes:
> >   
> > > Hello,
> > > I always get "Could not determine the account currency. Using the
> > > default currency provided by your system." when opening an account
> > > since upgrade to 2.6.19.
> > > according to SQL 
> > > SELECT * FROM gnucash.accounts a left join gnucash.commodities c
> > > on c.guid = a.commodity_guid;
> > > all accounts have a currency set.
> > >
> > > Book Option "Use Trading Accounts" is off
> > > Preferences Accounts, Default Currency is set (choose: EUR)
> > >
> > > what am I missing?    
> > 
> > What type of account is it?
> > Specifically, is it a stock/mutual fund account?
> > If so, is it a top-level account?
> > 
> > Stock/Mutual accounts need to be children of an Asset with a
> > currency.  
> 
> Thank you.
> it was any account, any type and everywhere was Euro (EUR) set (not
> changable in dialog).. I saw in the mysql table commodities, EUR
> defined twice. when I imported transactions duplicate accounts where
> made with the "other EUR currency". I replaced old commodity-guids in
> all tables by the new guid..
> 
> update gnucash.transactions set
> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.accounts set
> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.customers set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.invoices set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
> currency_guid='2e2395017967d7799120dc8585cf4080' where currency_guid =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.prices set
> commodity_guid='2e2395017967d7799120dc8585cf4080' where commodity_guid
> = 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; update gnucash.vendors set
> currency='2e2395017967d7799120dc8585cf4080' where currency =
> 'c7a51d86fdeb16c7e93c09eb9af9b5e3'; 
> 
> and deleted the old EUR currency... 
> now everything is fine.. 
> 
Now I have the same issue with all foreign currency accounts...

Execute:
> SELECT * FROM gnucash.commodities

+ --------- + -------------- + ------------- + ------------- + ---------- + ------------- + --------------- + ----------------- + ------------- +
| guid      | namespace      | mnemonic      | fullname      | cusip      | fraction      | quote_flag      | quote_source      | quote_tz      |
+ --------- + -------------- + ------------- + ------------- + ---------- + ------------- + --------------- + ----------------- + ------------- +
| 090f9175bf272d914fc77cf8990ddde8 | CURRENCY       | USD           | US-Dollar     | 840        | 100           | 1               | currency          |               |
| 1669bedf79e858ba5ec3358346eee9b1 | CURRENCY       | ZWL           | Simbabwe-Dollar | 716        | 100           | 0               | currency          |               |
| 2d24b3b5c4ac803f1ef048f43801905c | CURRENCY       | GBP           | Pfund Sterling | 826        | 100           | 1               | currency          |               |
| 2e2395017967d7799120dc8585cf4080 | CURRENCY       | EUR           | Euro          | 978        | 100           | 1               | currency          |               |
| 4636ac6477efed452967bdb61c4a46ff | CURRENCY       | PLN           | Zloty         | 985        | 100           | 1               | currency          |               |
| aad29cfc8037ac37b0a30fb16fad538a | template       | template      | template      | template   | 1             | 0               |                   |               |
| bc7184bbbdac77765e615d7a3e2547d3 | CURRENCY       | USD           | US-Dollar     | 840        | 100           | 1               | currency          |               |
| NULL      | NULL           | NULL          | NULL          | NULL       | NULL          | NULL            | NULL              | NULL          |
+ --------- + -------------- + ------------- + ------------- + ---------- + ------------- + --------------- + ----------------- + ------------- + 8 rows

what is bad at first entry for USD (old accounts), but new want the
last line's USD...