Bienvenue, Invité
Nom d'utilisateur : Mot de passe :
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

SUJET :

SQLSTATE 23000 BLOCAGE il y a 1 semaine 56 minutes #1

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

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

SQLSTATE 23000 BLOCAGE il y a 1 semaine 33 minutes #2

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 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 - 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.

SQLSTATE 23000 BLOCAGE il y a 1 semaine 30 minutes #3

OK. I'll try and keep you posted. Thank you for your quick answer.

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 23 heures #4

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

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 22 heures #5

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 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 - 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.

SQLSTATE 23000 BLOCAGE il y a 5 jours 21 heures #6

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.
Pièces jointes :

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 21 heures #7

Sorry the attachment is not good… maybe this time !

Pièces jointes :

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 21 heures #8

  • bertkoor
  • Portrait de bertkoor
  • Hors Ligne
  • Gold
  • Gold
  • Greetings from Utrecht, Holland
  • Messages : 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

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

Dernière édition: par bertkoor.
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 :

SQLSTATE 23000 BLOCAGE il y a 5 jours 21 heures #9

No, it is the only one. I just have "1 FAMS @972@" and "1 FAMC @972@"

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 17 heures #10

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 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 - 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.

SQLSTATE 23000 BLOCAGE il y a 5 jours 1 heure #11

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 !

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 54 minutes #12

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

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 49 minutes #13

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.

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 20 minutes #14

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

Pièces jointes :

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

SQLSTATE 23000 BLOCAGE il y a 5 jours 19 minutes #15

Sorry I Don't know how to send files….

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

SQLSTATE 23000 BLOCAGE il y a 4 jours 20 heures #16

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 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 - 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.

SQLSTATE 23000 BLOCAGE il y a 4 jours 38 minutes #17

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.

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

SQLSTATE 23000 BLOCAGE il y a 2 jours 15 heures #18

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrator
  • Administrator
  • Messages : 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 Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser.
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 - 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.

SQLSTATE 23000 BLOCAGE il y a 2 heures 8 minutes #19

OK. I have sent you all the informations on your mail box.

Françoise

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

  • Page :
  • 1
Propulsé par Kunena