I have just restored my site from akeeba, i deleted the old joomshopping as it wouldnt let me update so trying to now install the latest version but i get:
JInstaller: :Install: Error SQL DB function failed with error number 1062
Duplicate entry '1' for key 'PRIMARY' SQL=INSERT INTO `jos_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:
and so on. any ideas?