This Help forum is for issues relates to webtrees 1.7. For issues related to webtrees 2.0, please use that forum.
Before asking for help please read "How to request help" by clicking on that tab above here."
  • Page:
  • 1

TOPIC:

SQLSTATE 23000 BLOCAGE 1 week 1 hour ago #1

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
Bonjour,

Après l'import d'un dossier sur Webtrees j'ai le message suivant :

SQLSTATE (23000) : integrity constraint violation : 1062 Duplicate Entry 'F972-1' for key 1

Pourriez-vous m'aider à comprendre ce que cela signifie ?? L'import a été bloqué à 96 %. J'ai accès à mes autres dossiers sans problème.
Merci d'avance pour votre aide.
Françoise

Hello,

After importing a file on Webtrees I have the following message:

SQLSTATE (23000): integrity constraint violation: 1062 Duplicate Entry 'F972-1' for key 1

Could you help me understand what it means ?? The import was blocked at 96%. I have access to my other files without problem.
Thank you in advance for your help.
Françoise

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

SQLSTATE 23000 BLOCAGE 1 week 41 minutes ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
The error message suggests that your GEDCOM file contains 2 records with the same ID: F972

Upper/lower case is ignored, so you might have f972 and F972.

Maybe open the GEDCOM file with a text editor and search for lines that begine "0 @F972@".
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.

SQLSTATE 23000 BLOCAGE 1 week 38 minutes ago #3

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
OK. I'll try and keep you posted. Thank you for your quick answer.

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

SQLSTATE 23000 BLOCAGE 5 days 23 hours ago #4

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
Yes I found a line : 0 @972@ FAM
I suppress that line and see what happens !
Then I will tell you.

Is there a place where I can find the meaning of the codes (for example) : 1 FAMC, FAMS or FAM, etc... ??

Thank you, merci
Françoise

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

SQLSTATE 23000 BLOCAGE 5 days 22 hours ago #5

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
> Yes I found a line : 0 @972@ FAM

One line - or many lines?

The error message says you have more than one.

> I suppress that line and see what happens !

If you delete this line, then you must also delete all the lines beginning 1-9 that follow it.

> Is there a place where I can find the meaning of the codes (for example) : 1 FAMC, FAMS or FAM, etc... ??

webtrees.net/downloads/gedcom-551.pdf
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.

SQLSTATE 23000 BLOCAGE 5 days 22 hours ago #6

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
I send you a copy of the file. I think that I must delete all the lines beginning wiht the F972 and ending at "Jean-Paul", just before F973 ?
Thank you for the link to the codes.
Attachments:

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

SQLSTATE 23000 BLOCAGE 5 days 22 hours ago #7

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
Sorry the attachment is not good… maybe this time !

Attachments:

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

SQLSTATE 23000 BLOCAGE 5 days 21 hours ago #8

  • bertkoor
  • bertkoor's Avatar
  • Offline
  • Gold
  • Gold
  • Greetings from Utrecht, Holland
  • Posts: 1934
The attachment shows one occurrence of "0 @972@ FAM", which should be OK.
Do you have a second occurrence of "0 @972@ FAM" in the import file?
Because only that would trigger the error...
stamboom.BertKoor.nl runs on webtrees v1.7.13

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

Last edit: by bertkoor.
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: 

SQLSTATE 23000 BLOCAGE 5 days 21 hours ago #9

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
No, it is the only one. I just have "1 FAMS @972@" and "1 FAMC @972@"

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

SQLSTATE 23000 BLOCAGE 5 days 17 hours ago #10

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
OK. This does not really make sense.

The only cause of the error is if you have two records @F972@

But you say you only have one.

If you try to import the GEDCOM file again, do you get the same error?
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.

SQLSTATE 23000 BLOCAGE 5 days 1 hour ago #11

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
Bonjour,

For information, our gedcom contains 146,700 lines and 5,343 individuals.


