Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

import GEDCOM 1 month 2 days ago #1

  • eatzema
  • eatzema's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 11
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
Attachments:

Please Log in or Create an account to join the conversation.

import GEDCOM 1 month 2 days ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

import GEDCOM 1 month 2 days ago #3

  • eatzema
  • eatzema's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 11
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

Please Log in or Create an account to join the conversation.

import GEDCOM 1 month 2 days ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

import GEDCOM 1 month 2 days ago #5

  • eatzema
  • eatzema's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 11
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

Please Log in or Create an account to join the conversation.

import GEDCOM 3 weeks 2 days ago #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.

Please Log in or Create an account to join the conversation.

import GEDCOM 3 weeks 2 days ago #7

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

import GEDCOM 3 weeks 2 days ago #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.
Attachments:

Please Log in or Create an account to join the conversation.

Last edit: by Ercole.
Do you need a web hosting solution for your webtrees site?
If you prefer a host that specialises in webtrees, the following page lists some suppliers able to provide one for you: 

import GEDCOM 3 weeks 5 hours ago #9

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 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 - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

import GEDCOM 2 weeks 1 day ago #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.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Powered by Kunena Forum