Country missing

[web9000]

ok, i found out why my cart is declining CC's

United States is missing from the countries table

i know i chaned it to -United States- so it would be at the top of list, but somehow it got deleted

i need to know what to enter for ...

Alpha2

Alpha3

Numeric Code

so i can replace it in the table


thanks

[Jamie]

Hi,

If you haven't made other changes to the country table, you would be better off adding the record via MySQL using phpMyAdmin. This will ensure that the record_number we use for the US will not change. I don't believe we use this anywhere, but may in the future. If you add it manually in the admin section, you could cause problems in the future.

To add the record back, paste this query into phpMyAdmin's query box, and submit it:

INSERT INTO Countries VALUES (180, 'United States', 'US', 'USA', 840);

Thanks,
Jamie

[web9000]

ok, i got an error, duplicate value for 180

i checked and apparently the record was not deleted, its still there

my problem is that all CC's are being declined

i talked to iTransact and they said the data being submited to their server does not include the country

what else could be wrong?

only things i have done to the countires tables is change "United States" to "-United States-" so it shows at the top of the drop down menu

i tried changing it back and it still does not work

there is a blank space at the top of the drop down menu for country, not sure if that matters?

[Jamie]

Hi,

What I would suggest is that you delete the record for the US, and then try that query again. We need to make absolutely certain that the record matches the original distribution.

Also, after you do that, make sure you test with a newly opened browser window to make sure you get the latest changes.

The cart definitely passes the country value to them, so the problem most likely lies in the modification of the record for US.

Thanks,
Jamie

[web9000]

ok, deleting and re-adding the record seems to have worked

thanks :)