X-Cart forums

[Rob Maskell]

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', '');

[Learner]

Originally Posted by Learner

Hi, ShishaPipeUK

Our Primary currency is set to one Credit card payment method ..

All we want is to link alt currency for customers opting to pay using Paypal (in USD -"$")...

Is it possible?

Thanks to all in advance !!

Is it possible to do? Any help from forum?

[Rob Maskell]

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

[Rob Maskell]

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

[Learner]

Originally Posted by Rob Maskell

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

What solution Rob Maskell? Alternative currency in Paypal?

[collings26]

Does this work in 4.3?

[vasilis]

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 ?

[qualiteam]

Moving to "Completed Custom Mods & Templates" forum.