1 26-09-2020 15:00 -

Au secours,
Après une mise à jour partielle vers TNG 13 non satisfaisante, j'ai lancé une mise à jour complète en supprimant ma table via phpadmin. L'intal de TNg se déroule correctement mais n'arrive pas à important mes tables via TNg ou phpadmin
https://agora.chauvigne.info/uploads/images/2020/09/26/ap_import_table.jpg



https://agora.chauvigne.info/uploads/images/2020/09/26/rest_tables.jpg


Jean-Louis

2 26-09-2020 16:35 -

J'ai restauré toutes les tables sauf:
Branche et table des branches
Personnes
Lieux

Quelqu'un a une piste de recherche ?

3 26-09-2020 18:25 -

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

4 26-09-2020 19:27 -

Jean-Louis, moi aussi j'ai eu des erreurs sur mon site de test, quand j'ai essayé d'y restaurer les backups des tables du site original. J'ai dû corriger 2 ou 3 lieux en les fusionnant, parce l'un était écrit avec un e, l'autre avec un é (ex : Meounes et Méounes). Alors que en TNG 12, c'était considéré comme 2 lieux différents, en TNG13, c'est considéré comme un seul lieu en 2 occurrences et cela cause un problème de sql : ça ne tient pas compte de l'accent.

Pour ton souci particulier, mieux vaut attendre l'avis de notre expert à nous qu'on a.

5 26-09-2020 20:14 -

merci katyne,
je vais donc patienter

6 26-09-2020 21:37 -

Désolé, j'étais occupé...
Pour la dernière erreur que tu rapportes, je vois ceci :

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","","")

Il y 13 valeurs et seulement 12 noms de champs.
la fin de l'instruction xxxxxchangedate,changedby, )  est tronquée... il faut y mettre le nom de champ manquant... Mais comme il n'y a que 12 champs dans la table tng_places, il faut effacer le treizième champ dans les valeurs...

Je ne sais comment ce fichier est devenu tout pourri...

Donc :
1. sauve ton fichier sql.
2. avec un bon traitement de texte (pas notepad de windows) fair un chercher/remplacer de ,"") à remplacer par )
ainsi que chercher/remplacer changedby, )  à remplacer par changedby)
3. Sauve le nouveau fichier en .bak et restaure-le...
Michel

7 26-09-2020 21:41 -

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

8 26-09-2020 23:10 -

Michel
NLa table des noms a été corrigée en effaçant les associations existantes (Associates Names Mod)
Je t'ai envoyé par mail le fichier bak des places (non résolu)
JLouis

9 26-09-2020 23:50 -

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

10 26-09-2020 23:56 -

Le champ GoVid vient du mod Add GOV-ID Mod

11 27-09-2020 00:05 -

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  (116)

12 27-09-2020 11:16 -

tng_places restauré, problème réglé.
Je connais cette règle de désinstaller les Mods et pourtant visiblement je fais encore des erreurs de manip !!! PAS BIENNNN ...
Merci Michel

13 27-09-2020 12:54 -

De rien !

14 14-11-2020 11:41 -

J'ai encore un problème à l'import, choix serveur Web, import médias sélectionné et ancienne méthode. L'import se bloque à i2030, alors que l'import sans les médias se déroule correctement. Est-ce un problème de paramètrage de TGN ou une anomalie dand le gedcom
https://agora.chauvigne.info/uploads/images/2020/11/14/2020-11-03_11_01_46-histoire_de_notre_famille__tng_admin_(import_export).jpg

15 14-11-2020 17:10 -

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...?

16 14-11-2020 17:42 -

Je peux d'envoyer mon fichier, si tu pouvais l'analyser ?

17 15-11-2020 02:01 -

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

18 15-11-2020 10:55 -

Ok Michel, je te l'envoie via ta messagerie. Aucune inquiètude, je suis patient
JLouis

19 06-08-2021 23:03 -

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

20 09-08-2021 09:45 -

Bonjour Pascal !

Dans la page des téléchargements, il y a un pack complet ET des zip de mise à jour, plusieurs, selon la version exacte d'où l'on vient.
C'est donc qu'il ne faut pas tout réinstaller.

Dans le zip de mise à jour que tu auras choisi, ouvre en local le fichier html  readme (celui, de la mise à jour, pas le readme tout court). Tu auras le pas-à-pas de la mise à jour, en anglais, certes... Cela te permettra de savoir à l'avance comment ça va se passer et les préparatifs et sauvegardes préalables nécessaires. Personnellement, à chaque mise à jour, je fais une sauvegarde complète : d'abord, la base de données et la structure des tables par l'admin/outils. Et la BDD depuis phpmyadmin, pour faire bonne mesure (ceinture et bretelles). Ensuite le gedcom toujours depuis l'admin du site. Et enfin, tout tout tout par ftp.

Ensuite, tu suis les instructions du fichier readme en local, puis quand tu as passé l"étape de l'upload des nouveaux fichiers par ftp, tu ouvres le readme en ligne. Je me répète , mais il s'agit du fichier dont le nom ressemble à ça : readme123-13x.html  (dans cet exemple, celui du zip de maj de v.12.3 vers v.13.0.

N'oublie pas de désinstaller les mods au moment où l'on te dit.

21 10-08-2021 08:33 -

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

22 10-08-2021 15:56 -

Bonjour Katryne Jean Louis
Merci pour vos précieux conseils
MAj réalisée sans problème
Ne pas oublier de se connecter pour l’upgrade
J’en ai profité pour changer de template
TNG que du bonheur
Encore merci
Pascal