Closed (fixed)
Project:
Address field for CCK
Version:
5.x-2.1
Component:
Miscellaneous
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
4 Nov 2008 at 17:47 UTC
Updated:
11 Nov 2008 at 17:37 UTC
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
Comment #1
suthy commentedTurned 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.