I've enabled both the Address Field module and the Canadian Support, but I don't have a checkbox for Canada under allowed countries when I configure the address field. Also, when I check my database, Canada isn't in cck_address_countries and the Provinces aren't in cck_address_states.
One option is to manually run the proceeding code but is this a known issue or did I miss something?

INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Alberta', 'AB', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('British Columbia', 'BC', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Manitoba', 'MB', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('New Brunswick', 'NB', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Newfoundland and Labrador', 'NL', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Northwest Territories', 'NT', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Nova Scotia', 'NS', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Nunavut', 'NU', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Ontario', 'ON', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Prince Edward Island', 'PE', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Quebec', 'QC', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Saskatchewan', 'SK', 'CA');
INSERT INTO cck_address_states (state_name, state_abbrv, country_code) VALUES ('Yukon', 'YT', 'CA');
INSERT INTO cck_address_countries (country_name, country_code) VALUES ('Canada', 'CA');

Comments

suthy’s picture

Category: support » bug
Status: Active » Closed (fixed)

Turned out to be fixed after we discovered a larger multisite issue (MySQL: SHOW TABLES LIKE database.tablename doesn't work) which was solved by a colleague, webkenny, here.