Bienvenue, Invité
Nom d'utilisateur : Mot de passe :
Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page :
  • 1

SUJET :

Problem with GEDCOM-Import il y a 2 semaines 2 jours #1

Hi fellow genealogists,

the time has come to publish the findings of my research-efforts. I decided to use webtrees for publishing. But, as usual with new programms, on my first import I ran into difficulties. :-(

can someone please advice me, if this is a problem with my GEDCOM-file (exported from Familiy Tree Builder) or if it is a bug with webtrees 2.06?

Thanks in advance, Lars.

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'p_place' at row 1 (SQL: insert into `places` (`p_file`, `p_place`, `p_parent_id`, `p_std_soundex`, `p_dm_soundex`) values (1, German: variant of Joachim. MENK- • Joachim • Joachimczyk • Joachims • Joachimsen • Joachimsohn • Joachimssen • Joachimssohn • Joachimsthal • Jochem • Jochemczyk • Jochim • Jochimczyk • Jochimsohn • Jochimsthal •, 0, G655:V653:O100:J250:M520:J252, 596600:349660:796300:070000:156000:456000:556000:146000:446000:546000:665000:156450:456450:556450:146450:446450:546450:156400:456400:556400:146400:446400:546400:156460:456460:556460:146460:446460:546460:156456:456456:556456:146456:446456:546456:156435))
genealogie-ravenswaaij.online published by webtrees 2.06 on debian 10.4 with nginx 1.19, php 7.4 and mariadb 10.5

Connexion ou Créer un compte pour participer à la conversation.

Dernière édition: par Lars1963.

Problem with GEDCOM-Import il y a 2 semaines 2 jours #2

  • fisharebest
  • Portrait de fisharebest
  • Absent
  • Administrator
  • Administrator
  • Messages : 13196
> can someone please advice me, if this is a problem with my GEDCOM-file (exported from Familiy Tree Builder) or if it is a bug with webtrees 2.06?

It is both!

Your GEDCOM file contains this "place name":

German: variant of Joachim. MENK- • Joachim • Joachimczyk • Joachims • Joachimsen • Joachimsohn • Joachimssen • Joachimssohn • Joachimsthal • Jochem • Jochemczyk • Jochim • Jochimczyk • Jochimsohn • Jochimsthal •

1) this is not a placename!
2) GEDCOM says that each part of a placename should be less than 120 characters.


But this is also a bug. webtrees should work with invalid data.
Greg Roach - Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser. - fisharebest.webtrees.net

Connexion ou Créer un compte pour participer à la conversation.

Problem with GEDCOM-Import il y a 2 semaines 2 jours #3

A valid GEDCOM place record would look something like this:

2 PLAC Waldgirmes, Lahnau, Lahn-Dill-Kreis, Hessen, Germany
Ken

Connexion ou Créer un compte pour participer à la conversation.

[solved] Problem with GEDCOM-Import il y a 2 semaines 2 jours #4

Thx, then I'll have to find out, where this mix-up happens. This record really should not exist with such content at all!

Glad that it also shows a bug that you can fix ;-)

Lars

Edit #1: regarding the "bug"; I opened a issue at github
Edit #2: Found the faulty record around the year 1500. Now the import works flawlessly.
genealogie-ravenswaaij.online published by webtrees 2.06 on debian 10.4 with nginx 1.19, php 7.4 and mariadb 10.5

Connexion ou Créer un compte pour participer à la conversation.

Dernière édition: par Lars1963.
  • Page :
  • 1
Propulsé par Kunena