Any questions about Documents Sellers, post it here .

List of countries is messed up

  • Best Best
  • Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 10 months ago #3144 by Best Best
List of countries is messed up was created by Best Best
The list of countries has some countries repeated in it and even one called "R" as well as a blank one. I was notified about this by a customer complaining that Romania was not in the list... It appears it is this way in the t0r4j_dms_countries table. I tried dropping the table and then reinstalling an the same results.. so the sql for that table needs to be updated and fixed.

Please Log in or Create an account to join the conversation.

  • Best Best
  • Topic Author
  • Offline
  • New Member
  • New Member
More
13 years 10 months ago #3145 by Best Best
Replied by Best Best on topic Re:List of countries is messed up
I found like 288 rows in the country table.. here is how i fixed it.
Code:
delete from `t0r4j_dms_countries` INSERT INTO `t0r4j_dms_countries` VALUES (1, 'United States'); INSERT INTO `t0r4j_dms_countries` VALUES (2, 'Canada'); INSERT INTO `t0r4j_dms_countries` VALUES (3, 'Mexico'); INSERT INTO `t0r4j_dms_countries` VALUES (4, 'Afghanistan'); INSERT INTO `t0r4j_dms_countries` VALUES (5, 'Albania'); INSERT INTO `t0r4j_dms_countries` VALUES (6, 'Algeria'); INSERT INTO `t0r4j_dms_countries` VALUES (7, 'Andorra'); INSERT INTO `t0r4j_dms_countries` VALUES (8, 'Angola'); INSERT INTO `t0r4j_dms_countries` VALUES (9, 'Anguilla'); INSERT INTO `t0r4j_dms_countries` VALUES (10, 'Antarctica'); INSERT INTO `t0r4j_dms_countries` VALUES (11, 'Antigua and Barbuda'); INSERT INTO `t0r4j_dms_countries` VALUES (12, 'Argentina'); INSERT INTO `t0r4j_dms_countries` VALUES (13, 'Armenia'); INSERT INTO `t0r4j_dms_countries` VALUES (14, 'Aruba'); INSERT INTO `t0r4j_dms_countries` VALUES (15, 'Ascension Island'); INSERT INTO `t0r4j_dms_countries` VALUES (16, 'Australia'); INSERT INTO `t0r4j_dms_countries` VALUES (17, 'Austria'); INSERT INTO `t0r4j_dms_countries` VALUES (18, 'Azerbaijan'); INSERT INTO `t0r4j_dms_countries` VALUES (19, 'Bahamas'); INSERT INTO `t0r4j_dms_countries` VALUES (20, 'Bahrain'); INSERT INTO `t0r4j_dms_countries` VALUES (21, 'Bangladesh'); INSERT INTO `t0r4j_dms_countries` VALUES (22, 'Barbados'); INSERT INTO `t0r4j_dms_countries` VALUES (23, 'Belarus'); INSERT INTO `t0r4j_dms_countries` VALUES (24, 'Belgium'); INSERT INTO `t0r4j_dms_countries` VALUES (25, 'Belize'); INSERT INTO `t0r4j_dms_countries` VALUES (26, 'Benin'); INSERT INTO `t0r4j_dms_countries` VALUES (27, 'Bermuda'); INSERT INTO `t0r4j_dms_countries` VALUES (28, 'Bhutan'); INSERT INTO `t0r4j_dms_countries` VALUES (29, 'Bolivia'); INSERT INTO `t0r4j_dms_countries` VALUES (30, 'Bophuthatswana'); INSERT INTO `t0r4j_dms_countries` VALUES (31, 'Bosnia-Herzegovina'); INSERT INTO `t0r4j_dms_countries` VALUES (32, 'Botswana'); INSERT INTO `t0r4j_dms_countries` VALUES (33, 'Bouvet Island'); INSERT INTO `t0r4j_dms_countries` VALUES (34, 'Brazil'); INSERT INTO `t0r4j_dms_countries` VALUES (35, 'British Indian Ocean'); INSERT INTO `t0r4j_dms_countries` VALUES (36, 'British Virgin Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (37, 'Brunei Darussalam'); INSERT INTO `t0r4j_dms_countries` VALUES (38, 'Bulgaria'); INSERT INTO `t0r4j_dms_countries` VALUES (39, 'Burkina Faso'); INSERT INTO `t0r4j_dms_countries` VALUES (40, 'Burundi'); INSERT INTO `t0r4j_dms_countries` VALUES (41, 'Cambodia'); INSERT INTO `t0r4j_dms_countries` VALUES (42, 'Cameroon'); INSERT INTO `t0r4j_dms_countries` VALUES (43, 'Chad'); INSERT INTO `t0r4j_dms_countries` VALUES (44, 'Cape Verde Island'); INSERT INTO `t0r4j_dms_countries` VALUES (45, 'Cayman Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (46, 'Central Africa'); INSERT INTO `t0r4j_dms_countries` VALUES (47, 'Chad'); INSERT INTO `t0r4j_dms_countries` VALUES (48, 'Channel Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (49, 'Chile'); INSERT INTO `t0r4j_dms_countries` VALUES (50, 'China, Peoples Republic'); INSERT INTO `t0r4j_dms_countries` VALUES (51, 'Christmas Island'); INSERT INTO `t0r4j_dms_countries` VALUES (52, 'Cocos (Keeling) Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (53, 'Colombia'); INSERT INTO `t0r4j_dms_countries` VALUES (54, 'Comoros Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (55, 'Congo'); INSERT INTO `t0r4j_dms_countries` VALUES (56, 'Cook Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (57, 'Costa Rica'); INSERT INTO `t0r4j_dms_countries` VALUES (58, 'Croatia'); INSERT INTO `t0r4j_dms_countries` VALUES (59, 'Cuba'); INSERT INTO `t0r4j_dms_countries` VALUES (60, 'Cyprus'); INSERT INTO `t0r4j_dms_countries` VALUES (61, 'Czech Republic'); INSERT INTO `t0r4j_dms_countries` VALUES (62, 'Denmark'); INSERT INTO `t0r4j_dms_countries` VALUES (63, 'Djibouti'); INSERT INTO `t0r4j_dms_countries` VALUES (64, 'Dominica'); INSERT INTO `t0r4j_dms_countries` VALUES (65, 'Dominican Republic'); INSERT INTO `t0r4j_dms_countries` VALUES (66, 'Easter Island'); INSERT INTO `t0r4j_dms_countries` VALUES (67, 'Ecuador'); INSERT INTO `t0r4j_dms_countries` VALUES (68, 'Egypt'); INSERT INTO `t0r4j_dms_countries` VALUES (69, 'El Salvador'); INSERT INTO `t0r4j_dms_countries` VALUES (70, 'England'); INSERT INTO `t0r4j_dms_countries` VALUES (71, 'Equatorial Guinea'); INSERT INTO `t0r4j_dms_countries` VALUES (72, 'Estonia'); INSERT INTO `t0r4j_dms_countries` VALUES (73, 'Ethiopia'); INSERT INTO `t0r4j_dms_countries` VALUES (74, 'Falkland Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (75, 'Faeroe Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (76, 'Fiji'); INSERT INTO `t0r4j_dms_countries` VALUES (77, 'Finland'); INSERT INTO `t0r4j_dms_countries` VALUES (78, 'France'); INSERT INTO `t0r4j_dms_countries` VALUES (79, 'French Guyana'); INSERT INTO `t0r4j_dms_countries` VALUES (80, 'French Polynesia'); INSERT INTO `t0r4j_dms_countries` VALUES (81, 'Gabon'); INSERT INTO `t0r4j_dms_countries` VALUES (82, 'Gambia'); INSERT INTO `t0r4j_dms_countries` VALUES (83, 'Georgia Republic'); INSERT INTO `t0r4j_dms_countries` VALUES (84, 'Germany'); INSERT INTO `t0r4j_dms_countries` VALUES (85, 'Gibraltar'); INSERT INTO `t0r4j_dms_countries` VALUES (86, 'Greece'); INSERT INTO `t0r4j_dms_countries` VALUES (87, 'Greenland'); INSERT INTO `t0r4j_dms_countries` VALUES (88, 'Grenada'); INSERT INTO `t0r4j_dms_countries` VALUES (89, 'Guadeloupe (French)'); INSERT INTO `t0r4j_dms_countries` VALUES (90, 'Guatemala'); INSERT INTO `t0r4j_dms_countries` VALUES (91, 'Guernsey Island'); INSERT INTO `t0r4j_dms_countries` VALUES (92, 'Guinea Bissau'); INSERT INTO `t0r4j_dms_countries` VALUES (93, 'Guinea'); INSERT INTO `t0r4j_dms_countries` VALUES (94, 'Guyana'); INSERT INTO `t0r4j_dms_countries` VALUES (95, 'Haiti'); INSERT INTO `t0r4j_dms_countries` VALUES (96, 'Heard and McDonald Isls'); INSERT INTO `t0r4j_dms_countries` VALUES (97, 'Honduras'); INSERT INTO `t0r4j_dms_countries` VALUES (98, 'Hong Kong'); INSERT INTO `t0r4j_dms_countries` VALUES (99, 'Hungary'); INSERT INTO `t0r4j_dms_countries` VALUES (100, 'Iceland'); INSERT INTO `t0r4j_dms_countries` VALUES (101, 'India'); INSERT INTO `t0r4j_dms_countries` VALUES (102, 'Iran'); INSERT INTO `t0r4j_dms_countries` VALUES (103, 'Iraq'); INSERT INTO `t0r4j_dms_countries` VALUES (104, 'Ireland'); INSERT INTO `t0r4j_dms_countries` VALUES (105, 'Isle of Man'); INSERT INTO `t0r4j_dms_countries` VALUES (106, 'Israel'); INSERT INTO `t0r4j_dms_countries` VALUES (107, 'Italy'); INSERT INTO `t0r4j_dms_countries` VALUES (108, 'Ivory Coast'); INSERT INTO `t0r4j_dms_countries` VALUES (109, 'Jamaica'); INSERT INTO `t0r4j_dms_countries` VALUES (110, 'Japan'); INSERT INTO `t0r4j_dms_countries` VALUES (111, 'Jersey Island'); INSERT INTO `t0r4j_dms_countries` VALUES (112, 'Jordan'); INSERT INTO `t0r4j_dms_countries` VALUES (113, 'Kazakhstan'); INSERT INTO `t0r4j_dms_countries` VALUES (114, 'Kenya'); INSERT INTO `t0r4j_dms_countries` VALUES (115, 'Kiribati'); INSERT INTO `t0r4j_dms_countries` VALUES (116, 'Kuwait'); INSERT INTO `t0r4j_dms_countries` VALUES (117, 'Laos'); INSERT INTO `t0r4j_dms_countries` VALUES (118, 'Latvia'); INSERT INTO `t0r4j_dms_countries` VALUES (119, 'Lebanon'); INSERT INTO `t0r4j_dms_countries` VALUES (120, 'Lesotho'); INSERT INTO `t0r4j_dms_countries` VALUES (121, 'Liberia'); INSERT INTO `t0r4j_dms_countries` VALUES (122, 'Libya'); INSERT INTO `t0r4j_dms_countries` VALUES (123, 'Liechtenstein'); INSERT INTO `t0r4j_dms_countries` VALUES (124, 'Lithuania'); INSERT INTO `t0r4j_dms_countries` VALUES (125, 'Luxembourg'); INSERT INTO `t0r4j_dms_countries` VALUES (126, 'Macao'); INSERT INTO `t0r4j_dms_countries` VALUES (127, 'Macedonia'); INSERT INTO `t0r4j_dms_countries` VALUES (128, 'Madagascar'); INSERT INTO `t0r4j_dms_countries` VALUES (129, 'Malawi'); INSERT INTO `t0r4j_dms_countries` VALUES (130, 'Malaysia'); INSERT INTO `t0r4j_dms_countries` VALUES (131, 'Maldives'); INSERT INTO `t0r4j_dms_countries` VALUES (132, 'Mali'); INSERT INTO `t0r4j_dms_countries` VALUES (133, 'Malta'); INSERT INTO `t0r4j_dms_countries` VALUES (134, 'Martinique (French)'); INSERT INTO `t0r4j_dms_countries` VALUES (135, 'Mauritania'); INSERT INTO `t0r4j_dms_countries` VALUES (136, 'Mauritius'); INSERT INTO `t0r4j_dms_countries` VALUES (137, 'Mayotte'); INSERT INTO `t0r4j_dms_countries` VALUES (138, 'Mauritius'); INSERT INTO `t0r4j_dms_countries` VALUES (139, 'Micronesia'); INSERT INTO `t0r4j_dms_countries` VALUES (140, 'Moldavia'); INSERT INTO `t0r4j_dms_countries` VALUES (141, 'Monaco'); INSERT INTO `t0r4j_dms_countries` VALUES (142, 'Mongolia'); INSERT INTO `t0r4j_dms_countries` VALUES (143, 'Montenegro'); INSERT INTO `t0r4j_dms_countries` VALUES (144, 'Montserrat'); INSERT INTO `t0r4j_dms_countries` VALUES (145, 'Morocco'); INSERT INTO `t0r4j_dms_countries` VALUES (146, 'Mozambique'); INSERT INTO `t0r4j_dms_countries` VALUES (147, 'Myanmar'); INSERT INTO `t0r4j_dms_countries` VALUES (148, 'Namibia'); INSERT INTO `t0r4j_dms_countries` VALUES (149, 'Nauru'); INSERT INTO `t0r4j_dms_countries` VALUES (150, 'Nepal'); INSERT INTO `t0r4j_dms_countries` VALUES (151, 'Netherlands Antilles'); INSERT INTO `t0r4j_dms_countries` VALUES (152, 'Netherlands'); INSERT INTO `t0r4j_dms_countries` VALUES (153, 'New Caledonia (French)'); INSERT INTO `t0r4j_dms_countries` VALUES (154, 'New Zealand'); INSERT INTO `t0r4j_dms_countries` VALUES (155, 'Nicaragua'); INSERT INTO `t0r4j_dms_countries` VALUES (156, 'Niger'); INSERT INTO `t0r4j_dms_countries` VALUES (157, 'Niue'); INSERT INTO `t0r4j_dms_countries` VALUES (158, 'Norfolk Island'); INSERT INTO `t0r4j_dms_countries` VALUES (159, 'North Korea'); INSERT INTO `t0r4j_dms_countries` VALUES (160, 'Northern Ireland'); INSERT INTO `t0r4j_dms_countries` VALUES (161, 'Norway'); INSERT INTO `t0r4j_dms_countries` VALUES (162, 'Oman'); INSERT INTO `t0r4j_dms_countries` VALUES (163, 'Pakistan'); INSERT INTO `t0r4j_dms_countries` VALUES (164, 'Panama'); INSERT INTO `t0r4j_dms_countries` VALUES (165, 'Papua New Guinea'); INSERT INTO `t0r4j_dms_countries` VALUES (166, 'Paraguay'); INSERT INTO `t0r4j_dms_countries` VALUES (167, 'Peru'); INSERT INTO `t0r4j_dms_countries` VALUES (168, 'Philippines'); INSERT INTO `t0r4j_dms_countries` VALUES (169, 'Pitcairn Island'); INSERT INTO `t0r4j_dms_countries` VALUES (170, 'Poland'); INSERT INTO `t0r4j_dms_countries` VALUES (171, 'Polynesia (French)'); INSERT INTO `t0r4j_dms_countries` VALUES (172, 'Portugal'); INSERT INTO `t0r4j_dms_countries` VALUES (173, 'Qatar'); INSERT INTO `t0r4j_dms_countries` VALUES (174, 'Reunion Island'); INSERT INTO `t0r4j_dms_countries` VALUES (175, 'Romania'); INSERT INTO `t0r4j_dms_countries` VALUES (176, 'Russia'); INSERT INTO `t0r4j_dms_countries` VALUES (177, 'Rwanda'); INSERT INTO `t0r4j_dms_countries` VALUES (178, 'S.Georgia Sandwich Isls'); INSERT INTO `t0r4j_dms_countries` VALUES (179, 'Sao Tome, Principe'); INSERT INTO `t0r4j_dms_countries` VALUES (180, 'San Marino'); INSERT INTO `t0r4j_dms_countries` VALUES (181, 'Saudi Arabia'); INSERT INTO `t0r4j_dms_countries` VALUES (182, 'Scotland'); INSERT INTO `t0r4j_dms_countries` VALUES (183, 'Senegal'); INSERT INTO `t0r4j_dms_countries` VALUES (184, 'Serbia'); INSERT INTO `t0r4j_dms_countries` VALUES (185, 'Seychelles'); INSERT INTO `t0r4j_dms_countries` VALUES (186, 'Shetland'); INSERT INTO `t0r4j_dms_countries` VALUES (187, 'Sierra Leone'); INSERT INTO `t0r4j_dms_countries` VALUES (188, 'Singapore'); INSERT INTO `t0r4j_dms_countries` VALUES (189, 'Slovak Republic'); INSERT INTO `t0r4j_dms_countries` VALUES (190, 'Slovenia'); INSERT INTO `t0r4j_dms_countries` VALUES (191, 'Solomon Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (192, 'Somalia'); INSERT INTO `t0r4j_dms_countries` VALUES (193, 'South Africa'); INSERT INTO `t0r4j_dms_countries` VALUES (194, 'South Korea'); INSERT INTO `t0r4j_dms_countries` VALUES (195, 'Spain'); INSERT INTO `t0r4j_dms_countries` VALUES (196, 'Sri Lanka'); INSERT INTO `t0r4j_dms_countries` VALUES (197, 'St. Helena'); INSERT INTO `t0r4j_dms_countries` VALUES (198, 'St. Lucia'); INSERT INTO `t0r4j_dms_countries` VALUES (199, 'St. Pierre Miquelon'); INSERT INTO `t0r4j_dms_countries` VALUES (200, 'St. Martins'); INSERT INTO `t0r4j_dms_countries` VALUES (201, 'St. Kitts Nevis Anguilla'); INSERT INTO `t0r4j_dms_countries` VALUES (202, 'St. Vincent Grenadines'); INSERT INTO `t0r4j_dms_countries` VALUES (203, 'Sudan'); INSERT INTO `t0r4j_dms_countries` VALUES (204, 'Suriname'); INSERT INTO `t0r4j_dms_countries` VALUES (205, 'Svalbard Jan Mayen'); INSERT INTO `t0r4j_dms_countries` VALUES (206, 'Swaziland'); INSERT INTO `t0r4j_dms_countries` VALUES (207, 'Sweden'); INSERT INTO `t0r4j_dms_countries` VALUES (208, 'Switzerland'); INSERT INTO `t0r4j_dms_countries` VALUES (209, 'Syria'); INSERT INTO `t0r4j_dms_countries` VALUES (210, 'Tajikistan'); INSERT INTO `t0r4j_dms_countries` VALUES (211, 'Taiwan'); INSERT INTO `t0r4j_dms_countries` VALUES (212, 'Tahiti'); INSERT INTO `t0r4j_dms_countries` VALUES (213, 'Tanzania'); INSERT INTO `t0r4j_dms_countries` VALUES (214, 'Thailand'); INSERT INTO `t0r4j_dms_countries` VALUES (215, 'Togo'); INSERT INTO `t0r4j_dms_countries` VALUES (216, 'Tokelau'); INSERT INTO `t0r4j_dms_countries` VALUES (217, 'Tonga'); INSERT INTO `t0r4j_dms_countries` VALUES (218, 'Trinidad and Tobago'); INSERT INTO `t0r4j_dms_countries` VALUES (219, 'Tunisia'); INSERT INTO `t0r4j_dms_countries` VALUES (220, 'Turkmenistan'); INSERT INTO `t0r4j_dms_countries` VALUES (221, 'Turks and Caicos Isls'); INSERT INTO `t0r4j_dms_countries` VALUES (222, 'Tuvalu'); INSERT INTO `t0r4j_dms_countries` VALUES (223, 'Uganda'); INSERT INTO `t0r4j_dms_countries` VALUES (224, 'Ukraine'); INSERT INTO `t0r4j_dms_countries` VALUES (225, 'United Arab Emirates'); INSERT INTO `t0r4j_dms_countries` VALUES (226, 'Uruguay'); INSERT INTO `t0r4j_dms_countries` VALUES (227, 'Uzbekistan'); INSERT INTO `t0r4j_dms_countries` VALUES (228, 'Vanuatu'); INSERT INTO `t0r4j_dms_countries` VALUES (229, 'Vatican City State'); INSERT INTO `t0r4j_dms_countries` VALUES (230, 'Venezuela'); INSERT INTO `t0r4j_dms_countries` VALUES (231, 'Vietnam'); INSERT INTO `t0r4j_dms_countries` VALUES (232, 'Virgin Islands (Brit)'); INSERT INTO `t0r4j_dms_countries` VALUES (233, 'Wales'); INSERT INTO `t0r4j_dms_countries` VALUES (234, 'Wallis Futuna Islands'); INSERT INTO `t0r4j_dms_countries` VALUES (235, 'Western Sahara'); INSERT INTO `t0r4j_dms_countries` VALUES (236, 'Western Samoa'); INSERT INTO `t0r4j_dms_countries` VALUES (237, 'Yemen'); INSERT INTO `t0r4j_dms_countries` VALUES (238, 'Yugoslavia'); INSERT INTO `t0r4j_dms_countries` VALUES (239, 'Zaire'); INSERT INTO `t0r4j_dms_countries` VALUES (240, 'Zambia'); INSERT INTO `t0r4j_dms_countries` VALUES (241, 'Zimbabwe');

Please Log in or Create an account to join the conversation.

More
13 years 10 months ago #3155 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re:List of countries is messed up
Hi

I am sorry for the issue . I don't know all the countries , so I got countries database from internet . I will check it and update the modification to the extension soon .

Thanks ,

Tuan

Please Log in or Create an account to join the conversation.