Re: Multiple Currencies Mod Complete (v4.1.2)
 

Hi Guys,

I have done all the steps in installing this module but while inserting Mysql query in xcart_config I am getting the following error:

Error

SQL query:
INSERT INTO `xcart_config`
VALUES ( 'currency_rate_usd', 'Rate for the US Dollar', '1', 'Multiple_Currency', 0, 'numeric', '1.0', ''
)
MySQL said: http://localhost/phpmyadmin/themes/original/img/b_help.png
#1136 - Column count doesn't match value count at row 1



SQL query that I entered:

INSERT INTO `xcart_config` VALUES ('currency_rate_usd', 'Rate for the US Dollar', '1', 'Multiple_Currency', 0, 'numeric', '1.0', '');

Re: Multiple Currencies Mod Complete (v4.1.2)
 

Is it possible to do? Any help from forum?

Re: Multiple Currencies Mod Complete (v4.1.2)
 

I have already got the solution and even got a currency dropdown but its not displaying anything in it.

Re: Multiple Currencies Mod Complete (v4.1.2)
 

Got the answer guys ....
just changed the values of 'rate' in the xcart_currencies in the database from 0 to anything else.

Re: Multiple Currencies Mod Complete (v4.1.2)
 

What solution Rob Maskell? Alternative currency in Paypal?

Re: Multiple Currencies Mod Complete (v4.1.2)
 

Does this work in 4.3?

Re: Multiple Currencies Mod Complete (v4.1.2)
 

I have tried to install it in a 4.3.1 store, with some modified steps regarding the db sql queries and a couple of template files. I get the multi-currency drop-down on the front-end, but when I change the rates in the admin section, the updated values update the xcart_config table. The xcart_currencies table is not updated. I guess, that's the table from which the front-end currency values get updated. Has anybody else had any luck with 4.3 ?

Re: Multiple Currencies Mod Complete (v4.1.2)
 

Moving to "Completed Custom Mods & Templates" forum.