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 :

import GEDCOM il y a 1 mois 2 jours #1

Not sure what is going on. I used to be able to import GEDCOM files, but starting with 2.0.4 I no longer can. Either webtrees says "Invalid GEDCOM file - no header record found." --- even with files that I was able to import on the same install, or I get something like:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'HEAD-2' for key 'PRIMARY' (SQL: insert into `wt_other` (`o_id`, `o_file`, `o_type`, `o_gedcom`) values (HEAD, 2, UNKNOWN, 0 @HEAD@ UNKNOWN 1 SOUR webtrees 2 DEST webtrees 1 GEDC 2 VERS 5.5.1 2 FORM LINEAGE-LINKED 1 CHAR UTF-8 1 DATE 24 FEB 2020 1 CHAN 2 DATE 12 MAR 2020 3 TIME 15:16:57 2 _WT_USER webtrees_admin 1 SUBM @X160@))

This particular error message message actually comes from exporting a family tree as GEDCOM and then trying to import it again. See attachment for the file (just replace .zip with .ged). I would try 2.0.5, but it does not show up for me yet on my installs and I would like to see if there aren't any problems with the automatic install for a new setup that I am trying out.

Anyway, in either case, nothing gets imported. Right now I am having trouble with three different installs, one with Dreamhost which has always worked fine (running PHP7.3 and MySQL 5.6), a second one on my brand-new MacBook Pro running php7.3 through brew (the default php does not have all required modules installed and Apple does not let you add modules) and MySQL8.0, and finally one on a raspberry pi running buster (with php7.3 and MariaDB 10.3). Any suggestions?

Thanks,
Eisso
Pièces jointes :

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

import GEDCOM il y a 1 mois 2 jours #2

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 13196
I think the problem is caused by a bug that has since been fixed.

Perhaps you edited one of the "special" records, such as SUBN using the raw-GEDCOM editor.

This bug changed the record type from SUBN to UNKNOWN.

To fix this, you need to edit the file with a text editor, and delete the bogus '0 @HEAD@ UNKNOWN` record.

It runs from line 14 "0 @HEAD@ UNKNOWN" to line 26 "1 SUBM @X160@".

After you do that, the file will load OK.
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.

import GEDCOM il y a 1 mois 2 jours #3

Actually, after I removed the lines 14 through 26, I got the "invalid gedcom file - no hear record found" message again. I will see what 2.0.5 does...
Eisso

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

import GEDCOM il y a 1 mois 2 jours #4

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 13196
I deleted those lines - and the file imported OK for me.

I don't think there are any changes in 2.0.5 that will make a difference, but tell us what happens and we can help.
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.

import GEDCOM il y a 1 mois 2 jours #5

I figured it out. Even though GEDitCom (my desktop genealogy program) makes it look like its files are pure GED, they really are zipped folders with the actual GED files embedded in them (hence the extension .gedpkg, duh). Once I took out the ged files, they imported fine. My bad. It has been a long week! The file that I sent you imported fine on two of my installs after I took out the offending lines and when I tried it again on the third install it imported fine too. Must have done something strange the first time with that one... Thanks as always.
Eisso

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

import GEDCOM il y a 3 semaines 2 jours #6

Hello. I have been using webtrees for several years. For the first time I had an error loading the GEDCOM file

The error is as follows:

SQLSTATE [23000]: Integrity constraint violation: 1062 Duplicate entry 'I31-1-OBJE-M850' for key 1
(SQL: insert into `wt_link` (` l_file`, `l_from`,` l_to`, `l_type`)
values (1, I31, F1032, FAMS)
, (1, I31, F786, FAMC)
, (1, I31, M850, OBJE))

I have tried to understand what recent changes I made to the system.
I was unable to find an acceptable explanation.

I import a GEDCOM file created with the FZip Family Tree program.
I thought of some double records present in the Gedcom file or the damaged file.
I have not found any apparent anomalies in the GEDCOM file.

