Web based family history software

Question [SOLVED] connection between user database and family tree

  • mariannevanharten
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 6 months ago #1 by mariannevanharten
connection between user database and family tree was created by mariannevanharten
I upload a gedcom file with some minor modifications, but the person's ID are the same and remain!
When I look in the user database, the connection between the user and the tree are gone. The user isn't connected to his/her person in the tree.
Is there a way to fix these connection (may be an own created gedcom tag)?

Best regards,
Guido

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

More
4 years 6 months ago #2 by fisharebest
Replied by fisharebest on topic connection between user database and family tree
> I upload a gedcom file with some minor modifications

Into a new tree, or into the existing tree?

> When I look in the user database, the connection between the user and the tree are gone.

The connection is stored in the table wt_user_gedcom_setting, with a setting name of "gedcomid".

Did the entry get deleted? Set to an empty string? Set to something else?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

  • mariannevanharten
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 6 months ago #3 by mariannevanharten
Replied by mariannevanharten on topic connection between user database and family tree

fisharebest wrote: Into a new tree, or into the existing tree?


I would upload the gedcom into an existing tree but there another problem appeared:
Code:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '10-M1' for key 'PRIMARY' (SQL: insert into `wt_media` (`m_id`, `m_file`, `m_gedcom`) values (M1, 10, 0 @M1@ OBJE 1 FILE documenten/__1898_overlijdensakte.jpg 2 FORM jpeg 3 TYPE document 2 TITL akte levenloos geboren dochter Zweistra-Wenteler (1898)))
.
To avoid this error I created a new tree, and upload the gedcom. Then there is no error.

Did the entry get deleted? Set to an empty string? Set to something else?


I didn't look into the MySQL tables, only in the webinterface. (I don't remember the name (and password) of my MySQL database); where can I find it?)

Best regards,
Guido

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

More
4 years 6 months ago #4 by fisharebest
Replied by fisharebest on topic connection between user database and family tree
> I created a new tree, and upload the gedcom

This explains why your users are no longer connected to individual records.

> Duplicate entry '10-M1'

This error suggests that your GEDCOM file contains two records called M1.

Does it have two lines that look like this?

0 @M1@ OBJE

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

  • mariannevanharten
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 6 months ago #5 by mariannevanharten
Replied by mariannevanharten on topic connection between user database and family tree

fisharebest wrote: > I created a new tree, and upload the gedcom

This explains why your users are no longer connected to individual records.


That's I prefer a gedcom tag to store the User ID in the user table.

This error suggests that your GEDCOM file contains two records called M1.

Does it have two lines that look like this?

0 @M1@ OBJE


No, I am sure there isn't.

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

More
4 years 6 months ago #6 by fisharebest
Replied by fisharebest on topic connection between user database and family tree
Does the GEDCOM file contain a mix of media records like this:

0 @M1@ OBJE

and inline media references like this:

1 OBJE
2 FILE xxx.jpeg

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

  • mariannevanharten
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 6 months ago #7 by mariannevanharten
Replied by mariannevanharten on topic connection between user database and family tree

fisharebest wrote: Does the GEDCOM file contain a mix of media records like this:

0 @M1@ OBJE

and inline media references like this:

1 OBJE
2 FILE xxx.jpeg


No, I don't think so. Referring to the error in #2 there are two parts in the gedcom:
Code:
0 @I1847@ INDI 1 NAME // 1 BIRT 2 TYPE stillborn 1 DEAT 2 DATE 5 FEB 1898 2 PLAC Schiedam 1 FAMC @F1565797032@ 1 OBJE @M1@ 2 CHAN 3 DATE 15 SEP 2019 3 TIME 20:01:00 1 SEX F 1 OBJE @M1@

and
Code:
0 @M1@ OBJE 1 FILE documenten\__1898_overlijdensakte.jpg 2 FORM jpeg 3 TYPE document 2 TITL akte levenloos geboren dochter Zweistra-Wenteler (1898)

There are no other phrases or
Code:
@M1@
in the gedcom.

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

More
4 years 6 months ago #8 by fisharebest
Replied by fisharebest on topic connection between user database and family tree
> There are no other phrases or @M1@ in the gedcom.

But are there any inline media?

When these exist, webtrees converts them to media objects.

It assumes that your GEDCOM file uses just the one style.

If you have both, then it is possible that webtrees will create @M1@ for the first inline media, which could clash with a media object later in the file.

Could you send me the GEDCOM file?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

More
4 years 6 months ago #9 by fisharebest
Replied by fisharebest on topic connection between user database and family tree
Thanks for sending the GEDCOM file.
For me, it loads without any problem.

When you imported it, did you tick the "Keep media objects" option?
This would cause your error.

Your GEDCOM file *does* contain media objects, and so you do *not* need to use this option.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

  • mariannevanharten
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 6 months ago #10 by mariannevanharten
Replied by mariannevanharten on topic connection between user database and family tree
The first time loading is no problem.
When I modify some records and I upload the gedcom again in the existing tree. Random I will choose or not to keep media objects.
Loading and reading the gedcom the second time it will give the error.

Hope you can find the problem.

Best regards,
Guido

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

More
4 years 6 months ago #11 by fisharebest
Replied by fisharebest on topic connection between user database and family tree
> Random I will choose or not to keep media objects.

Do NOT select this option. It is designed for a small number of users with a specific requirement.

It WILL cause this error when you import the tree a second time.

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

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

  • mariannevanharten
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
4 years 5 months ago #12 by mariannevanharten
Replied by mariannevanharten on topic [SOLVED] connection between user database and family tree
Problem solved.

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

Powered by Kunena Forum
}