Uk Currency won't work

[jackk]

Hi,

 

ever since i added the uk currency in the admin all the prices & postage costs have shown a resounding 0. I've checked through this forum and implemented all the suggestions in previous threads people have made with this query, however as of yet none have worked. So far ive tried adding it as usual like this

 

Title: UK Pound

Code: GBP

 

Symbol Left: ?

Symbol Right:

 

Decimal Point: .

Thousands Point: ,

Decimal Places:

 

Last Updated: 08/25/2006

Value: 1.00000000

 

Example Output:

?30 = ?30

 

Ive tried many variations of 'decimal places' & titles. Ive done the 'delete all then re-add'. (of course using the update currency button which says that it worked). Tried the contribution found here - http://www.oscommerce.com/community/contri...l/search,uk+gbp this one had an error message ,adding the Mysql, from phpadmin saying

SQL query:

 

INSERT INTO currencies

VALUES ( 5, 'GBP', 'GBP', '�', '', '.', '.', '2' )

 

MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1

could this be something to do with it?

Ive also tried doing all of the above then adding products afterwards but still nothing.

 

Can anyone think of anything else thast may be causing this? Maybe a stray php file somewhere doing something?

 

cheers

-jack

[Guest]

Did you created a new default currency?

In the edit did you put 1.0000000 as the value and then click on update currencies button ?

and in the catalog/includes/languages/english.php around line 36

 

// if USE_DEFAULT_LANGUAGE_CURRENCY is true, use the following currency, instead of the applications default currency (used w$

 

define('LANGUAGE_CURRENCY', 'USD');

Change it to whatever you need

 

HTH

The_Bear

[jackk]

in the catalog/includes/languages/english.php around line 36

 

// if USE_DEFAULT_LANGUAGE_CURRENCY is true, use the following currency, instead of the applications default currency (used w$

 

define('LANGUAGE_CURRENCY', 'USD');

Change it to whatever you need

 

 

Ahha this was it, thanks very much indeed The_Bear.

I just had to change the USD to GBP - for the reference of anyone else with this problem.