Post by andrixx » Fri Aug 26, 2011 4:42 pm

Hi,

I have been struggeling with my currency for some time now. I can't get them to auto update!
My store default currency has the value 1.00000000 and the rest it set to 0.

I have tried waiting over 24h to see if the updates comes, since it should accour 'daily'.
But nothing updates. I have moved my store to a new server and I then installed a new database for OC. But I still use my old modified files.

So maybe in the whole opencart file structure I have changed something? I need to know where to look if that is the case!

If not, I need some assistance or help, I am really running out of ideas!

Thanks for any answer or contribution. :)

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by andrixx » Sat Aug 27, 2011 7:22 pm

It looks like the default currency with the value 1.0000~ gets updated (today) while the other currencies with value of 0.0000~ last got updated 2 days ago.

Any ideas?

I also made a clean install with a new database on another server, they alsohave not got updated automaticly.

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by rph » Sat Aug 27, 2011 7:58 pm

Did you check the database to see what the last date modified was?

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by andrixx » Sat Aug 27, 2011 11:21 pm

rph wrote:Did you check the database to see what the last date modified was?
I don't fully understand. Want me o look for what in the database?

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by andrixx » Sat Aug 27, 2011 11:24 pm

is this what you mean?


currency_id title code symbol_left symbol_right decimal_place value status date_modified
Ändra Redigera Kopiera Radera 10 NOK NOK NOK 0.00000000 1 2011-08-25 11:40:38
Ändra Redigera Kopiera Radera 8 DKK DKK DKK 0.00000000 1 2011-08-25 11:40:04
Ändra Redigera Kopiera Radera 3 EUR EUR e282ac 0.00000000 1 2011-08-25 11:40:13
Ändra Redigera Kopiera Radera 4 SEK SEK kr 1.00000000 1 2011-08-27 11:19:44
Ändra Redigera Kopiera Radera 9 GBP GBP c2a3 0.00000000 1 2011-08-25 11:40:24

I created all the currencys at the same time

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by uksitebuilder » Sun Aug 28, 2011 12:47 am

Please try putting a value in the currencies that have 0.00

Then check this time tomorrow to see if they are updated.

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by andrixx » Sun Aug 28, 2011 2:03 am

uksitebuilder wrote:Please try putting a value in the currencies that have 0.00

Then check this time tomorrow to see if they are updated.
Alright I try that. I report back tomorrow! :)

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by rph » Sun Aug 28, 2011 2:58 am

Actually that's old enough to auto-update (you could just change the date values if it wasn't). The easiest way to force auto-update from that point is to go into settings and hit save on one of your stores without making any changes.

andrixx, I'm having a little trouble reading your output there. You're using the correct 3-character ISO currency codes, right?

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by uksitebuilder » Sun Aug 28, 2011 2:59 am

They look to be the currency symbols, so shouldn't affect the updating

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by andrixx » Sun Aug 28, 2011 4:50 am

Yes it is the correct currency codes.

I also tried enter settings for my store and save without changing anything. Still not updated. ???

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by rph » Sun Aug 28, 2011 6:17 am

Is curl enabled on your host?

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by andrixx » Sun Aug 28, 2011 6:48 am

I have no clue.

I try look if I find any options for Curl, if not I will send an email to the support for my webhotel

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by rph » Sun Aug 28, 2011 7:27 am

It's pretty standard but it's worth a check. There are really only four reasons auto-update wouldn't work:

1) It's not enabled
2) Yahoo Finance is down
3) You have bad currency codes
4) Curl isn't running

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by andrixx » Sun Aug 28, 2011 4:18 pm

1) It is enabled
2) Yahoo Finance is not down
3) I do not have bad currency codes
4) Curl - We have to wait what the support has to say.

I sent them an email yesterday, should get a answer soon.

Edit:
My store default currency updated again today to value 1.00000~
But the rest are still unupdated

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by rph » Mon Aug 29, 2011 11:24 am

As part of auto-update the default currency is set to a value of 1.000. I just checked Yahoo and it does a SEK/EUR conversion just fine (http://download.finance.yahoo.com/d/quo ... sl1&e=.csv) so check with your host.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by andrixx » Tue Aug 30, 2011 2:05 am

rph wrote:As part of auto-update the default currency is set to a value of 1.000. I just checked Yahoo and it does a SEK/EUR conversion just fine (http://download.finance.yahoo.com/d/quo ... sl1&e=.csv) so check with your host.
I sent the email to the support and had not got an answer by this morning, but I saw that the currencys had been updated a bit later on. After 4 days since they have last been updated. Then I saw that the support had sent me an email telling me they would look curl up.

So my guess is that it was inactive. This issue is solved! :)

And most likely curl. (Thanks rph!)

If curl really is required for auto update to work, maybe it should be mentioned in the documentation?

At the moment it says Auto Update Currency
If set to yes your store will automatically get currency rates and update the values daily."

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by rph » Tue Aug 30, 2011 4:24 am

OpenCart checks that cURL is running when you install it. The only way you might get around that is if you used an automated script like Simple Scripts or Softalicious.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by andrixx » Tue Aug 30, 2011 5:57 am

I used something like that, my host had it in the cPanel.

They also told me that 90% of the time curl was installed on their servers. Strange answer.

But alright, maybe it should not say in the documentation that you need curl. Atleast it's here on the forums now for the few people that get trouble with it.

And thanks again rph!

New member

Posts

Joined
Sat Jun 18, 2011 7:23 pm

Post by opencart-templates » Mon Mar 19, 2012 10:14 pm

This can be easily modified in opencart version 1.5.2+ either of these:

Code: Select all

<file name="admin/controller/common/home.php">
		<operation>
			<search position="replace"><![CDATA[
				$this->model_localisation_currency->updateCurrencies();
			]]></search>
			<add><![CDATA[
				$this->model_localisation_currency->updateCurrencies(true);
			]]></add>
		</operation>
	</file>
	<file name="admin/controller/setting/setting.php">
		<operation>
			<search position="replace"><![CDATA[
				$this->model_localisation_currency->updateCurrencies();
			]]></search>
			<add><![CDATA[
				$this->model_localisation_currency->updateCurrencies(true);
			]]></add>
		</operation>
	</file>
Visit either the Dashboard to auto update the currencies every time you visit this page.

Advanced Professional Email Template
Customers Pre-Sale. Inc abandoned cart email
Order Follow-Up Email. Inc request review
Email Validation with ZeroBounce


User avatar
Active Member

Posts

Joined
Mon May 16, 2011 7:24 pm
Location - UK

Post by Ed_Rolla » Sun Feb 16, 2014 1:46 am

As late as I am (we are actually in 2014), I've managed to go around the bug.

*Keep in mind I'm using OC v.1.5.6.1

What you should to is:
1. Create your currency (admin > System > Localization > Currencies > etc.), but leave it's value in blank (OC will deal with that);
2. Set it as your default currency (admin > System > Settings > etc.);
3. Go back to Currencies (notice that U$ will act as the basis for all the other currencies) and create some other currency, lets say: Ringgit Malaysia, MYR, MR. Again, leave the value in blank and hit save;
4. Notice the values will update. But now you default currency is the basis for all other currencies. :)

Hope I have helped!

WIP Design Publicidade e Marketing Digital


User avatar
New member

Posts

Joined
Sun Jul 15, 2012 12:16 am
Location - Brazil, Rio de Janeiro
Who is online

Users browsing this forum: darkhorse, Semrush [Bot] and 198 guests