Chronology of the problem: We have a main genealogy called BB. We have a genealogy called TEST which allows us to test modifications to be made on BB. We exported BB and then imported into TEST. We made the modifications in TEST then the result being satisfactory we exported it then imported in BB and it is at this moment that the problem appeared on BB. The gedcom still works correctly on TEST. Since it is impossible for us to import a gedcom on BB.


- According to the imported file on BB (from previous exports) we have a problem on a different line and with a different% import. We tried to import the same file several times: different error each time.

1 / Starting from the initial file which was problematic, we deleted a single line (n ° 144245) which included the 0 FAM972 which we have been talking about from the start. We only had one line 0 FAM972.

Blocking message after import: 1062 Duplicate Entry 'F958-1' for key 1 (hangs at 98.4%)

FYI, here too we have only one line 0 @ F958 @ FAM

Yesterday after the same maneuver, the message was: duplicate entry '1-M10' for key 1


2 / When we look at the files there is no duplicate, except several lines for FAM: FAMC and FAMS, which seems normal to me


3 / We have imported on another genealogy the gedcom "before problem" and it works correctly. We have not tried to import the "problematic" gedcom on a new genealogy.

I hope that my explanations are understandable. Thank you for your answer.
And thank you Google trad !

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

SQLSTATE 23000 BLOCAGE 5 days 1 hour ago #12

  • nwagers
  • nwagers's Avatar
  • Away
  • New
  • New
  • Posts: 22
Did you export from another software or did you export from webtrees?

The first step I would try, is to use a GEDCOM validator to see if it is a problem with the file or with webtrees. Here is an online validator: ged-inline.elasticbeanstalk.com/validate

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

SQLSTATE 23000 BLOCAGE 5 days 58 minutes ago #13

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
We Always use webtrees to export or import.
I"ll try with my "bad" gedcom to see if there is a pb… Thanks for the link. I tell you the result.

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

SQLSTATE 23000 BLOCAGE 5 days 29 minutes ago #14

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
46 pages !!!! I send you only the 1st page. Tell me if you want more...

This browser does not support PDFs. Please download the PDF to view it: Download PDF

Attachments:

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

SQLSTATE 23000 BLOCAGE 5 days 27 minutes ago #15

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
Sorry I Don't know how to send files….

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

SQLSTATE 23000 BLOCAGE 4 days 20 hours ago #16

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
> According to the imported file on BB (from previous exports) we have a problem on a different line and with a different% import. We tried to import the same file several times: different error each time.

Do you have the "manage trees" screen open on more than one computer?
webtrees *should* detect this (and give a different error message).
But if that isn't working, then perhaps the duplicates come from trying to import twice at the same time?

Tell me about your database?
MySQL? Postgres? Sqlite? Which version?

Can you let me see the problem?
e.g. give me an admin account, send me a copy of the GEDCOM file, and tell me which tree to import it into?
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.

SQLSTATE 23000 BLOCAGE 4 days 47 minutes ago #17

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
Hello, thank you for your answer.
My data base is MySQL, hosted by Free.
I totally agree to let you see the problem directly. Explain to me how to do this because I think we can only have one Admin on Webtrees?
No, we do not import at the same time. I am Site Admin and my cousin Jean-Paul (JP) is BB and TEST manager. I have not been working on these two trees for a long time. Only JP did it.
Thank you for your reply.

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

SQLSTATE 23000 BLOCAGE 2 days 16 hours ago #18

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13196
> Explain to me how to do this because I think we can only have one Admin on Webtrees?

You can have many admins on a site.

Email me at This email address is being protected from spambots. You need JavaScript enabled to view it.
Tell me the URL of your site.
I will register an account.
You must approve the account, and make it an administrator.
When we are finished, you can delete the account.
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.

SQLSTATE 23000 BLOCAGE 2 hours 17 minutes ago #19

  • fam37
  • fam37's Avatar Topic Author
  • Offline
  • New
  • New
  • Posts: 18
OK. I have sent you all the informations on your mail box.

Françoise

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

  • Page:
  • 1
Powered by Kunena Forum