Re: Multi currency modul
 

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

Re: Multi currency modul
 

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

Re: Multi currency modul
 

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

Re: Multi currency modul
 

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

Re: Multi currency modul
 

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.

Re: Multi currency modul
 

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

Re: Multi currency modul
 

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

Re: Multi currency modul
 

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.

Re: Multi currency modul
 

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

Re: Multi currency modul
 

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