Quote:
Originally Posted by konadnailart
Hi
I got the following error when trying to install, any pointers. Am using 4.1.9.
Thanks
Copying skin files ...
Copying to file skin1\modules/Multi_Currency\currencies.tpl - [OK]
Copying to file skin1\modules/Multi_Currency\menu_currency.tpl - [OK]
[OK]
Activating the module ...
Please wait ...
[OK]
Please wait ...
Creating table: [xcart_currency_rate] ... [OK]
[FAILED] You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT value FROM xcart_config WHERE name = 'currency_symbol')
|
Hi,
I didn't get any email for this thread that's why I didn't respond earlier.
Try to manually execute the SQL code to see what kind of error do you get. Open the php MyAdmin for your database (you should've got it from your web provider) and execute the following:
UPDATE xcart_currency_rate SET active = 'Y' WHERE code = (SELECT value FROM xcart_config WHERE name = 'currency_symbol') OR code = (SELECT xcart_currencies.code FROM xcart_currencies INNER JOIN xcart_config ON xcart_currencies.symbol = xcart_config.value AND xcart_config.name = 'currency_symbol');
CREATE TABLE xcart_customer_currency (
login VARCHAR ( 32 ) NOT NULL DEFAULT '',
currency CHAR( 3 ) NOT NULL DEFAULT '',
PRIMARY KEY (login)
) TYPE=MyISAM;
Send me a post if you get any errror.
virtual