Currency values resetting?

Hi All,

Opencart : Version 1.4.9.3

For the last 3 days my currency values keep resetting.

I have the Euro as the default 1.00000000 with 4 other currencies. In the store settings I have this to auto update and the update date is always the current day but randomly the currencies all change to 1.00000000, i can refresh a few minutes later and then they'll be correct again, but check again and they can randomly all go to 1.00000000

I tried turning off auto update which seems to stop them resetting but I don't want to have to manually update them every day.

I have been having a problem with my hoster where the site is going down with a mysql error of "too many max connections" but when this happens the whole site goes offline, inbetween the site is working fine but this currency resetting problem occurs.

Any thoughts? Thanks all

too many max connections means that one of the people on your shared server is gettinghammered.

your host should set the system to drop some connections after each page load.


if your site is really busy though you should get a dedicated host.


i have not idea what is happening with your currency though. sorry.

Thanks for your reply Daniel.

One thing I did notice which I've never seen before (although not been looking tbh) is the following error in the error log.
Obviously "xxxxxx" is to replace my site

looks like a ports being blocked.

We had the same problem with the automatic currency updates.

Finance.yahoo.com does indeed occasionally return all 1.0000 as the foreign currency values, instead of the expected correct exchange rate values.This problem only started to occur during the past few days, I checked the Opencart orders on our live site.

I was also able to reproduce the same error on my own test server (which is not a heavy traffic site). It's most likely an issue with the fincance.yahoo.com server, maybe we should switch to another web source for the esxchange rates. For the time being, I added some code in Opencart on our live site to reject suspicious 1.0000 exchange rate values for foreign currencies.

Hello,
I have a problem with recetting the default currency from USD to EUR. It does not want to reset to EUR default currency. I even deleted USD but it still remains with USD default currency. I have set EUR to 1.00000 but after some time it recalculates and set the value according to USD/EUR ratio based on USD as default.
I have installed a test open cart site and it worked to set EUR as default. But I want to make working correctly the official site not the test one.
Any ideas where the problem is and how to solve it?
Can I disable the automatic currency ratio updates?
Thanks

I started seeing this on my demo server too recently
Maybe yahoo's going flaky
USD shows as 122.50
EUR shows as 252,242,692,622.67

Hi,

Not sure if its just an issue because my host is being a bit sh*tty of late.

Either way, as a temporary solution to stop the values resetting I've taken it to manually switching on auto update in the morning (or at least once a day) then as soon as the values have updated (after going to a few admin pages then back to currency) I think turn off the auto update so those values hold for the rest of the day.

Not ideal but it'll do until either my host picks up or some one here figures out what is going wrong

Hello,
How to turn off the currency update?
Thanks,

voyageu wrote:Hello,
How to turn off the currency update?
Thanks,

Admin Menu:

System-> Settings-> Local

Auto Update Currency: Yes/No