When I load the GEDCOM file, the Keep media objects option is active.
I understand that there is at least one problem on the `wt_link` table with the record type l_type = 'OBJE'.
In order to test it, I ran.
"update` wt_link` set l_file = 2 (The default was l_file = 1)

At this point I imported the GEDCOM file again which ended without errors.
Obviously I have lost the link between MEDIA and individual.
This is not a problem for me because I have the database backup of the day before.

It appears that webtrees attempted to write an existing OBJE-type record to `wt_link`.
It would be helpful to know what the tables are and how they are cleaned up when importing a file
GEDCOM with the "Keep media objects" option activated.
Thanks in advance for your help.

Ercole

Webtrees: 2.0.5 - PHP: 7.3.17 - MySql: 5.0.92-50-log
Other Modules: Faces by UksusoFF
: Tree View Full Screen by UksusoFF
GEDCOM file created by the FZip Family Tree program
Media only with Webtrees
Keep media objects import option active.
Webtrees: 2.0.6 - PHP: 7.3.17 - MySql: 5.0.92-50-log - site; www.antenatidellecese.it
Other Modules: Faces by UksusoFF , Tree View Full Screen by UksusoFF
Media only with Webtrees ; Keep media objects import option active.
GEDCOM file created by the FZip Family Tree program.

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

import GEDCOM il y a 3 semaines 2 jours #7

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 13196
> When I load the GEDCOM file, the Keep media objects option is active.

You should only use this option if

a) your GEDCOM file does NOT contain any media objects
b) you have added media in webtrees, but do all your editing in another application

If your GEDCOM file contains media objects, and you use the "keep media objects" option, then you will get this error.

Please examine your GEDCOM file. Does it contain any media objects?
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.

import GEDCOM il y a 3 semaines 2 jours #8

a) GEDCOM file does NOT contain multimedia objects, i.e. OBJE record type.
b) I manage the genealogical data with an external program that produces the GEDCOM files. I manage MEDIA only with Webtrees of which I also use the EDIT Re-Order Media function, when needed.

So I suppose I'm using this option in the correct way, (otherway I could lose the media-individual link).
I 've always used this option without any problem.
Do you need more information to understand the issue?

I am attaching a document that could help solve the problem
Webtrees: 2.0.6 - PHP: 7.3.17 - MySql: 5.0.92-50-log - site; www.antenatidellecese.it
Other Modules: Faces by UksusoFF , Tree View Full Screen by UksusoFF
Media only with Webtrees ; Keep media objects import option active.
GEDCOM file created by the FZip Family Tree program.
Pièces jointes :

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

Dernière édition: par Ercole.
Avez-vous besoin d'une solution d'hébergement web pour votre site webtrees ?
Si vous préférez un hébergeur spécialisé de webtrees, la page suivante en liste quelques-uns capables de vous offrir ce type de service :

import GEDCOM il y a 3 semaines 4 heures #9

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 13196
Thanks for the detailed instructions.

I can see the problem now. It was caused by the recent changes to improve performance.

A fix will be available very soon.
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.

import GEDCOM il y a 2 semaines 1 jour #10

Hi.
With version 2.0.6 the problem has been solved. Thanks.
There is another problem but I don't know whether to open a 'New Topic "or to queue it here.
Briefly:
When importing a GEDCOM file with the "Keep media data" option enabled
Priority is lost on images. That is, _pry Y no longer exists.
If it can be useful, I can write a detailed document to describe what is happening in order to have more elements to solve the problem.
Thanks.
Webtrees: 2.0.6 - PHP: 7.3.17 - MySql: 5.0.92-50-log - site; www.antenatidellecese.it
Other Modules: Faces by UksusoFF , Tree View Full Screen by UksusoFF
Media only with Webtrees ; Keep media objects import option active.
GEDCOM file created by the FZip Family Tree program.

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

  • Page :
  • 1
Propulsé par Kunena