Добрый вечер!
Стоит Joomla 2.5.8 поставил по ошибки копонент Component JoomShopping 2.9.7 а надо было поставить Component JoomShopping 3.12.3. Пробовал удалить не получилось. Удалил папки на хостинге public_html / components / com_jshopping и папку public_html / administrator / components / com_jshopping так же удалил все таблицы в базы Базы MySQL Потом попытался поставить Component JoomShopping 3.12.3 вот какую ошибку выдал:
[code]
JInstaller: :Install: Ошибка SQL Ошибка базы данных с номером 1062
Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `sl8xr_jshopping_countries` (`country_id`, `country_publish`, `ordering`, `country_code`, `country_code_2`, `name_en-GB`, `name_de-DE`) VALUES (1, 1, 1, 'AFG', 'AF', 'Afghanistan', 'Afghanistan'), (2, 1, 2, 'ALB', 'AL', 'Albania', 'Albanien'), (3, 1, 3, 'DZA', 'DZ', 'Algeria', 'Algerien'), (4, 1, 4, 'ASM', 'AS', 'American Samoa', 'Amerikanisch-Samoa'), (5, 1, 5, 'AND', 'AD', 'Andorra', 'Andorra'), (6, 1, 6, 'AGO', 'AO', 'Angola', 'Angola'), (7, 1, 7, 'AIA', 'AI', 'Anguilla', 'Anguilla'), (8, 1, 8, 'ATA', 'AQ', 'Antarctica', 'Antarktis'), (9, 1, 9, 'ATG', 'AG', 'Antigua and Barbuda', 'Antigua und Barbuda'), (10, 1, 10, 'ARG', 'AR', 'Argentina', 'Argentinien'), (11, 1, 11, 'ARM', 'AM', 'Armenia', 'Armenien'), (12, 1, 12, 'ABW', 'AW', 'Aruba', 'Aruba'), (13, 1, 13, 'AUS', 'AU', 'Australia', 'Australien'), (14, 1, 14, 'AUT', 'AT', 'Austria', 'Österreich'), (15, 1, 15, 'AZE', 'AZ', 'Azerbaijan', 'Aserbaidschan'), (16, 1, 16, 'BHS', 'BS', 'Bahamas', 'Bahamas'), (17, 1, 17, 'BHR', 'BH', 'Bahrain', 'Bahrain'), (18, 1, 18, 'BGD', 'BD', 'Bangladesh', 'Bangladesch'), (19, 1, 19, 'BRB', 'BB', 'Barbados', 'Barbados'), (20, 1, 20, 'BLR', 'BY', 'Belarus', 'Weissrussland'), (21, 1, 21, 'BEL', 'BE', 'Belgium', 'Belgien'), (22, 1, 22, 'BLZ', 'BZ', 'Belize', 'Belize'), (23, 1, 23, 'BEN', 'BJ', 'Benin', 'Benin'), (24, 1, 24, 'BMU', 'BM', 'Bermuda', 'Bermuda'), (25, 1, 25, 'BTN', 'BT', 'Bhutan', 'Bhutan'), (26, 1, 26, 'BOL', 'BO', 'Bolivia', 'Bolivien'), (27, 1, 27, 'BIH', 'BA', 'Bosnia and Herzegowina', 'Bosnien und Herzegowina'), (28, 1, 28, 'BWA', 'BW', 'Botswana', 'Botsuana'), (29, 1, 29, 'BVT', 'BV', 'Bouvet Island', 'Bouvetinsel'), (30, 1, 30, 'BRA', 'BR', 'Brazil', 'Brasilien'), (31, 1, 31, 'IOT', 'IO', 'British Indian Ocean Territory', 'Britisches Territorium im Indischen Ozean'), (32, 1, 32, 'BRN', 'BN', 'Brunei Darussalam', 'Brunei'), (33, 1, 33, 'BGR', 'BG', 'Bulgaria', 'Bulgarien'), (34, 1, 34, 'BFA', 'BF', 'Burkina Faso', 'Burkina Faso'), (35, 1, 35, 'BDI', 'BI', 'Burundi', 'Burundi'), (36, 1, 36, 'KHM', 'KH', 'Cambodia', 'Kambodscha'), (37, 1, 37, 'CMR', 'CM', 'Cameroon', 'Kamerun'), (38, 1, 38, 'CAN', 'CA', 'Canada', 'Kanada'), (39, 1, 39, 'CPV', 'CV', 'Cape Verde', 'Kap Verde'), (40, 1, 40, 'CYM', 'KY', 'Cayman Islands', 'Cayman-Inseln'), (41, 1, 41, 'CAF', 'CF', 'Central African Republic', 'Zentralafrikanische Republik'), (42, 1, 42, 'TCD', 'TD', 'Chad', 'Tschad'), (43, 1, 43, 'CHL', 'CL', 'Chile', 'Chile'), (44, 1, 44, 'CHN', 'CN', 'China', 'China'), (45, 1, 45, 'CXR', 'CX', 'Christmas Island', 'Christmas Island'), (46, 1, 46, 'CCK', 'CC', 'Cocos (Keeling) Islands', 'Kokosinseln (Keeling)'), (47, 1, 47, 'COL', 'CO', 'Colombia', 'Kolumbien'), (48, 1, 48, 'COM', 'KM', 'Comoros', 'Komoren'), (49, 1, 49, 'COG', 'CG', 'Congo', 'Kongo, Republik'), (50, 1, 50, 'COK', 'CK', 'Cook Islands', 'Cookinseln'), (51, 1, 51, 'CRI', 'CR', 'Costa Rica', 'Costa Rica'), (52, 1, 52, 'CIV', 'CI', 'Cote D''Ivoire', 'Elfenbeinküste'), (53, 1, 53, 'HRV', 'HR', 'Croatia', 'Kroatien'), (54, 1, 54, 'CUB', 'CU', 'Cuba', 'Kuba'), (55, 1, 55, 'CYP', 'CY', 'Cyprus', 'Zypern'), (56, 1, 56, 'CZE', 'CZ', 'Czech Republic', 'Tschechien'), (57, 1, 57, 'DNK', 'DK', 'Denmark', 'Dänemark'), (58, 1, 58, 'DJI', 'DJ', 'Djibouti', 'Dschibuti'), (59, 1, 59, 'DMA', 'DM', 'Dominica', 'Dominica'), (60, 1, 60, 'DOM', 'DO', 'Dominican Republic', 'Dominikanische Republik'), (61, 1, 61, 'TMP', 'TL', 'East Timor', 'Osttimor'), (62, 1, 62, 'ECU', 'EC', 'Ecuador', 'Ecuador'), (63, 1, 63, 'EGY', 'EG', 'Egypt', 'Ägypten'), (64, 1, 64, 'SLV', 'SV', 'El Salvador', 'El Salvador'), (65, 1, 65, 'GNQ', 'GQ', 'Equatorial Guinea', 'Äquatorial-Guinea'), (66, 1, 66, 'ERI', 'ER', 'Eritrea', 'Eritrea'), (67, 1, 67, 'EST', 'EE', 'Estonia', 'Estland'), (68, 1, 68, 'ETH', 'ET', 'Ethiopia', 'Äthiopien'), (69, 1, 69, 'FLK', 'FK', 'Falkland Islands (Malvinas)', 'Falklandinseln'), (70, 1, 70, 'FRO', 'FO', 'Faroe Islands', 'Färöer'), (71, 1, 71, 'FJI', 'FJ', 'Fiji', 'Fidschi'), (72, 1, 72, 'FIN', 'FI', 'Finland', 'Finnland'), (73, 1, 73, 'FRA', 'FR', 'France', 'Frankreich'), (74, 1, 74, 'FXX', 'FX', 'France Metropolitan', 'Frankreich, Metropolitan'), (75, 1, 75, 'GUF', 'GF', 'French Guiana', 'Französisch-Guyana'), (76, 1, 76, 'PYF', 'PF', 'French Polynesia', 'Franz. Polynesien'), (77, 1, 77, 'ATF', 'TF', 'French Southern Territories', 'Französiche Süd- und Antarktisgebiete'), (78, 1, 78, 'GAB', 'GA', 'Gabon', 'Gabun'), (79, 1, 79, 'GMB', 'GM', 'Gambia', 'Gambia'), (80, 1, 80, 'GEO', 'GE', 'Georgia', 'Georgien'), (81, 1, 81, 'DEU', 'DE', 'Germany', 'Deutschland'), (82, 1, 82, 'GHA', 'GH', 'Ghana', 'Ghana'), (83, 1, 83, 'GIB', 'GI', 'Gibraltar', 'Gibraltar'), (84, 1, 84, 'GRC', 'GR', 'Greece', 'Griechenland'), (85, 1, 85, 'GRL', 'GL', 'Greenland', 'Grönland'), (86, 1, 86, 'GRD', 'GD', 'Grenada', 'Grenada'), (87, 1, 87, 'GLP', 'GP', 'Guadeloupe', 'Guadeloupe'), (88, 1, 88, 'GUM', 'GU', 'Guam', 'Guam'), (89, 1, 89, 'GTM', 'GT', 'Guatemala', 'Guatemala'), (90, 1, 90, 'GIN', 'GN', 'Guinea', 'Guinea'), (91, 1, 91, 'GNB', 'GW', 'Guinea-bissau', 'Guinea-Bissau'), (92, 1, 92, 'GUY', 'GY', 'Guyana', 'Guyana'), (93, 1, 93, 'HTI', 'HT', 'Haiti', 'Haiti'), (94, 1, 94, 'HMD', 'HM', 'Heard and Mc Donald Islands', 'Heard und McDonaldinseln'), (95, 1, 95, 'HND', 'HN', 'Honduras', 'Honduras'), (96, 1, 96, 'HKG', 'HK', 'Hong Kong', 'Hong Kong'), (97, 1, 97, 'HUN', 'HU', 'Hungary', 'Ungarn'), (98, 1, 98, 'ISL', 'IS', 'Iceland', 'Island'), (99, 1, 99, 'IND', 'IN', 'India', 'Indien'), (100, 1, 100, 'IDN', 'ID', 'Indonesia', 'Indonesien'), (101, 1, 101, 'IRN', 'IR', 'Iran (Islamic Republic of)', 'Iran'), (102, 1, 102, 'IRQ', 'IQ', 'Iraq', 'Irak'), (103, 1, 103, 'IRL', 'IE', 'Ireland', 'Irland'), (104, 1, 104, 'ISR', 'IL', 'Israel', 'Israel'), (105, 1, 105, 'ITA', 'IT', 'Italy', 'Italien'), (106, 1, 106, 'JAM', 'JM', 'Jamaica', 'Jamaika'), (107, 1, 107, 'JPN', 'JP', 'Japan', 'Japan'), (108, 1, 108, 'JOR', 'JO', 'Jordan', 'Jordanien'), (109, 1, 109, 'KAZ', 'KZ', 'Kazakhstan', 'Kasachstan'), (110, 1, 110, 'KEN', 'KE', 'Kenya', 'Kenia'), (111, 1, 111, 'KIR', 'KI', 'Kiribati', 'Kiribati'), (112, 1, 112, 'PRK', 'KP', 'Korea Democratic People''s Republic of', 'Korea Demokratische Volksrepublik'), (113, 1, 113, 'KOR', 'KR', 'Korea Republic of', 'Korea'), (114, 1, 114, 'KWT', 'KW', 'Kuwait', 'Kuwait'), (115, 1, 115, 'KGZ', 'KG', 'Kyrgyzstan', 'Kirgistan'), (116, 1, 116, 'LAO', 'LA', 'Lao People''s Democratic Republic', 'Laos'), (117, 1, 117, 'LVA', 'LV', 'Latvia', 'Lettland'), (118, 1, 118, 'LBN', 'LB', 'Lebanon', 'Libanon'), (119, 1, 119, 'LSO', 'LS', 'Lesotho', 'Lesotho'), (120, 1, 120, 'LBR', 'LR', 'Liberia', 'Liberia'), (121, 1, 121, 'LBY', 'LY', 'Libyan Arab Jamahiriya', 'Libyen'), (122, 1, 122, 'LIE', 'LI', 'Liechtenstein', 'Liechtenstein'), (123, 1, 123, 'LTU', 'LT', 'Lithuania', 'Litauen'), (124, 1, 124, 'LUX', 'LU', 'Luxembourg', 'Luxemburg'), (125, 1, 125, 'MAC', 'MO', 'Macau', 'Makao'), (126, 1, 126, 'MKD', 'MK', 'Macedonia The Former Yugoslav Republic of', 'Mazedonien'), (127, 1, 127, 'MDG', 'MG', 'Madagascar', 'Madagaskar'), (128, 1, 128, 'MWI', 'MW', 'Malawi', 'Malawi'), (129, 1, 129, 'MYS', 'MY', 'Malaysia', 'Malaysia'), (130, 1, 130, 'MDV', 'MV', 'Maldives', 'Malediven'), (131, 1, 131, 'MLI', 'ML', 'Mali', 'Mali'), (132, 1, 132, 'MLT', 'MT', 'Malta', 'Malta'), (133, 1, 133, 'MHL', 'MH', 'Marshall Islands', 'Marshallinseln'), (134, 1, 134, 'MTQ', 'MQ', 'Martinique', 'Martinique'), (135, 1, 135, 'MRT', 'MR', 'Mauritania', 'Mauretanien'), (136, 1, 136, 'MUS', 'MU', 'Mauritius', 'Mauritius'), (137, 1, 137, 'MYT', 'YT', 'Mayotte', 'Mayott'), (138, 1, 138, 'MEX', 'MX', 'Mexico', 'Mexiko'), (139, 1, 139, 'FSM', 'FM', 'Micronesia Federated States of', 'Mikronesien'), (140, 1, 140, 'MDA', 'MD', 'Moldova Republic of', 'Moldawien'), (141, 1, 141, 'MCO', 'MC', 'Monaco', 'Monaco'), (142, 1, 142, 'MNG', 'MN', 'Mongolia', 'Mongolei'), (143, 1, 143, 'MSR', 'MS', 'Montserrat', 'Montserrat'), (144, 1, 144, 'MAR', 'MA', 'Morocco', 'Marokko'), (145, 1, 145, 'MOZ', 'MZ', 'Mozambique', 'Mosambik'), (146, 1, 146, 'MMR', 'MM', 'Myanmar', 'Myanmar'), (147, 1, 147, 'NAM', 'NA', 'Namibia', 'Namibia'), (148, 1, 148, 'NRU', 'NR', 'Nauru', 'Nauru'), (149, 1, 149, 'NPL', 'NP', 'Nepal', 'Nepal'), (150, 1, 150, 'NLD', 'NL', 'Netherlands', 'Niederlande'), (151, 1, 151, 'ANT', 'AN', 'Netherlands Antilles', 'Niederländisch-Antillen'), (152, 1, 152, 'NCL', 'NC', 'New Caledonia', 'Neukaledonien'), (153, 1, 153, 'NZL', 'NZ', 'New Zealand', 'Neuseeland'), (154, 1, 154, 'NIC', 'NI', 'Nicaragua', 'Nicaragua'), (155, 1, 155, 'NER', 'NE', 'Niger', 'Niger'), (156, 1, 156, 'NGA', 'NG', 'Nigeria', 'Nigeria'), (157, 1, 157, 'NIU', 'NU', 'Niue', 'Niue'), (158, 1, 158, 'NFK', 'NF', 'Norfolk Island', 'Norfolkinsel'), (159, 1, 159, 'MNP', 'MP', 'Northern Mariana Islands', 'Nördliche Marianen'), (160, 1, 160, 'NOR', 'NO', 'Norway', 'Norwegen'), (161, 1, 161, 'OMN', 'OM', 'Oman', 'Oman'), (162, 1, 162, 'PAK', 'PK', 'Pakistan', 'Pakistan'), (163, 1, 163, 'PLW', 'PW', 'Palau', 'Palau'), (164, 1, 164, 'PAN', 'PA', 'Panama', 'Panama'), (165, 1, 165, 'PNG', 'PG', 'Papua New Guinea', 'Papua-Neuguinea'), (166, 1, 166, 'PRY', 'PY', 'Paraguay', 'Paraguay'), (167, 1, 167, 'PER', 'PE', 'Peru', 'Peru'), (168, 1, 168, 'PHL', 'PH', 'Philippines', 'Philippinen'), (169, 1, 169, 'PCN', 'PN', 'Pitcairn', 'Pitcairn'), (170, 1, 170, 'POL', 'PL', 'Poland', 'Polen'), (171, 1, 171, 'PRT', 'PT', 'Portugal', 'Portugal'), (172, 1, 172, 'PRI', 'PR', 'Puerto Rico', 'Puerto Rico'), (173, 1, 173, 'QAT', 'QA', 'Qatar', 'Katar'), (174, 1, 174, 'REU', 'RE', 'Reunion', 'Reunion'), (175, 1, 175, 'ROM', 'RO', 'Romania', 'Rumänien'), (176, 1, 176, 'RUS', 'RU', 'Russian Federation', 'Russische Föderation'), (177, 1, 177, 'RWA', 'RW', 'Rwanda', 'Ruanda'), (178, 1, 178, 'KNA', 'KN', 'Saint Kitts and Nevis', 'St. Kitts und Nevis'), (179, 1, 179, 'LCA', 'LC', 'Saint Lucia', 'St. Lucia'), (180, 1, 180, 'VCT', 'VC', 'Saint Vincent and the Grenadines', 'St. Vincent und die Grenadinen'), (181, 1, 181, 'WSM', 'WS', 'Samoa', 'Samoa'), (182, 1, 182, 'SMR', 'SM', 'San Marino', 'San Marino'), (183, 1, 183, 'STP', 'ST', 'Sao Tome and Principe', 'Sao Tomé und Príncipe'), (184, 1, 184, 'SAU', 'SA', 'Saudi Arabia', 'Saudi-Arabien'), (185, 1, 185, 'SEN', 'SN', 'Senegal', 'Senegal'), (186, 1, 186, 'SYC', 'SC', 'Seychelles', 'Seychellen'), (187, 1, 187, 'SLE', 'SL', 'Sierra Leone', 'Sierra Leone'), (188, 1, 188, 'SGP', 'SG', 'Singapore', 'Singapur'), (189, 1, 189, 'SVK', 'SK', 'Slovakia (Slovak Republic)', 'Slowakei'), (190, 1, 190, 'SVN', 'SI', 'Slovenia', 'Slowenien'), (191, 1, 191, 'SLB', 'SB', 'Solomon Islands', 'Salomonen'), (192, 1, 192, 'SOM', 'SO', 'Somalia', 'Somalia'), (193, 1, 193, 'ZAF', 'ZA', 'South Africa', 'Republik Südafrika'), (194, 1, 194, 'SGS', 'GS', 'South Georgia and the South Sandwich Islands', 'Südgeorgien und die Südlichen Sandwichinseln'), (195, 1, 195, 'ESP', 'ES', 'Spain', 'Spanien'), (196, 1, 196, 'LKA', 'LK', 'Sri Lanka', 'Sri Lanka'), (197, 1, 197, 'SHN', 'SH', 'St. Helena', 'St. Helena'), (198, 1, 198, 'SPM', 'PM', 'St. Pierre and Miquelon', 'St. Pierre und Miquelon'), (199, 1, 199, 'SDN', 'SD', 'Sudan', 'Sudan'), (200, 1, 200, 'SUR', 'SR', 'Suriname', 'Suriname'), (201, 1, 201, 'SJM', 'SJ', 'Svalbard and Jan Mayen Islands', 'Svalbard und Jan Mayen'), (202, 1, 202, 'SWZ', 'SZ', 'Swaziland', 'Swasiland'), (203, 1, 203, 'SWE', 'SE', 'Sweden', 'Schweden'), (204, 1, 204, 'CHE', 'CH', 'Switzerland', 'Schweiz'), (205, 1, 205, 'SYR', 'SY', 'Syrian Arab Republic', 'Syrien'), (206, 1, 206, 'TWN', 'TW', 'Taiwan', 'Taiwan'), (207, 1, 207, 'TJK', 'TJ', 'Tajikistan', 'Tadschikistan'), (208, 1, 208, 'TZA', 'TZ', 'Tanzania United Republic of', 'Tansania'), (209, 1, 209, 'THA', 'TH', 'Thailand', 'Thailand'), (210, 1, 210, 'TGO', 'TG', 'Togo', 'Togo'), (211, 1, 211, 'TKL', 'TK', 'Tokelau', 'Tokelau'), (212, 1, 212, 'TON', 'TO', 'Tonga', 'Tonga'), (213, 1, 213, 'TTO', 'TT', 'Trinidad and Tobago', 'Trinidad und Tobago'), (214, 1, 214, 'TUN', 'TN', 'Tunisia', 'Tunesien'), (215, 1, 215, 'TUR', 'TR', 'Turkey', 'Türkei'), (216, 1, 216, 'TKM', 'TM', 'Turkmenistan', 'Turkmenistan'), (217, 1, 217, 'TCA', 'TC', 'Turks and Caicos Islands', 'Turks- und Caicosinseln'), (218, 1, 218, 'TUV', 'TV', 'Tuvalu', 'Tuvalu'), (219, 1, 219, 'UGA', 'UG', 'Uganda', 'Uganda'), (220, 1, 220, 'UKR', 'UA', 'Ukraine', 'Ukraine'), (221, 1, 221, 'ARE', 'AE', 'United Arab Emirates', 'Vereinigte Arabische Emirate'), (222, 1, 222, 'GBR', 'GB', 'United Kingdom', 'Vereinigtes Königreich'), (223, 1, 223, 'USA', 'US', 'United States', 'USA'), (224, 1, 224, 'UMI', 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands'), (225, 1, 225, 'URY', 'UY', 'Uruguay', 'Uruguay'), (226, 1, 226, 'UZB', 'UZ', 'Uzbekistan', 'Usbekistan'), (227, 1, 227, 'VUT', 'VU', 'Vanuatu', 'Vanuatu'), (228, 1, 228, 'VAT', 'VA', 'Vatican City State (Holy See)', 'Vatikanstadt'), (229, 1, 229, 'VEN', 'VE', 'Venezuela', 'Venezuela'), (230, 1, 230, 'VNM', 'VN', 'Viet Nam', 'Vietnam'), (231, 1, 231, 'VGB', 'VG', 'Virgin Islands (British)', 'Britische Jungferninseln'), (232, 1, 232, 'VIR', 'VI', 'Virgin Islands (U.S.)', 'Vereinigte Staaten von Amerika'), (233, 1, 233, 'WLF', 'WF', 'Wallis and Futuna Islands', 'Wallis und Futuna'), (234, 1, 234, 'ESH', 'EH', 'Western Sahara', 'Westsahara'), (235, 1, 235, 'YEM', 'YE', 'Yemen', 'Jemen'), (236, 1, 236, 'YUG', 'YU', 'Yugoslavia', 'Yugoslavia'), (237, 1, 237, 'ZAR', 'ZR', 'Zaire', 'Zaire'), (238, 1, 238, 'ZMB', 'ZM', 'Zambia', 'Sambia'), (239, 1, 239, 'ZWE', 'ZW', 'Zimbabwe', 'Simbabwe');
SQL =
INSERT INTO `#__jshopping_countries` (`country_id`, `country_publish`, `ordering`, `country_code`, `country_code_2`, `name_en-GB`, `name_de-DE`) VALUES
(1, 1, 1, 'AFG', 'AF', 'Afghanistan', 'Afghanistan'),
(2, 1, 2, 'ALB', 'AL', 'Albania', 'Albanien'),
(3, 1, 3, 'DZA', 'DZ', 'Algeria', 'Algerien'),
(4, 1, 4, 'ASM', 'AS', 'American Samoa', 'Amerikanisch-Samoa'),
(5, 1, 5, 'AND', 'AD', 'Andorra', 'Andorra'),
(6, 1, 6, 'AGO', 'AO', 'Angola', 'Angola'),
(7, 1, 7, 'AIA', 'AI', 'Anguilla', 'Anguilla'),
(8, 1, 8, 'ATA', 'AQ', 'Antarctica', 'Antarktis'),
(9, 1, 9, 'ATG', 'AG', 'Antigua and Barbuda', 'Antigua und Barbuda'),
(10, 1, 10, 'ARG', 'AR', 'Argentina', 'Argentinien'),
(11, 1, 11, 'ARM', 'AM', 'Armenia', 'Armenien'),
(12, 1, 12, 'ABW', 'AW', 'Aruba', 'Aruba'),
(13, 1, 13, 'AUS', 'AU', 'Australia', 'Australien'),
(14, 1, 14, 'AUT', 'AT', 'Austria', 'Österreich'),
(15, 1, 15, 'AZE', 'AZ', 'Azerbaijan', 'Aserbaidschan'),
(16, 1, 16, 'BHS', 'BS', 'Bahamas', 'Bahamas'),
(17, 1, 17, 'BHR', 'BH', 'Bahrain', 'Bahrain'),
(18, 1, 18, 'BGD', 'BD', 'Bangladesh', 'Bangladesch'),
(19, 1, 19, 'BRB', 'BB', 'Barbados', 'Barbados'),
(20, 1, 20, 'BLR', 'BY', 'Belarus', 'Weissrussland'),
(21, 1, 21, 'BEL', 'BE', 'Belgium', 'Belgien'),
(22, 1, 22, 'BLZ', 'BZ', 'Belize', 'Belize'),
(23, 1, 23, 'BEN', 'BJ', 'Benin', 'Benin'),
(24, 1, 24, 'BMU', 'BM', 'Bermuda', 'Bermuda'),
(25, 1, 25, 'BTN', 'BT', 'Bhutan', 'Bhutan'),
(26, 1, 26, 'BOL', 'BO', 'Bolivia', 'Bolivien'),
(27, 1, 27, 'BIH', 'BA', 'Bosnia and Herzegowina', 'Bosnien und Herzegowina'),
(28, 1, 28, 'BWA', 'BW', 'Botswana', 'Botsuana'),
(29, 1, 29, 'BVT', 'BV', 'Bouvet Island', 'Bouvetinsel'),
(30, 1, 30, 'BRA', 'BR', 'Brazil', 'Brasilien'),
(31, 1, 31, 'IOT', 'IO', 'British Indian Ocean Territory', 'Britisches Territorium im Indischen Ozean'),
(32, 1, 32, 'BRN', 'BN', 'Brunei Darussalam', 'Brunei'),
(33, 1, 33, 'BGR', 'BG', 'Bulgaria', 'Bulgarien'),
(34, 1, 34, 'BFA', 'BF', 'Burkina Faso', 'Burkina Faso'),
(35, 1, 35, 'BDI', 'BI', 'Burundi', 'Burundi'),
(36, 1, 36, 'KHM', 'KH', 'Cambodia', 'Kambodscha'),
(37, 1, 37, 'CMR', 'CM', 'Cameroon', 'Kamerun'),
(38, 1, 38, 'CAN', 'CA', 'Canada', 'Kanada'),
(39, 1, 39, 'CPV', 'CV', 'Cape Verde', 'Kap Verde'),
(40, 1, 40, 'CYM', 'KY', 'Cayman Islands', 'Cayman-Inseln'),
(41, 1, 41, 'CAF', 'CF', 'Central African Republic', 'Zentralafrikanische Republik'),
(42, 1, 42, 'TCD', 'TD', 'Chad', 'Tschad'),
(43, 1, 43, 'CHL', 'CL', 'Chile', 'Chile'),
(44, 1, 44, 'CHN', 'CN', 'China', 'China'),
(45, 1, 45, 'CXR', 'CX', 'Christmas Island', 'Christmas Island'),
(46, 1, 46, 'CCK', 'CC', 'Cocos (Keeling) Islands', 'Kokosinseln (Keeling)'),
(47, 1, 47, 'COL', 'CO', 'Colombia', 'Kolumbien'),
(48, 1, 48, 'COM', 'KM', 'Comoros', 'Komoren'),
(49, 1, 49, 'COG', 'CG', 'Congo', 'Kongo, Republik'),
(50, 1, 50, 'COK', 'CK', 'Cook Islands', 'Cookinseln'),
(51, 1, 51, 'CRI', 'CR', 'Costa Rica', 'Costa Rica'),
(52, 1, 52, 'CIV', 'CI', 'Cote D''Ivoire', 'Elfenbeinküste'),
(53, 1, 53, 'HRV', 'HR', 'Croatia', 'Kroatien'),
(54, 1, 54, 'CUB', 'CU', 'Cuba', 'Kuba'),
(55, 1, 55, 'CYP', 'CY', 'Cyprus', 'Zypern'),
(56, 1, 56, 'CZE', 'CZ', 'Czech Republic', 'Tschechien'),
(57, 1, 57, 'DNK', 'DK', 'Denmark', 'Dänemark'),
(58, 1, 58, 'DJI', 'DJ', 'Djibouti', 'Dschibuti'),
(59, 1, 59, 'DMA', 'DM', 'Dominica', 'Dominica'),
(60, 1, 60, 'DOM', 'DO', 'Dominican Republic', 'Dominikanische Republik'),
(61, 1, 61, 'TMP', 'TL', 'East Timor', 'Osttimor'),
(62, 1, 62, 'ECU', 'EC', 'Ecuador', 'Ecuador'),
(63, 1, 63, 'EGY', 'EG', 'Egypt', 'Ägypten'),
(64, 1, 64, 'SLV', 'SV', 'El Salvador', 'El Salvador'),
(65, 1, 65, 'GNQ', 'GQ', 'Equatorial Guinea', 'Äquatorial-Guinea'),
(66, 1, 66, 'ERI', 'ER', 'Eritrea', 'Eritrea'),
(67, 1, 67, 'EST', 'EE', 'Estonia', 'Estland'),
(68, 1, 68, 'ETH', 'ET', 'Ethiopia', 'Äthiopien'),
(69, 1, 69, 'FLK', 'FK', 'Falkland Islands (Malvinas)', 'Falklandinseln'),
(70, 1, 70, 'FRO', 'FO', 'Faroe Islands', 'Färöer'),
(71, 1, 71, 'FJI', 'FJ', 'Fiji', 'Fidschi'),
(72, 1, 72, 'FIN', 'FI', 'Finland', 'Finnland'),
(73, 1, 73, 'FRA', 'FR', 'France', 'Frankreich'),
(74, 1, 74, 'FXX', 'FX', 'France Metropolitan', 'Frankreich, Metropolitan'),
(75, 1, 75, 'GUF', 'GF', 'French Guiana', 'Französisch-Guyana'),
(76, 1, 76, 'PYF', 'PF', 'French Polynesia', 'Franz. Polynesien'),
(77, 1, 77, 'ATF', 'TF', 'French Southern Territories', 'Französiche Süd- und Antarktisgebiete'),
(78, 1, 78, 'GAB', 'GA', 'Gabon', 'Gabun'),
(79, 1, 79, 'GMB', 'GM', 'Gambia', 'Gambia'),
(80, 1, 80, 'GEO', 'GE', 'Georgia', 'Georgien'),
(81, 1, 81, 'DEU', 'DE', 'Germany', 'Deutschland'),
(82, 1, 82, 'GHA', 'GH', 'Ghana', 'Ghana'),
(83, 1, 83, 'GIB', 'GI', 'Gibraltar', 'Gibraltar'),
(84, 1, 84, 'GRC', 'GR', 'Greece', 'Griechenland'),
(85, 1, 85, 'GRL', 'GL', 'Greenland', 'Grönland'),
(86, 1, 86, 'GRD', 'GD', 'Grenada', 'Grenada'),
(87, 1, 87, 'GLP', 'GP', 'Guadeloupe', 'Guadeloupe'),
(88, 1, 88, 'GUM', 'GU', 'Guam', 'Guam'),
(89, 1, 89, 'GTM', 'GT', 'Guatemala', 'Guatemala'),
(90, 1, 90, 'GIN', 'GN', 'Guinea', 'Guinea'),
(91, 1, 91, 'GNB', 'GW', 'Guinea-bissau', 'Guinea-Bissau'),
(92, 1, 92, 'GUY', 'GY', 'Guyana', 'Guyana'),
(93, 1, 93, 'HTI', 'HT', 'Haiti', 'Haiti'),
(94, 1, 94, 'HMD', 'HM', 'Heard and Mc Donald Islands', 'Heard und McDonaldinseln'),
(95, 1, 95, 'HND', 'HN', 'Honduras', 'Honduras'),
(96, 1, 96, 'HKG', 'HK', 'Hong Kong', 'Hong Kong'),
(97, 1, 97, 'HUN', 'HU', 'Hungary', 'Ungarn'),
(98, 1, 98, 'ISL', 'IS', 'Iceland', 'Island'),
(99, 1, 99, 'IND', 'IN', 'India', 'Indien'),
(100, 1, 100, 'IDN', 'ID', 'Indonesia', 'Indonesien'),
(101, 1, 101, 'IRN', 'IR', 'Iran (Islamic Republic of)', 'Iran'),
(102, 1, 102, 'IRQ', 'IQ', 'Iraq', 'Irak'),
(103, 1, 103, 'IRL', 'IE', 'Ireland', 'Irland'),
(104, 1, 104, 'ISR', 'IL', 'Israel', 'Israel'),
(105, 1, 105, 'ITA', 'IT', 'Italy', 'Italien'),
(106, 1, 106, 'JAM', 'JM', 'Jamaica', 'Jamaika'),
(107, 1, 107, 'JPN', 'JP', 'Japan', 'Japan'),
(108, 1, 108, 'JOR', 'JO', 'Jordan', 'Jordanien'),
(109, 1, 109, 'KAZ', 'KZ', 'Kazakhstan', 'Kasachstan'),
(110, 1, 110, 'KEN', 'KE', 'Kenya', 'Kenia'),
(111, 1, 111, 'KIR', 'KI', 'Kiribati', 'Kiribati'),
(112, 1, 112, 'PRK', 'KP', 'Korea Democratic People''s Republic of', 'Korea Demokratische Volksrepublik'),
(113, 1, 113, 'KOR', 'KR', 'Korea Republic of', 'Korea'),
(114, 1, 114, 'KWT', 'KW', 'Kuwait', 'Kuwait'),
(115, 1, 115, 'KGZ', 'KG', 'Kyrgyzstan', 'Kirgistan'),
(116, 1, 116, 'LAO', 'LA', 'Lao People''s Democratic Republic', 'Laos'),
(117, 1, 117, 'LVA', 'LV', 'Latvia', 'Lettland'),
(118, 1, 118, 'LBN', 'LB', 'Lebanon', 'Libanon'),
(119, 1, 119, 'LSO', 'LS', 'Lesotho', 'Lesotho'),
(120, 1, 120, 'LBR', 'LR', 'Liberia', 'Liberia'),
(121, 1, 121, 'LBY', 'LY', 'Libyan Arab Jamahiriya', 'Libyen'),
(122, 1, 122, 'LIE', 'LI', 'Liechtenstein', 'Liechtenstein'),
(123, 1, 123, 'LTU', 'LT', 'Lithuania', 'Litauen'),
(124, 1, 124, 'LUX', 'LU', 'Luxembourg', 'Luxemburg'),
(125, 1, 125, 'MAC', 'MO', 'Macau', 'Makao'),
(126, 1, 126, 'MKD', 'MK', 'Macedonia The Former Yugoslav Republic of', 'Mazedonien'),
(127, 1, 127, 'MDG', 'MG', 'Madagascar', 'Madagaskar'),
(128, 1, 128, 'MWI', 'MW', 'Malawi', 'Malawi'),
(129, 1, 129, 'MYS', 'MY', 'Malaysia', 'Malaysia'),
(130, 1, 130, 'MDV', 'MV', 'Maldives', 'Malediven'),
(131, 1, 131, 'MLI', 'ML', 'Mali', 'Mali'),
(132, 1, 132, 'MLT', 'MT', 'Malta', 'Malta'),
(133, 1, 133, 'MHL', 'MH', 'Marshall Islands', 'Marshallinseln'),
(134, 1, 134, 'MTQ', 'MQ', 'Martinique', 'Martinique'),
(135, 1, 135, 'MRT', 'MR', 'Mauritania', 'Mauretanien'),
(136, 1, 136, 'MUS', 'MU', 'Mauritius', 'Mauritius'),
(137, 1, 137, 'MYT', 'YT', 'Mayotte', 'Mayott'),
(138, 1, 138, 'MEX', 'MX', 'Mexico', 'Mexiko'),
(139, 1, 139, 'FSM', 'FM', 'Micronesia Federated States of', 'Mikronesien'),
(140, 1, 140, 'MDA', 'MD', 'Moldova Republic of', 'Moldawien'),
(141, 1, 141, 'MCO', 'MC', 'Monaco', 'Monaco'),
(142, 1, 142, 'MNG', 'MN', 'Mongolia', 'Mongolei'),
(143, 1, 143, 'MSR', 'MS', 'Montserrat', 'Montserrat'),
(144, 1, 144, 'MAR', 'MA', 'Morocco', 'Marokko'),
(145, 1, 145, 'MOZ', 'MZ', 'Mozambique', 'Mosambik'),
(146, 1, 146, 'MMR', 'MM', 'Myanmar', 'Myanmar'),
(147, 1, 147, 'NAM', 'NA', 'Namibia', 'Namibia'),
(148, 1, 148, 'NRU', 'NR', 'Nauru', 'Nauru'),
(149, 1, 149, 'NPL', 'NP', 'Nepal', 'Nepal'),
(150, 1, 150, 'NLD', 'NL', 'Netherlands', 'Niederlande'),
(151, 1, 151, 'ANT', 'AN', 'Netherlands Antilles', 'Niederländisch-Antillen'),
(152, 1, 152, 'NCL', 'NC', 'New Caledonia', 'Neukaledonien'),
(153, 1, 153, 'NZL', 'NZ', 'New Zealand', 'Neuseeland'),
(154, 1, 154, 'NIC', 'NI', 'Nicaragua', 'Nicaragua'),
(155, 1, 155, 'NER', 'NE', 'Niger', 'Niger'),
(156, 1, 156, 'NGA', 'NG', 'Nigeria', 'Nigeria'),
(157, 1, 157, 'NIU', 'NU', 'Niue', 'Niue'),
(158, 1, 158, 'NFK', 'NF', 'Norfolk Island', 'Norfolkinsel'),
(159, 1, 159, 'MNP', 'MP', 'Northern Mariana Islands', 'Nördliche Marianen'),
(160, 1, 160, 'NOR', 'NO', 'Norway', 'Norwegen'),
(161, 1, 161, 'OMN', 'OM', 'Oman', 'Oman'),
(162, 1, 162, 'PAK', 'PK', 'Pakistan', 'Pakistan'),
(163, 1, 163, 'PLW', 'PW', 'Palau', 'Palau'),
(164, 1, 164, 'PAN', 'PA', 'Panama', 'Panama'),
(165, 1, 165, 'PNG', 'PG', 'Papua New Guinea', 'Papua-Neuguinea'),
(166, 1, 166, 'PRY', 'PY', 'Paraguay', 'Paraguay'),
(167, 1, 167, 'PER', 'PE', 'Peru', 'Peru'),
(168, 1, 168, 'PHL', 'PH', 'Philippines', 'Philippinen'),
(169, 1, 169, 'PCN', 'PN', 'Pitcairn', 'Pitcairn'),
(170, 1, 170, 'POL', 'PL', 'Poland', 'Polen'),
(171, 1, 171, 'PRT', 'PT', 'Portugal', 'Portugal'),
(172, 1, 172, 'PRI', 'PR', 'Puerto Rico', 'Puerto Rico'),
(173, 1, 173, 'QAT', 'QA', 'Qatar', 'Katar'),
(174, 1, 174, 'REU', 'RE', 'Reunion', 'Reunion'),
(175, 1, 175, 'ROM', 'RO', 'Romania', 'Rumänien'),
(176, 1, 176, 'RUS', 'RU', 'Russian Federation', 'Russische Föderation'),
(177, 1, 177, 'RWA', 'RW', 'Rwanda', 'Ruanda'),
(178, 1, 178, 'KNA', 'KN', 'Saint Kitts and Nevis', 'St. Kitts und Nevis'),
(179, 1, 179, 'LCA', 'LC', 'Saint Lucia', 'St. Lucia'),
(180, 1, 180, 'VCT', 'VC', 'Saint Vincent and the Grenadines', 'St. Vincent und die Grenadinen'),
(181, 1, 181, 'WSM', 'WS', 'Samoa', 'Samoa'),
(182, 1, 182, 'SMR', 'SM', 'San Marino', 'San Marino'),
(183, 1, 183, 'STP', 'ST', 'Sao Tome and Principe', 'Sao Tomé und Príncipe'),
(184, 1, 184, 'SAU', 'SA', 'Saudi Arabia', 'Saudi-Arabien'),
(185, 1, 185, 'SEN', 'SN', 'Senegal', 'Senegal'),
(186, 1, 186, 'SYC', 'SC', 'Seychelles', 'Seychellen'),
(187, 1, 187, 'SLE', 'SL', 'Sierra Leone', 'Sierra Leone'),
(188, 1, 188, 'SGP', 'SG', 'Singapore', 'Singapur'),
(189, 1, 189, 'SVK', 'SK', 'Slovakia (Slovak Republic)', 'Slowakei'),
(190, 1, 190, 'SVN', 'SI', 'Slovenia', 'Slowenien'),
(191, 1, 191, 'SLB', 'SB', 'Solomon Islands', 'Salomonen'),
(192, 1, 192, 'SOM', 'SO', 'Somalia', 'Somalia'),
(193, 1, 193, 'ZAF', 'ZA', 'South Africa', 'Republik Südafrika'),
(194, 1, 194, 'SGS', 'GS', 'South Georgia and the South Sandwich Islands', 'Südgeorgien und die Südlichen Sandwichinseln'),
(195, 1, 195, 'ESP', 'ES', 'Spain', 'Spanien'),
(196, 1, 196, 'LKA', 'LK', 'Sri Lanka', 'Sri Lanka'),
(197, 1, 197, 'SHN', 'SH', 'St. Helena', 'St. Helena'),
(198, 1, 198, 'SPM', 'PM', 'St. Pierre and Miquelon', 'St. Pierre und Miquelon'),
(199, 1, 199, 'SDN', 'SD', 'Sudan', 'Sudan'),
(200, 1, 200, 'SUR', 'SR', 'Suriname', 'Suriname'),
(201, 1, 201, 'SJM', 'SJ', 'Svalbard and Jan Mayen Islands', 'Svalbard und Jan Mayen'),
(202, 1, 202, 'SWZ', 'SZ', 'Swaziland', 'Swasiland'),
(203, 1, 203, 'SWE', 'SE', 'Sweden', 'Schweden'),
(204, 1, 204, 'CHE', 'CH', 'Switzerland', 'Schweiz'),
(205, 1, 205, 'SYR', 'SY', 'Syrian Arab Republic', 'Syrien'),
(206, 1, 206, 'TWN', 'TW', 'Taiwan', 'Taiwan'),
(207, 1, 207, 'TJK', 'TJ', 'Tajikistan', 'Tadschikistan'),
(208, 1, 208, 'TZA', 'TZ', 'Tanzania United Republic of', 'Tansania'),
(209, 1, 209, 'THA', 'TH', 'Thailand', 'Thailand'),
(210, 1, 210, 'TGO', 'TG', 'Togo', 'Togo'),
(211, 1, 211, 'TKL', 'TK', 'Tokelau', 'Tokelau'),
(212, 1, 212, 'TON', 'TO', 'Tonga', 'Tonga'),
(213, 1, 213, 'TTO', 'TT', 'Trinidad and Tobago', 'Trinidad und Tobago'),
(214, 1, 214, 'TUN', 'TN', 'Tunisia', 'Tunesien'),
(215, 1, 215, 'TUR', 'TR', 'Turkey', 'Türkei'),
(216, 1, 216, 'TKM', 'TM', 'Turkmenistan', 'Turkmenistan'),
(217, 1, 217, 'TCA', 'TC', 'Turks and Caicos Islands', 'Turks- und Caicosinseln'),
(218, 1, 218, 'TUV', 'TV', 'Tuvalu', 'Tuvalu'),
(219, 1, 219, 'UGA', 'UG', 'Uganda', 'Uganda'),
(220, 1, 220, 'UKR', 'UA', 'Ukraine', 'Ukraine'),
(221, 1, 221, 'ARE', 'AE', 'United Arab Emirates', 'Vereinigte Arabische Emirate'),
(222, 1, 222, 'GBR', 'GB', 'United Kingdom', 'Vereinigtes Königreich'),
(223, 1, 223, 'USA', 'US', 'United States', 'USA'),
(224, 1, 224, 'UMI', 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands'),
(225, 1, 225, 'URY', 'UY', 'Uruguay', 'Uruguay'),
(226, 1, 226, 'UZB', 'UZ', 'Uzbekistan', 'Usbekistan'),
(227, 1, 227, 'VUT', 'VU', 'Vanuatu', 'Vanuatu'),
(228, 1, 228, 'VAT', 'VA', 'Vatican City State (Holy See)', 'Vatikanstadt'),
(229, 1, 229, 'VEN', 'VE', 'Venezuela', 'Venezuela'),
(230, 1, 230, 'VNM', 'VN', 'Viet Nam', 'Vietnam'),
(231, 1, 231, 'VGB', 'VG', 'Virgin Islands (British)', 'Britische Jungferninseln'),
(232, 1, 232, 'VIR', 'VI', 'Virgin Islands (U.S.)', 'Vereinigte Staaten von Amerika'),
(233, 1, 233, 'WLF', 'WF', 'Wallis and Futuna Islands', 'Wallis und Futuna'),
(234, 1, 234, 'ESH', 'EH', 'Western Sahara', 'Westsahara'),
(235, 1, 235, 'YEM', 'YE', 'Yemen', 'Jemen'),
(236, 1, 236, 'YUG', 'YU', 'Yugoslavia', 'Yugoslavia'),
(237, 1, 237, 'ZAR', 'ZR', 'Zaire', 'Zaire'),
(238, 1, 238, 'ZMB', 'ZM', 'Zambia', 'Sambia'),
(239, 1, 239, 'ZWE', 'ZW', 'Zimbabwe', 'Simbabwe');
Установка компонента: Файл ошибок SQL Ошибка базы данных с номером 1062
Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `sl8xr_jshopping_countries` (`country_id`, `country_publish`, `ordering`, `country_code`, `country_code_2`, `name_en-GB`, `name_de-DE`) VALUES (1, 1, 1, 'AFG', 'AF', 'Afghanistan', 'Afghanistan'), (2, 1, 2, 'ALB', 'AL', 'Albania', 'Albanien'), (3, 1, 3, 'DZA', 'DZ', 'Algeria', 'Algerien'), (4, 1, 4, 'ASM', 'AS', 'American Samoa', 'Amerikanisch-Samoa'), (5, 1, 5, 'AND', 'AD', 'Andorra', 'Andorra'), (6, 1, 6, 'AGO', 'AO', 'Angola', 'Angola'), (7, 1, 7, 'AIA', 'AI', 'Anguilla', 'Anguilla'), (8, 1, 8, 'ATA', 'AQ', 'Antarctica', 'Antarktis'), (9, 1, 9, 'ATG', 'AG', 'Antigua and Barbuda', 'Antigua und Barbuda'), (10, 1, 10, 'ARG', 'AR', 'Argentina', 'Argentinien'), (11, 1, 11, 'ARM', 'AM', 'Armenia', 'Armenien'), (12, 1, 12, 'ABW', 'AW', 'Aruba', 'Aruba'), (13, 1, 13, 'AUS', 'AU', 'Australia', 'Australien'), (14, 1, 14, 'AUT', 'AT', 'Austria', 'Österreich'), (15, 1, 15, 'AZE', 'AZ', 'Azerbaijan', 'Aserbaidschan'), (16, 1, 16, 'BHS', 'BS', 'Bahamas', 'Bahamas'), (17, 1, 17, 'BHR', 'BH', 'Bahrain', 'Bahrain'), (18, 1, 18, 'BGD', 'BD', 'Bangladesh', 'Bangladesch'), (19, 1, 19, 'BRB', 'BB', 'Barbados', 'Barbados'), (20, 1, 20, 'BLR', 'BY', 'Belarus', 'Weissrussland'), (21, 1, 21, 'BEL', 'BE', 'Belgium', 'Belgien'), (22, 1, 22, 'BLZ', 'BZ', 'Belize', 'Belize'), (23, 1, 23, 'BEN', 'BJ', 'Benin', 'Benin'), (24, 1, 24, 'BMU', 'BM', 'Bermuda', 'Bermuda'), (25, 1, 25, 'BTN', 'BT', 'Bhutan', 'Bhutan'), (26, 1, 26, 'BOL', 'BO', 'Bolivia', 'Bolivien'), (27, 1, 27, 'BIH', 'BA', 'Bosnia and Herzegowina', 'Bosnien und Herzegowina'), (28, 1, 28, 'BWA', 'BW', 'Botswana', 'Botsuana'), (29, 1, 29, 'BVT', 'BV', 'Bouvet Island', 'Bouvetinsel'), (30, 1, 30, 'BRA', 'BR', 'Brazil', 'Brasilien'), (31, 1, 31, 'IOT', 'IO', 'British Indian Ocean Territory', 'Britisches Territorium im Indischen Ozean'), (32, 1, 32, 'BRN', 'BN', 'Brunei Darussalam', 'Brunei'), (33, 1, 33, 'BGR', 'BG', 'Bulgaria', 'Bulgarien'), (34, 1, 34, 'BFA', 'BF', 'Burkina Faso', 'Burkina Faso'), (35, 1, 35, 'BDI', 'BI', 'Burundi', 'Burundi'), (36, 1, 36, 'KHM', 'KH', 'Cambodia', 'Kambodscha'), (37, 1, 37, 'CMR', 'CM', 'Cameroon', 'Kamerun'), (38, 1, 38, 'CAN', 'CA', 'Canada', 'Kanada'), (39, 1, 39, 'CPV', 'CV', 'Cape Verde', 'Kap Verde'), (40, 1, 40, 'CYM', 'KY', 'Cayman Islands', 'Cayman-Inseln'), (41, 1, 41, 'CAF', 'CF', 'Central African Republic', 'Zentralafrikanische Republik'), (42, 1, 42, 'TCD', 'TD', 'Chad', 'Tschad'), (43, 1, 43, 'CHL', 'CL', 'Chile', 'Chile'), (44, 1, 44, 'CHN', 'CN', 'China', 'China'), (45, 1, 45, 'CXR', 'CX', 'Christmas Island', 'Christmas Island'), (46, 1, 46, 'CCK', 'CC', 'Cocos (Keeling) Islands', 'Kokosinseln (Keeling)'), (47, 1, 47, 'COL', 'CO', 'Colombia', 'Kolumbien'), (48, 1, 48, 'COM', 'KM', 'Comoros', 'Komoren'), (49, 1, 49, 'COG', 'CG', 'Congo', 'Kongo, Republik'), (50, 1, 50, 'COK', 'CK', 'Cook Islands', 'Cookinseln'), (51, 1, 51, 'CRI', 'CR', 'Costa Rica', 'Costa Rica'), (52, 1, 52, 'CIV', 'CI', 'Cote D''Ivoire', 'Elfenbeinküste'), (53, 1, 53, 'HRV', 'HR', 'Croatia', 'Kroatien'), (54, 1, 54, 'CUB', 'CU', 'Cuba', 'Kuba'), (55, 1, 55, 'CYP', 'CY', 'Cyprus', 'Zypern'), (56, 1, 56, 'CZE', 'CZ', 'Czech Republic', 'Tschechien'), (57, 1, 57, 'DNK', 'DK', 'Denmark', 'Dänemark'), (58, 1, 58, 'DJI', 'DJ', 'Djibouti', 'Dschibuti'), (59, 1, 59, 'DMA', 'DM', 'Dominica', 'Dominica'), (60, 1, 60, 'DOM', 'DO', 'Dominican Republic', 'Dominikanische Republik'), (61, 1, 61, 'TMP', 'TL', 'East Timor', 'Osttimor'), (62, 1, 62, 'ECU', 'EC', 'Ecuador', 'Ecuador'), (63, 1, 63, 'EGY', 'EG', 'Egypt', 'Ägypten'), (64, 1, 64, 'SLV', 'SV', 'El Salvador', 'El Salvador'), (65, 1, 65, 'GNQ', 'GQ', 'Equatorial Guinea', 'Äquatorial-Guinea'), (66, 1, 66, 'ERI', 'ER', 'Eritrea', 'Eritrea'), (67, 1, 67, 'EST', 'EE', 'Estonia', 'Estland'), (68, 1, 68, 'ETH', 'ET', 'Ethiopia', 'Äthiopien'), (69, 1, 69, 'FLK', 'FK', 'Falkland Islands (Malvinas)', 'Falklandinseln'), (70, 1, 70, 'FRO', 'FO', 'Faroe Islands', 'Färöer'), (71, 1, 71, 'FJI', 'FJ', 'Fiji', 'Fidschi'), (72, 1, 72, 'FIN', 'FI', 'Finland', 'Finnland'), (73, 1, 73, 'FRA', 'FR', 'France', 'Frankreich'), (74, 1, 74, 'FXX', 'FX', 'France Metropolitan', 'Frankreich, Metropolitan'), (75, 1, 75, 'GUF', 'GF', 'French Guiana', 'Französisch-Guyana'), (76, 1, 76, 'PYF', 'PF', 'French Polynesia', 'Franz. Polynesien'), (77, 1, 77, 'ATF', 'TF', 'French Southern Territories', 'Französiche Süd- und Antarktisgebiete'), (78, 1, 78, 'GAB', 'GA', 'Gabon', 'Gabun'), (79, 1, 79, 'GMB', 'GM', 'Gambia', 'Gambia'), (80, 1, 80, 'GEO', 'GE', 'Georgia', 'Georgien'), (81, 1, 81, 'DEU', 'DE', 'Germany', 'Deutschland'), (82, 1, 82, 'GHA', 'GH', 'Ghana', 'Ghana'), (83, 1, 83, 'GIB', 'GI', 'Gibraltar', 'Gibraltar'), (84, 1, 84, 'GRC', 'GR', 'Greece', 'Griechenland'), (85, 1, 85, 'GRL', 'GL', 'Greenland', 'Grönland'), (86, 1, 86, 'GRD', 'GD', 'Grenada', 'Grenada'), (87, 1, 87, 'GLP', 'GP', 'Guadeloupe', 'Guadeloupe'), (88, 1, 88, 'GUM', 'GU', 'Guam', 'Guam'), (89, 1, 89, 'GTM', 'GT', 'Guatemala', 'Guatemala'), (90, 1, 90, 'GIN', 'GN', 'Guinea', 'Guinea'), (91, 1, 91, 'GNB', 'GW', 'Guinea-bissau', 'Guinea-Bissau'), (92, 1, 92, 'GUY', 'GY', 'Guyana', 'Guyana'), (93, 1, 93, 'HTI', 'HT', 'Haiti', 'Haiti'), (94, 1, 94, 'HMD', 'HM', 'Heard and Mc Donald Islands', 'Heard und McDonaldinseln'), (95, 1, 95, 'HND', 'HN', 'Honduras', 'Honduras'), (96, 1, 96, 'HKG', 'HK', 'Hong Kong', 'Hong Kong'), (97, 1, 97, 'HUN', 'HU', 'Hungary', 'Ungarn'), (98, 1, 98, 'ISL', 'IS', 'Iceland', 'Island'), (99, 1, 99, 'IND', 'IN', 'India', 'Indien'), (100, 1, 100, 'IDN', 'ID', 'Indonesia', 'Indonesien'), (101, 1, 101, 'IRN', 'IR', 'Iran (Islamic Republic of)', 'Iran'), (102, 1, 102, 'IRQ', 'IQ', 'Iraq', 'Irak'), (103, 1, 103, 'IRL', 'IE', 'Ireland', 'Irland'), (104, 1, 104, 'ISR', 'IL', 'Israel', 'Israel'), (105, 1, 105, 'ITA', 'IT', 'Italy', 'Italien'), (106, 1, 106, 'JAM', 'JM', 'Jamaica', 'Jamaika'), (107, 1, 107, 'JPN', 'JP', 'Japan', 'Japan'), (108, 1, 108, 'JOR', 'JO', 'Jordan', 'Jordanien'), (109, 1, 109, 'KAZ', 'KZ', 'Kazakhstan', 'Kasachstan'), (110, 1, 110, 'KEN', 'KE', 'Kenya', 'Kenia'), (111, 1, 111, 'KIR', 'KI', 'Kiribati', 'Kiribati'), (112, 1, 112, 'PRK', 'KP', 'Korea Democratic People''s Republic of', 'Korea Demokratische Volksrepublik'), (113, 1, 113, 'KOR', 'KR', 'Korea Republic of', 'Korea'), (114, 1, 114, 'KWT', 'KW', 'Kuwait', 'Kuwait'), (115, 1, 115, 'KGZ', 'KG', 'Kyrgyzstan', 'Kirgistan'), (116, 1, 116, 'LAO', 'LA', 'Lao People''s Democratic Republic', 'Laos'), (117, 1, 117, 'LVA', 'LV', 'Latvia', 'Lettland'), (118, 1, 118, 'LBN', 'LB', 'Lebanon', 'Libanon'), (119, 1, 119, 'LSO', 'LS', 'Lesotho', 'Lesotho'), (120, 1, 120, 'LBR', 'LR', 'Liberia', 'Liberia'), (121, 1, 121, 'LBY', 'LY', 'Libyan Arab Jamahiriya', 'Libyen'), (122, 1, 122, 'LIE', 'LI', 'Liechtenstein', 'Liechtenstein'), (123, 1, 123, 'LTU', 'LT', 'Lithuania', 'Litauen'), (124, 1, 124, 'LUX', 'LU', 'Luxembourg', 'Luxemburg'), (125, 1, 125, 'MAC', 'MO', 'Macau', 'Makao'), (126, 1, 126, 'MKD', 'MK', 'Macedonia The Former Yugoslav Republic of', 'Mazedonien'), (127, 1, 127, 'MDG', 'MG', 'Madagascar', 'Madagaskar'), (128, 1, 128, 'MWI', 'MW', 'Malawi', 'Malawi'), (129, 1, 129, 'MYS', 'MY', 'Malaysia', 'Malaysia'), (130, 1, 130, 'MDV', 'MV', 'Maldives', 'Malediven'), (131, 1, 131, 'MLI', 'ML', 'Mali', 'Mali'), (132, 1, 132, 'MLT', 'MT', 'Malta', 'Malta'), (133, 1, 133, 'MHL', 'MH', 'Marshall Islands', 'Marshallinseln'), (134, 1, 134, 'MTQ', 'MQ', 'Martinique', 'Martinique'), (135, 1, 135, 'MRT', 'MR', 'Mauritania', 'Mauretanien'), (136, 1, 136, 'MUS', 'MU', 'Mauritius', 'Mauritius'), (137, 1, 137, 'MYT', 'YT', 'Mayotte', 'Mayott'), (138, 1, 138, 'MEX', 'MX', 'Mexico', 'Mexiko'), (139, 1, 139, 'FSM', 'FM', 'Micronesia Federated States of', 'Mikronesien'), (140, 1, 140, 'MDA', 'MD', 'Moldova Republic of', 'Moldawien'), (141, 1, 141, 'MCO', 'MC', 'Monaco', 'Monaco'), (142, 1, 142, 'MNG', 'MN', 'Mongolia', 'Mongolei'), (143, 1, 143, 'MSR', 'MS', 'Montserrat', 'Montserrat'), (144, 1, 144, 'MAR', 'MA', 'Morocco', 'Marokko'), (145, 1, 145, 'MOZ', 'MZ', 'Mozambique', 'Mosambik'), (146, 1, 146, 'MMR', 'MM', 'Myanmar', 'Myanmar'), (147, 1, 147, 'NAM', 'NA', 'Namibia', 'Namibia'), (148, 1, 148, 'NRU', 'NR', 'Nauru', 'Nauru'), (149, 1, 149, 'NPL', 'NP', 'Nepal', 'Nepal'), (150, 1, 150, 'NLD', 'NL', 'Netherlands', 'Niederlande'), (151, 1, 151, 'ANT', 'AN', 'Netherlands Antilles', 'Niederländisch-Antillen'), (152, 1, 152, 'NCL', 'NC', 'New Caledonia', 'Neukaledonien'), (153, 1, 153, 'NZL', 'NZ', 'New Zealand', 'Neuseeland'), (154, 1, 154, 'NIC', 'NI', 'Nicaragua', 'Nicaragua'), (155, 1, 155, 'NER', 'NE', 'Niger', 'Niger'), (156, 1, 156, 'NGA', 'NG', 'Nigeria', 'Nigeria'), (157, 1, 157, 'NIU', 'NU', 'Niue', 'Niue'), (158, 1, 158, 'NFK', 'NF', 'Norfolk Island', 'Norfolkinsel'), (159, 1, 159, 'MNP', 'MP', 'Northern Mariana Islands', 'Nördliche Marianen'), (160, 1, 160, 'NOR', 'NO', 'Norway', 'Norwegen'), (161, 1, 161, 'OMN', 'OM', 'Oman', 'Oman'), (162, 1, 162, 'PAK', 'PK', 'Pakistan', 'Pakistan'), (163, 1, 163, 'PLW', 'PW', 'Palau', 'Palau'), (164, 1, 164, 'PAN', 'PA', 'Panama', 'Panama'), (165, 1, 165, 'PNG', 'PG', 'Papua New Guinea', 'Papua-Neuguinea'), (166, 1, 166, 'PRY', 'PY', 'Paraguay', 'Paraguay'), (167, 1, 167, 'PER', 'PE', 'Peru', 'Peru'), (168, 1, 168, 'PHL', 'PH', 'Philippines', 'Philippinen'), (169, 1, 169, 'PCN', 'PN', 'Pitcairn', 'Pitcairn'), (170, 1, 170, 'POL', 'PL', 'Poland', 'Polen'), (171, 1, 171, 'PRT', 'PT', 'Portugal', 'Portugal'), (172, 1, 172, 'PRI', 'PR', 'Puerto Rico', 'Puerto Rico'), (173, 1, 173, 'QAT', 'QA', 'Qatar', 'Katar'), (174, 1, 174, 'REU', 'RE', 'Reunion', 'Reunion'), (175, 1, 175, 'ROM', 'RO', 'Romania', 'Rumänien'), (176, 1, 176, 'RUS',