[résolu] MAJ TNG 13

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

merci katyne,
je vais donc patienter

Pour ce qui est de ta première erreur : c'est règlé ou pas?
J'arrive pas à lire tout. Mais il y a une erreur colonne inconnue datefinished dans la liste des champs...

Michel

Jean-louis,
Katryn m'a transféré ton fichier... C'est quoi le champ GoVid?
En tng12, la table n'a que 10 champs et 2 ont été ajoutés en TNG13..
Mais pas de champ GoVid...

Tu as une explication?
Ca viendrait d'un Mod?
Michel

La première règle IMPERATIVE avant toute mise à jour est de désinstaller TOUS les Mods...
De toute façon, ce champ était à blanc dans toutes les lignes...

Donc s'il existe encore dans ta table, tng_places, supprime-le
puis restaure ta table avec le fichier en attache.
Michel

tng_places.zip  22.9 Ko  (265)

De rien !

Ca Jean-Louis, c'est impossible à dire sans le fichier gedcom...
L'import s'arrête toujours au même endroit? Alors probablement un problème dans le gedcom. Sinon...?

OK Jean-louis. Mais ne soit pas pressé....
Michel

Bonjour à tous,

Je souhaiterais passer en v 13, mais je ne sais comment faire cette migration.

Il semblerait que ce n'est pas une mise à jour et que l'on doit tout réinstaller ?

Site local et site distant ?

Merci pour votre retour

Pascal

Bonjour Pascal,
Pour simplifier le transfert ftp, Je créée un nouveau dossier tng en local après avoir renommer le dossier original pour le sauvegarder.
Puis copie de la mise à jour tng dans ce nouveau dossier.  On peut ainsi transférer la totalité du dossier.
Jean-Louis