Jump to content
  • 0

Currency Code Must Be 3 Characters.


L3Y

Question

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

 

 

post-10622-0-99403800-1414470069_thumb.p

post-10622-0-49292300-1414470084_thumb.p

Link to comment
Share on other sites

19 answers to this question

Recommended Posts

  • 0

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....

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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?

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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.

Link to comment
Share on other sites

  • 0

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. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...