table Noms corrigée en effaçant les associations existantes de Associates Names Mod
reste la table Lieux, en la restaurant j'ai le log suivant :
Une erreur est intervenue dans le logiciel TNG. Ce que vous devez faire :
Si vous venez d'installer une mise à jour, vous avez peut-être sauté une partie des instructions d'installation. Retournez à la page du Lisez-moi pour relire les instructions. Prêtez une attention particulière à l'étape de la structure de la base de données.
Si vous venez de faire une première installation de TNG, il est peut-être encore nécessaire de créer les tables de la base de données. Revenez à la page du lisez-moi pour retrouver cette étape.
Si vous êtes le propriétaire du site, vous pouvez contacter le service assistance de TNG pour obtenir une aide supplémentaire sur ce problème. Merci de copier la requête ci-après et collez-la dans votre message.
Requête: INSERT INTO tng_places (ID,gedcom,place,longitude,latitude,zoom,placelevel,temple,geoignore,notes,changedate,changedby, ) VALUES ("1","","Melin, 70337, , Haute-Saône, , France","5.82698","47.74059","0","0","0","0","","0000-00-00 00:00:00","",""),("2","","Champoly, 42047, , Loire, , France","3.83758","45.85849","0","0","0","0","","0000-00-00 00:00:00","",""),("3","","Boën-sur-Lignon, 42019, , Loire, , France","4.00959","45.74618","0","0","0","0","","0000-00-00 00:00:00","",""),("4","","Saint-Romain-d\'Urfé, 42282, , Loire, , France","3.82778","45.88692","0","0","0","0","","0000-00-00 00:00:00","",""),("5","","Nancy, 54395, , Meurthe-et-Moselle, , France","6.18496","48.68439","0","0","0","0","","0000-00-00 00:00:00","",""),("6","","Tallende, 63425, , Puy-de-Dôme, , France","3.12799","45.67126","0","0","0","0","","0000-00-00 00:00:00","",""),("7","","Montbrison, 42147, , Loire, , France","4.05","45.6","0","0","0","0","","0000-00-00 00:00:00","",""),("8","","Saint-Priest-la-Prugne, 42276, , Loire, , France","3.74965","45.9612","0","0","0","0","","0000-00-00 00:00:00","",""),("9","","Roanne, 42187, , Loire, , France","4.06667","46.03333","0","0","0","0","","0000-00-00 00:00:00","",""),("10","","Lille, 59350, , Nord, , France","3.05858","50.63297","0","0","0","0","","0000-00-00 00:00:00","",""),("11","","Ollioules, 83090, , Var, , France","5.848","43.13517","0","0","0","0","","0000-00-00 00:00:00","",""),("12","","Collonges-sous-Salève, 74082, , Haute-Savoie, , France","6.15372","46.1416","0","0","0","0","","0000-00-00 00:00:00","",""),("13","","Saint-Julien-en-Genevois, 74243, , Haute-Savoie, , France","6.08256","46.14434","0","0","0","0","","0000-00-00 00:00:00","",""),("14","","Weitbruch, 67523, , Bas-Rhin, , France","7.77935","48.75455","0","0","0","0","","0000-00-00 00:00:00","",""),("15","","Maxéville, 54357, , Meurthe-et-Moselle, , France","6.1696","48.70816","0","0","0","0","","0000-00-00 00:00:00","",""),("16","","Montigny-lès-Metz, 57480, , Moselle, , France","6.15167","49.09435","0","0","0","0","","0000-00-00 00:00:00","",""),("17","","Moyeuvre-Grande, 57491, , Moselle, , France","6.04754","49.25165","0","0","0","0","","0000-00-00 00:00:00","",""),("18","","Fouchécourt, 70244, , Haute-Saône, , France","5.9955","47.7889","0","0","0","0","","0000-00-00 00:00:00","",""),("19","","Clermont-Ferrand, 63113, , Puy-de-Dôme, , France","3.08628","45.77966","0","0","0","0","","0000-00-00 00:00:00","",""),("20","","Rainville, 88366, , Vosges, , France","5.88553","48.35773","0","0","0","0","","0000-00-00 00:00:00","",""),("21","","Vézelise, 54563, , Meurthe-et-Moselle, , France","6.08894","48.48682","0","0","0","0","","0000-00-00 00:00:00","",""),("22","","Laqueuille, 63189, , Puy-de-Dôme, , France","2.7325","45.64976","0","0","0","0","","0000-00-00 00:00:00","",""),("23","","Tauves, 63426, , Puy-de-Dôme, , france","2.7325","45.64976","0","0","0","0","","0000-00-00 00:00:00","",""),("24","","Essey-lès-Nancy, 54184, , Meurthe-et-Moselle, , France","6.22425","48.70179","0","0","0","0","","0000-00-00 00:00:00","",""),("25","","Baerenthal, 57046, , Moselle, , France","7.51911","48.97519","0","0","0","0","","0000-00-00 00:00:00","",""),("26","","Longvic, 21355, , Côte-d\'Or, , France","5.06341","47.28754","0","0","0","0","","0000-00-00 00:00:00","",""),("27","","Boissise-le-Roi, 77040, , Seine-et-Marne, , France","7.80097","48.71537","0","0","0","0","","0000-00-00 00:00:00","",""),("28","","Preigney, 70423, , Haute-Saône, , France","5.77528","47.76246","0","0","0","0","","0000-00-00 00:00:00","",""),("29","","Quincey, 70433, Les Claviers, Haute-Saône, , France","6.219665","47.570264","0","0","0","0","","0000-00-00 00:00:00","",""),("30","","Gourgeon, 70272, , Haute-Saône, , France","5.84499","47.71873","0","0","0","0","","0000-00-00 00:00:00","",""),("31","","Montigny-lès-Cherlieu, 70362, Marlay, Haute-Saône, , France","5.829066","47.76489","0","0","0","0","","0000-00-00 00:00:00","",""),("32","","Scey-sur-Saône-et-Saint-Albin, 70482, , Haute-Saône, , France","5.97451","47.66398","0","0","0","0","","0000-00-00 00:00:00","",""),("33","","Montigny-lès-Cherlieu, 70362, , Haute-Saône, , France","5.81109","47.79828","0","0","0","0","","0000-00-00 00:00:00","",""),("34","","Lavigney, 70298, , Haute-Saône, , France","5.80906","47.71264","0","0","0","0","","0000-00-00 00:00:00","",""),("35","","Noroy-le-Bourg, 70390, , Haute-Saône, , France","6.30564","47.61419","0","0","0","0","","0000-00-00 00:00:00","",""),("36","","Cornot, 70175, , Haute-Saône, , France","5.83358","47.69308","0","0","0","0","","0000-00-00 00:00:00","",""),("37","","Pierrefaites, 52388, , Haute-Marne, , France","5.6591","47.799","0","0","0","0","","0000-00-00 00:00:00","",""),("38","","Saint-Broing, 70461, , Haute-Saône, , France","5.69719","47.44772","0","0","0","0","","0000-00-00 00:00:00","",""),("39","","Contréglise, 70170, , Haute-Saône, , France","6.03633","47.82546","0","0","0","0","","0000-00-00 00:00:00","",""),("40","","Barges, 70049, , Haute-Saône, , France","5.8468","47.86285","0","0","0","0","","0000-00-00 00:00:00","",""),("41","","Barges, 70049, cimetière, Haute-Saône, , France","5.8455","47.8649","0","0","0","0","","0000-00-00 00:00:00","",""),("42","","Saint-Just-en-Chevalet, 42248, , Loire, , France","3.8446","45.91396","0","0","0","0","","0000-00-00 00:00:00","",""),("43","","Paris, 75056, , Paris, , France","2.3003","48.8412","0","0","0","0","","0000-00-00 00:00:00","",""),("44","","Auxonne, 21038, , Côte-d\'Or, , France","5.38726","47.19255","0","0","0","0","","0000-00-00 00:00:00","",""),("45","","Les Salles, 42295, , Loire, , France","3.7961","45.84876","0","0","0","0","","0000-00-00 00:00:00","",""),("46","","Les Salles, 42295, Les Gouttes, Loire, , France","3.7961","45.84876","0","0","0","0","","0000-00-00 00:00:00","",""),("47","","Angirey, 70022, , Haute-Saône, , France","5.7674","47.45467","0","0","0","0","","0000-00-00 00:00:00","",""),("48","","Paris 17, 75056, , Paris, , France","2.3219","48.8835","0","0","0","0","","0000-00-00 00:00:00","",""),("49","","Bougey, 70078, , Haute-Saône, , France","5.8614","47.7814","0","0","0","0","","0000-00-00 00:00:00","",""),("50","","Besançon, 25056, , Doubs, , France","6.01815","47.24878","0","0","0","0","","0000-00-00 00:00:00","",""),("51","","Malvillers, 70329, , Haute-Saône, , France","5.78691","47.73092","0","0","0","0","","0000-00-00 00:00:00","",""),("52","","Arbecey, 70025, , Haute-Saône, , France","5.92824","47.73913","0","0","0","0","","0000-00-00 00:00:00","",""),("53","","Neurey-lès-la-Demie, 70381, , Haute-Saône, , France","6.19384","47.57673","0","0","0","0","","0000-00-00 00:00:00","",""),("54","","La Roche-Morey, 70373, , Haute-Saône, , France","5.73333","47.7","0","0","0","0","","0000-00-00 00:00:00","",""),("55","","Vesoul, 70550, , Haute-Saône, , France","6.16667","47.63333","0","0","0","0","","0000-00-00 00:00:00","",""),("56","","Combs-la-Ville, 77122, , Seine-et-Marne, , France","2.56957","48.66497","0","0","0","0","","0000-00-00 00:00:00","",""),("57","","Dax, 40088, , Landes, , France","-1.05366","43.71032","0","0","0","0","","0000-00-00 00:00:00","",""),("58","","Gevigney-et-Mercey, 70267, , Haute-Saône, , France","5.93228","47.79877","0","0","0","0","","0000-00-00 00:00:00","",""),("59","","Neuvelle-lès-Cromary, 70383, , Haute-Saône, , France","6.07528","47.39763","0","0","0","0","","0000-00-00 00:00:00","",""),("60","","Navenne, 70378, , Haute-Saône, , France","6.16176","47.60873","0","0","0","0","","0000-00-00 00:00:00","",""),("61","","Baignes, 70047, , Haute-Saône, , France","6.05029","47.58513","0","0","0","0","","0000-00-00 00:00:00","",""),("62","","Baulay, 70056, , Haute-Saône, , France","6.00977","47.78655","0","0","0","0","","0000-00-00 00:00:00","",""),("63","","Saint-Ouen-lès-Parey, 88430, , Vosges, , France","6.07528","47.39763","0","0","0","0","","0000-00-00 00:00:00","",""),("64","","Benestroff, 57060, , Moselle, , France","6.75946","48.90539","0","0","0","0","","0000-00-00 00:00:00","",""),("65","","Hà Noi, , , , Ha Nội, Viet Nam","105.84117","21.0245","0","0","0","0","","0000-00-00 00:00:00","",""),("66","","Paris, 75104, , Paris, , France","2.3488","48.85341","0","0","0","0","","0000-00-00 00:00:00","",""),("67","","Aigremont, 52002, , Haute-Marne, , France","5.71667","48.01667","0","0","0","0","","0000-00-00 00:00:00","",""),("68","","Port-d\'Atelier, 70427, , Haute-Saône, , France","6.0252","47.759727","0","0","0","0","","0000-00-00 00:00:00","",""),("69","","Diarville, 54156, , Meurthe-et-Moselle, , France","6.13375","48.3952","0","0","0","0","","0000-00-00 00:00:00","",""),("70","","Lambrey, 70293, , Haute-Saône, , France","5.92778","47.76389","0","0","0","0","","0000-00-00 00:00:00","",""),("71","","Foucherans, 25250, , Doubs, , France","6.13634","47.15821","0","0","0","0","","0000-00-00 00:00:00","",""),("72","","Saint-Martin-la-Sauveté, 42260, Grésolette, Loire, , France","3.950188","45.841136","0","0","0","0","","0000-00-00 00:00:00","",""),("73","","Mont-de-Marsan, 40192, , Landes, , France","-0.49713","43.89022","0","0","0","0","","0000-00-00 00:00:00","",""),("74","","Sallanches, 74256, , Haute-Savoie, , France","6.63162","45.94423","0","0","0","0","","0000-00-00 00:00:00","",""),("75","","Bar-le-Duc, 55029, , Meuse, , France","5.16667","48.78333","0","0","0","0","","0000-00-00 00:00:00","",""),("76","","Rupt-sur-Moselle, 88408, , Vosges, , France","6.66291","47.92271","0","0","0","0","","0000-00-00 00:00:00","",""),("77","","Laxou, 54304, , Meurthe-et-Moselle, , France","6.14799","48.68315","0","0","0","0","","0000-00-00 00:00:00","",""),("78","","Cognac, 16102, , Charente, , France","-0.33333","45.7","0","0","0","0","","0000-00-00 00:00:00","",""),("79","","Dampierre-sur-Salon, 70198, , Haute-Saône, , France","5.6797","47.55719","0","0","0","0","","0000-00-00 00:00:00","",""),("80","","Bourbévelle, 70086, , Haute-Saône, , France","5.94039","47.92373","0","0","0","0","","0000-00-00 00:00:00","",""),("81","","Calmoutier, 70111, , Haute-Saône, , France","6.27888","47.64479","0","0","0","0","","0000-00-00 00:00:00","",""),("82","","Maisons-Laffitte, 78358, , Versailles, , France","2.14521","48.95264","0","0","0","0","","0000-00-00 00:00:00","",""),("83","","Nîmes, 30189, , Gard, , France","5.82698","47.74059","0","0","0","0","","0000-00-00 00:00:00","",""),("84","","Salon-de-Provence, 13103, , Bouches-du-Rhône, , France","5.09545","43.64074","0","0","0","0","","0000-00-00 00:00:00","",""),("85","","Troyes, 10387, , Aube, , France","4.08333","48.3","0","0","0","0","","0000-00-00 00:00:00","",""),("86","","Vittel, 88516, , Vosges, , France","5.94843","48.20085","0","0","0","0","","0000-00-00 00:00:00","",""),("87","","Landerneau, 29103, , Finistère, , France","-4.25252","48.45252","0","0","0","0","","0000-00-00 00:00:00","",""),("88","","Joudreville, 54284, , Meurthe-et-Moselle, , France","5.77832","49.2856","0","0","0","0","","0000-00-00 00:00:00","",""),("89","","Hauteroche, 21314, , Côte-d\'Or, , France","4.58095","47.50012","0","0","0","0","","0000-00-00 00:00:00","",""),("90","","Carcès, 83032, , Var, , France","6.18308","43.47632","0","0","0","0","","0000-00-00 00:00:00","",""),("91","","Dijon, 21231, , Côte-d\'Or, , France","5.01667","47.31667","0","0","0","0","","0000-00-00 00:00:00","",""),("92","","Florange, 57221, , Moselle, , France","6.1212","49.32373","0","0","0","0","","0000-00-00 00:00:00","",""),("93","","Varangéville, 54549, , Meurthe-et-Moselle, , France","6.32112","48.63605","0","0","0","0","","0000-00-00 00:00:00","",""),("94","","Sainte-Marie-sur-Ouche, 21559, , Côte-d\'Or, , France","4.79655","47.2869","0","0","0","0","","0000-00-00 00:00:00","",""),("95","","Dieuze, 57177, , Moselle, , France","6.7178","48.81263","0","0","0","0","","0000-00-00 00:00:00","",""),("96","","Savigny-sous-Mâlain, 21592, , Côte-d\'Or, , France","4.75989","47.33202","0","0","0","0","","0000-00-00 00:00:00","",""),("97","","Verdun, 55545, , Meuse, , France","5.38333","49.16667","0","0","0","0","","0000-00-00 00:00:00","",""),("98","","Nice, 06088, , Alpes-Maritimes, , France","7.26608","43.70313","0","0","0","0","","0000-00-00 00:00:00","",""),("99","","Strasbourg, 67482, , Bas-Rhin, , France","7.74553","48.58392","0","0","0","0","La Robertsau, banlieu de Strasbourg https://fr.wikipedia.org/wiki/Robertsau","0000-00-00 00:00:00","",""),("100","","Toulon, 83137, , Var, , France","5.93333","43.11667","0","0","0","0","","0000-00-00 00:00:00","","")
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 ') VALUES ("1","","Melin, 70337, , Haute-Saône, , France","5.82698","47.74059","' at line 2