X-Cart forums

[virtual@croatia]

Originally Posted by designtheweb

The next step of course is to link this into live rates so you don't have to change them. Not expecting Hrvoje to do this but any takers? Yes I know I can pay to have this done but someone may see this as a challenge?

Find a web site which produces a free rate list in csv format and I'll do it.

[designtheweb]

Unbelievable - to the rescue again: Try this one, xml & csv:
http://rss.timegenie.com/foreign_exchange_rates_forex

[TanyaG]

Hi Virtual,

Thank you so much for a brilliant module. It’s exactly what I needed. I just tried to make it work for 4.2.1. but unfortunately seems like I have a little problem.

For some reason it displays EUR as default currency even I’ve changed it to GBP in admin. But the biggest issue when I’m selecting different currency it sends me to home page and dropdown currency selection displays the same EUR. And displays following URL /home.php?redirect=%2Fhome.php%3F&sc=USD.

It is any chance you could advise me how it can be fixed.

Many thanks,
Tanya

[virtual@croatia]

Originally Posted by TanyaG

I just tried to make it work for 4.2.1. but unfortunately seems like I have a little problem.

For some reason it displays EUR as default currency even I▓ve changed it to GBP in admin. But the biggest issue when I▓m selecting different currency it sends me to home page and dropdown currency selection displays the same EUR. And displays following URL /home.php?redirect=%2Fhome.php%3F&sc=USD.

I'll try to fix it today. I will upload the new version as soon as I finish it.

[virtual@croatia]

Originally Posted by designtheweb

Unbelievable - to the rescue again: Try this one, xml & csv:
http://rss.timegenie.com/foreign_exchange_rates_forex

New version uploaded. You will have to uninstall and install the new one again. After that you'll have to set the active currencies again. In Modules/Multi Currency click Configure and set the default currency. This currency will not be changed during the auto update and all other currencies will be set by the default one. If there is no the default currency in the csv file, the EUR will be default.

http://www.smee.hr/skin1/images/xcart%20forum/modules.jpg

All updated currencies will be Italic and all other will stay regular.

[TanyaG]

Thank you very much for that. But seems like something is broken now. Installation wasn’t completed, was failure in creating xcart_currency_rate table and now I have:

INVALID SQL: 1146 : Table 'richleig_richleig123.xcart_currency_rate' doesn't exist
SQL QUERY FAILURE:SELECT code FROM xcart_currency_rate WHERE code='EUR' AND active='Y' LIMIT 1
INVALID SQL: 1146 : Table 'richleig_richleig123.xcart_currency_rate' doesn't exist
SQL QUERY FAILURE:SELECT code FROM xcart_currency_rate ORDER BY active DESC LIMIT 1
INVALID SQL: 1146 : Table 'richleig_richleig123.xcart_currency_rate' doesn't exist
SQL QUERY FAILURE:SELECT * FROM xcart_currencies INNER JOIN xcart_currency_rate ON xcart_currencies.code = xcart_currency_rate.code WHERE xcart_currency_rate.code='' AND xcart_currency_rate.active='Y' LIMIT 1
INVALID SQL: 1146 : Table 'richleig_richleig123.xcart_currency_rate' doesn't exist
SQL QUERY FAILURE:SELECT * FROM xcart_currencies INNER JOIN xcart_currency_rate ON xcart_currencies.code = xcart_currency_rate.code WHERE xcart_currency_rate.active='Y' ORDER BY xcart_currency_rate.order_by
Warning: Cannot modify header information - headers already sent by (output started at /home/richleig/public_html/include/func/func.db.php:204) in /home/richleig/public_html/include/get_language.php on line 164

Please could you help me fix it.

Many thanks,

Tanya

[TanyaG]

Just was created this table manually. Seems like error is gone, but now my drop down is empty

[virtual@croatia]

Originally Posted by TanyaG

Thank you very much for that. But seems like something is broken now. Installation wasn▓t completed, was failure in creating xcart_currency_rate table and now I have:

The version for 4.2.1 is not yet fixed. I'll do it now, so please come back in one hour time, the new version will be uploaded.
In the mean time uninstall the module not to get the error messages.

[virtual@croatia]

Originally Posted by TanyaG

Just was created this table manually. Seems like error is gone, but now my drop down is empty

I made some changes, please download the last version from the first post, it should work fine now.

[TanyaG]

Hi Virtual,

Thank you very much for your help. Unfortunately still the same issue. By selecting a currency it sends me to home page and URL: http://85.92.86.119/home.php?redirect=%2Fdispatcher.php%3F&sc=USD

Many thanks,

Tanya