Currency Code Must Be 3 Characters.

[L3Y]

Hi,

 

I'm getting this error if i try to delete price row for a domain extension in a package.  I imported from WHM** and now this happen while editing / deleting our domain prices :

 

"Currency code must be 3 characters."

 

Why exactly?  The currency is set and i checked the db : it's all 3 characters, everywhere there is a currency field.  The currency is set correctly in the Blesta admin.

 

See attachment for the error, and our currency settings.

 

thank you,

Carl

 

 

[L3Y]

Just saw if i truncate the pricing table then i am able to delete and modify the product prices.

 

Here is how our pricing table looks like :

INSERT INTO `pricings` (`id`, `company_id`, `term`, `period`, `price`, `setup_fee`, `cancel_fee`, `currency`) VALUES
(1, 1, 1, 'month', 159.0000, 0.0000, 0.0000, 'CAD'),
(2, 1, 1, 'month', 141.8300, 0.0000, 0.0000, 'USD'),
(3, 1, 1, 'month', 112.0400, 0.0000, 0.0000, 'EUR'),
(4, 1, 1, 'month', 144.9900, 0.0000, 0.0000, 'CAD'),
(5, 1, 1, 'month', 219.0000, 0.0000, 0.0000, 'CAD'),
(6, 1, 1, 'month', 195.3600, 0.0000, 0.0000, 'USD'),
(7, 1, 1, 'month', 154.3200, 0.0000, 0.0000, 'EUR'),
(8, 1, 1, 'month', 259.0000, 0.0000, 0.0000, 'CAD'),
(9, 1, 1, 'month', 231.0400, 0.0000, 0.0000, 'USD'),
(10, 1, 1, 'month', 182.5100, 0.0000, 0.0000, 'EUR'),
(11, 1, 1, 'month', 245.0000, 0.0000, 0.0000, 'CAD')
[...]

I can't figure out what's wrong in it...

 

It work now, but we need to re-configure our prices manually....

[Michael]

What do you have on the currencies page: Settings > Company > Currencies 

 

Also what do you have for the pricing on the package?

[Tyson]

Are you sure your package pricing was set to only 3 character currency codes? It sounds as if they may not have all been 3 characters when they were imported, and updating the package fails because it's attempting to re-use an incorrect currency code.

[Paul]

You should be careful with removing pricing that is in use, doing so could be problematic.

 

With price overrides being added in 3.3, it's likely that there will be a method by which to set a price-override for all affected services when removing a pricing option in the future.

[joshin]

I'm having the same issue. No pricing is in use on the packages in question.

[Tyson]

I'm having the same issue. No pricing is in use on the packages in question.

 

What do you mean 'no pricing is in use on the packages'?

 

Every package should have at least one term/period/price/currency set. The error the OP mentioned is caused by failing to submit a valid currency when adding/editing a package. You could view the source of the page and search for "pricing[currency][]", and make sure that there are currency options set as valid 3-character codes.

 

The system pulls these from the `currencies` table in the database. You can update your currencies under [settings] -> [Company] -> [Currencies] -> [Active Currencies]. Make sure the currency you're trying to set on the package is available in that list.

[serge]

I think Joshin was saying when one of the term have price to 0.00.

 

by the way, I have same issue as him, I have 3 terms ( one at 0.00 & 2 other terms paid), and if I want to delete both paid & update package, I got this error:

 

"Currency code must be 3 characters."

 

Of course setup on my active currencies is good, my order form have good currencies selected and same in the payment gateway parameters

 

Please can someone can check to re-produce & see if there is a bug?

[Michael]

Are you trying to use three different currencies?

[Tyson]

I think Joshin was saying when one of the term have price to 0.00.

 

by the way, I have same issue as him, I have 3 terms ( one at 0.00 & 2 other terms paid), and if I want to delete both paid & update package, I got this error:

 

"Currency code must be 3 characters."

 

Of course setup on my active currencies is good, my order form have good currencies selected and same in the payment gateway parameters

 

Please can someone can check to re-produce & see if there is a bug?

 

Can you let us know what version of Blesta you're using? Could you take a screenshot of the package (specifically the pricing) before and after you receive the error? A list of currencies you have setup in Blesta would be useful too.

[serge]

I'm running Blesta version 3.3.2

 

1.png , 2.png , 3.png are screenshots before error

 

4.png is screenshots at error, it's happen after trying to remove last 2 terms in my package & update it

 

[Michael]

Well your currency is 1,234.56 But in your pricing field you have 1888.88 it should be I believe 1,888.88

[Tyson]

Well your currency is 1,234.56 But in your pricing field you have 1888.88 it should be I believe 1,888.88

 

The thousands place comma, decimal, currency codes, etc. are just for formatting wherever they are displayed, and wouldn't affect the issue he's having attempting to remove some.

 

I'll have to test this issue myself.

[serge]

Thanks,

 

It's do not come from the coma, have someone tried to reproduce?

[serge]

will be too bad if potential bug are not followed

[Michael]

will be too bad if potential bug are not followed

 

I've reported this as a bug in 3.4.x I think it's weird because if you remove a packing pricing you get that error, so I believe it's related to this error. Fix -> Re-save the package. But that's not the real fix, just a temp. 

[serge]

Thxs for your bug report in the forum "bug" section, and that true that a double package save can sometime pass this issue but not all the time

FYI, I solved my issue from editing/deleting prices in database,

[Tyson]

Thanks for all the info. The issue will be fixed in v3.4.0 (CORE-1528).

[ct_tx]

So, I am having the same issue. However, every time I remove a price and save a plan - I get this error message. On saving again, the error message goes away, but all my original pricing plans come back. I just can't seem to remove a pricing option that I do not want listed anymore. 

[serge]

will be fixed in next Blesta version, but you can delete price from editing "pricings" table in your db