Hi, good to know that someone is working on a Taiwan addressfield module.
However, after installing this module, I got this error:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 148: INSERT INTO {addressfield_tw} (`region_id`, `parent_id`, `region_name`, `region_type`, `agency_id`) VALUES (1, 0, '臺灣', 0, 0), (2, 1, '臺灣', 1, 0), (3, 2, '臺北市', 2, 0), (4, 2, '新北市', 2, 0), (5, 2, '基隆市', 2, 0), (6, 2, '桃園縣', 2, 0), (7, 2, '新竹市', 2, 0), (8, 2, '新竹縣', 2, 0), (9, 2, '苗栗縣', 2, 0), (10, 2, '台中市', 2, 0), (11, 2, '彰化縣', 2, 0), (12, 2, '南投縣', 2, 0), (13, 2, '雲林縣', 2, 0), (14, 2, '嘉義市', 2, 0), (15, 2, '嘉義縣', 2, 0), (16, 2, '台南市', 2, 0), (17, 2, '高雄市', 2, 0), (18, 2, '屏東縣', 2, 0), (19, 2, '宜蘭縣', 2, 0), (20, 2, '花蓮縣', 2, 0), (21, 2, '台東縣', 2, 0), (22, 2, '澎湖縣', 2, 0), (23, 2, '金門縣', 2, 0), (24, 2, '連江縣', 2, 0), (25, 3, '松山區', 3, 0), (26, 3, '大安區', 3, 0), (27, 3, '大同區', 3, 0), (28, 3, '中山區', 3, 0), (29, 3, '內湖區', 3, 0), (30, 3, '南港區', 3, 0), (31, 3, '士林區', 3, 0), (32, 3, '北投區', 3, 0), (33, 3, '信義區', 3, 0), (34, 3, '中正區', 3, 0), (35, 3, '萬華區', 3, 0), (36, 3, '文山區', 3, 0), (37, 4, '板橋區', 3, 0), (38, 4, '三重區', 3, 0), (39, 4, '永和區', 3, 0), (40, 4, '中和區', 3, 0), (41, 4, '新莊區', 3, 0), (42, 4, '新店區', 3, 0), (43, 4, '土城區', 3, 0), (44, 4, '蘆洲區', 3, 0), (45, 4, '汐止區', 3, 0), (46, 4, '樹林區', 3, 0), (47, 4, '鶯歌區', 3, 0), (48, 4, '三峽區', 3, 0), (49, 4, '淡水區', 3, 0), (50, 4, '瑞芳區', 3, 0), (51, 4, '五股區', 3, 0), (52, 4, '泰山區', 3, 0), (53, 4, '林口區', 3, 0), (54, 4, '深坑區', 3, 0), (55, 4, '石碇區', 3, 0), (56, 4, '坪林區', 3, 0), (57, 4, '三芝區', 3, 0), (58, 4, '石門區', 3, 0), (59, 4, '八里區', 3, 0), (60, 4, '平溪區', 3, 0), (61, 4, '雙溪區', 3, 0), (62, 4, '貢寮區', 3, 0), (63, 4, '金山區', 3, 0), (64, 4, '萬里區', 3, 0), (65, 4, '烏來區', 3, 0), (66, 5, '仁愛區', 3, 0), (67, 5, '中正區', 3, 0), (68, 5, '信義區', 3, 0), (69, 5, '中山區', 3, 0), (70, 5, '安樂區', 3, 0), (71, 5, '暖暖區', 3, 0), (72, 5, '七堵區', 3, 0), (73, 6, '桃園市', 3, 0), (74, 6, '中壢市', 3, 0), (75, 6, '平鎮市', 3, 0), (76, 6, '八德市', 3, 0), (77, 6, '楊梅市', 3, 0), (78, 6, '大溪鎮', 3, 0), (79, 6, '蘆竹鄉', 3, 0), (80, 6, '大園鄉', 3, 0), (81, 6, '龜山鄉', 3, 0), (82, 6, '龍潭鄉', 3, 0), (83, 6, '新屋鄉', 3, 0), (84, 6, '觀音鄉', 3, 0), (85, 6, '復興鄉', 3, 0), (86, 7, '東區', 3, 0), (87, 7, '北區', 3, 0), (88, 7, '香山區', 3, 0), (89, 8, '竹北市', 3, 0), (90, 8, '關西鎮', 3, 0), (91, 8, '新埔鎮', 3, 0), (92, 8, '竹東鎮', 3, 0), (93, 8, '湖口鄉', 3, 0), (94, 8, '橫山鄉', 3, 0), (95, 8, '新豐鄉', 3, 0), (96, 8, '芎林鄉', 3, 0), (97, 8, '寶山鄉', 3, 0), (98, 8, '北埔鄉', 3, 0), (99, 8, '峨眉鄉', 3, 0), (100, 8, '尖石鄉', 3, 0), (101, 8, '五峰鄉', 3, 0), (102, 9, '苗栗市', 3, 0), (103, 9, '苑裡鎮', 3, 0), (104, 9, '通霄鎮', 3, 0), (105, 9, '竹南鎮', 3, 0), (106, 9, '頭份鎮', 3, 0), (107, 9, '後龍鎮', 3, 0), (108, 9, '卓蘭鎮', 3, 0), (109, 9, '大湖鄉', 3, 0), (110, 9, '公館鄉', 3, 0), (111, 9, '銅鑼鄉', 3, 0), (112, 9, '南庄鄉', 3, 0), (113, 9, '頭屋鄉', 3, 0), (114, 9, '三義鄉', 3, 0), (115, 9, '西湖鄉', 3, 0), (116, 9, '造橋鄉', 3, 0), (117, 9, '三灣鄉', 3, 0), (118, 9, '獅潭鄉', 3, 0), (119, 9, '泰安鄉', 3, 0), (120, 10, '中區', 3, 0), (121, 10, '東區', 3, 0), (122, 10, '南區', 3, 0), (123, 10, '西區', 3, 0), (124, 10, '北區', 3, 0), (125, 10, '北屯區', 3, 0), (126, 10, '西屯區', 3, 0), (127, 10, '南屯區', 3, 0), (128, 10, '太平區', 3, 0), (129, 10, '大里區', 3, 0), (130, 10, '霧峰區', 3, 0), (131, 10, '烏日區', 3, 0), (132, 10, '豐原區', 3, 0), (133, 10, '后里區', 3, 0), (134, 10, '東勢區', 3, 0), (135, 10, '石岡區', 3, 0), (136, 10, '新社區', 3, 0), (137, 10, '和平區', 3, 0), (138, 10, '神岡區', 3, 0), (139, 10, '潭子區', 3, 0), (140, 10, '大雅區', 3, 0), (141, 10, '大肚區', 3, 0), (142, 10, '龍井區', 3, 0), (143, 10, '沙鹿區', 3, 0), (144, 10, '梧棲區', 3, 0), (145, 10, '清水區', 3, 0), (146, 10, '大甲區', 3, 0), (147, 10, '外埔區', 3, 0), (148, 10, '大安區', 3, 0), ;; Array ( ) in addressfield_tw_install() (line 239 of /sites/all/modules/address_field_taiwan/addressfield_tw.install)

Comments

agrozyme’s picture

please use the master branch, it use excel to build options, no need db.

agrozyme’s picture

Status: Active » Closed (won't fix)