Jump to content
ISH

Exchange Rates Update Failed

Recommended Posts

My currency exchange rate update failed in cron, even when I tried it manually from settings>Payments>currencies and clicking update exchange rate it give me following error.

 

Exchange Rates Update Results
Update Failed for EUR Exchange Rate
Update Failed for GBP Exchange Rate
Update Failed for INR Exchange Rate

 

Please can anyone help me to fix this?

Share this post


Link to post
Share on other sites

Hi @ISH what is your default currency? There are only certain currencies we can auto update

WHMCS has the built in capability to retrieve and update the base conversion rate values daily for the following currencies:

USD, EUR, JPY, BGN, CZK, DKK, EEK, GBP, HUF, LTL, LVL, PLN, RON, SEK, CHF, NOK, HRK, RUB, TRY, AUD, BRL, CAD, CNY, HKD, IDR, INR, KRW, MXN, MYR, NZD, PHP, SGD, THB & ZAR

You can manually request the rates to be synced using the Update Exchange Rates button on the currencies page or you can configure it to be automated with the daily cron in Setup > Automation Settings.

Share this post


Link to post
Share on other sites

Hi @ISH,

We have diagnosed that the exchange rate feed source used by WHMCS has changed. A hotfix has been published for v.7.6 to resolve this, which is available at:

 

We are presently working on back-porting this hotfix to other supported versions and will publish them at https://whmcs.community/files/ over the coming days.

Share this post


Link to post
Share on other sites
On 9/11/2018 at 12:48 PM, WHMCS John said:

We have diagnosed that the exchange rate feed source used by WHMCS has changed. A hotfix has been published for v.7.6 to resolve this, which is available at:

Just to be clear for all, I have also observed this bug in 7.6.1 and the hotfix indeed fixes the issue. 

Share this post


Link to post
Share on other sites
On 28/09/2018 at 03:53, catding said:

We are using WHMCS6.3 - Is there any hotfix for it?

v6.3 went End of Life 18 months ago, so it would be interesting to know if they do plan to hotfix it.

i'm surprised it's taken over a fortnight and the other verified v7 hotfixes for this still haven't been released... it's only a URL change AFAIK, so it shouldn't take much testing.

it might be worth opening a ticket with Support (if you have an active support package with them) and asking about this directly.

Share this post


Link to post
Share on other sites

thanks, let me have a try.

but according to previous ticket, they may still ask me to pay the support fee or upgrade  first to continue....

Share this post


Link to post
Share on other sites
12 hours ago, catding said:

but according to previous ticket, they may still ask me to pay the support fee or upgrade  first to continue....

at which point, i'd just update the currencies manually - there's no point in upgrading now just for automated exchange rates if you're happy with everything else in your WHMCS installation (unless you have a *lot* of currencies!).

Share this post


Link to post
Share on other sites
On 25/09/2018 at 6:51 PM, capalis said:

Hi, when will you publish hotfix for 7.5.x?

We are wating for it.

Regards.

Did you get a copy of the HotFix for 7.5.x @capalis?

Share this post


Link to post
Share on other sites
6 hours ago, WHMCS ChrisD said:

Did you get a copy of the HotFix for 7.5.x @capalis?

does it exist for other releases? it's never been publicly posted in the v7.5 Hotfixes downloads ?

instinctively, I thought the v7.6 hotfix might work in v7.5, but i've never tried it.

Share this post


Link to post
Share on other sites
On 9/30/2018 at 7:43 AM, WHMCS ChrisD said:

Did you get a copy of the HotFix for 7.5.x @capalis?

It doesn't exist. We are still waiting for it.

Share this post


Link to post
Share on other sites

Hi Everyone

Here are the hot fixes for each version

Version 7.6

 

 

Version 7.5

 

Version 7.4

 

Version 7.3

 

 

Share this post


Link to post
Share on other sites
1 hour ago, WHMCS ChrisD said:

Hello @Mohsin AmerWhich version of WHMCS are you using?

Thanks for your swift reply, my versions are:

 

PHP: 5.6.40

WHMCS: v7.4.2

 

Hotfix already installed and tried them all none works.

Share this post


Link to post
Share on other sites

Hi

I'm using as default currency CLP, also I have clients for USD and Euro payments, but could not update currencies, because CLP currency is not included on daily auto update currencies list.

I see on https://www.xe.com/currencyconverter/ that CLP currency exist, but my WHMCS installation does not recognice this currency, by this reason I colud not autoupdate product prices and could not auto update currencies.

There exist the posibillitie to add this currency or other, to the daily update list.

In advanced, thanks for your support.

Share this post


Link to post
Share on other sites
On 09/02/2020 at 02:29, Hostingcrop said:

I see on https://www.xe.com/currencyconverter/ that CLP currency exist, but my WHMCS installation does not recognise this currency, by this reason I could not autoupdate product prices and could not auto update currencies.

because WHMCS uses the free daily ECB (European Central Bank) rates, and that only includes the 30+ major currencies listed on the currencies page in the documentation.

On 09/02/2020 at 02:29, Hostingcrop said:

There exist the possibility to add this currency or other, to the daily update list.

as it's a third-party list, e.g WHMCS doesn't create or control it, you cannot add currencies to it.

the only options you have are to either manually update the currency exchange rate and then run the product prices update (as detailed in the documentation), or find an exchange rate source for CLP and use action hooks to update the exchange rate and product pricing... if you need to pay a developer to write that, then you'd need to post in Service Offers & Requests.

i'm surprised that nobody that developed a XE exchange rate addon for WHMCS yet - I would have thought there would be a demand for such an addon.

Share this post


Link to post
Share on other sites

Hi Brian

Thanks for your response.

I guess that this is because currencies exchange functions are not well docummented, is very hard look for information about WHMCS currencies exchange  functions.

Thanks for your response.

Best regards

Share this post


Link to post
Share on other sites
On 11/02/2020 at 17:37, Hostingcrop said:

I guess that this is because currencies exchange functions are not well documented, is very hard look for information about WHMCS currencies exchange  functions.

there aren't any real exchange rate functions in WHMCS - the current method works by pulling the xml list for EUR exchange rates from the ECB once per day, updating the database with those values (or calculations made with them) and then optionally updating the product prices based on those updated exchange rates.

if you were going to add a custom exchange rate into that process, you would use a cron / automation hook to update the exchange rate in the database table before the product prices are updated.

though there is a long-standing bug with the product pricing update in that it updates and enables prices in cycles that were previously disabled... e.g, before running the product pricing update, the monthly pricing is disabled for EUR and HRK...

dWjkKKP.png

then after running the pricing update, those disabled fields get enabled and prices added.

5Il3CYx.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated