This Help forum is for issues relates to the latest release (1.7.5). For issues related to beta or github version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."

TOPIC: [SOLVED] Integrity contraint violation - what to do?

Integrity contraint violation - what to do? 1 year 4 months ago #1

  • HonkXL
  • HonkXL's Avatar
  • Offline
  • Junior
  • Posts: 142
Hi,

an other user did some changes. I accepted them. Then I got this error:

/var/www/httpdocs/webtrees/app/Statement.php:82 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I3922-1-0' for key 'PRIMARY'
#0 /app/Statement.php:82 PDOException("SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I3922-1-0' for key 'PRIMARY'")
#1 /app/Functions/FunctionsImport.php:955 execute([array])
#2 /app/Functions/FunctionsImport.php:657 updateNames('I3922', 1, [Individual I3922@1])
#3 /app/Functions/FunctionsImport.php:1151 importRecord('0 @I3922@ INDI
1 NAME Francisk…', [Tree], true)
#4 /edit_changes.php:111 updateRecord('0 @I3922@ INDI
1 NAME Francisk…', '1', false)

What does this error mean and can I ignore this, or do I have to care about it?
My homepage: www.weiland24.de
My webtrees: webtrees.weiland24.de
The administrator has disabled public write access.

Integrity contraint violation - what to do? 1 year 4 months ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10823
From the Control panel, Family trees, Changes log, you should be able to see the old/new versions of the GEDCOM data for this record.

Is there anything unusual about the NAME records?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Integrity contraint violation - what to do? 1 year 4 months ago #3

  • HonkXL
  • HonkXL's Avatar
  • Offline
  • Junior
  • Posts: 142
Hi,

the only entry I see is:
Create: INDI I3922

It was a new person...

When I look to the name, the only special is that there is a dot in the Family name:
M. Farkas

But I have this on other names, too.
My homepage: www.weiland24.de
My webtrees: webtrees.weiland24.de
The administrator has disabled public write access.

Integrity contraint violation - what to do? 1 year 4 months ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10823
> It was a new person...

Is it possible that you accepted this change twice at the same time. Perhaps the server was slow so you clicked twice, and both requests were sent together?
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Integrity contraint violation - what to do? 1 year 4 months ago #5

  • HonkXL
  • HonkXL's Avatar
  • Offline
  • Junior
  • Posts: 142
I think not. I accepted it on my iPad. There it is hard to make a double click in Safari. But it took a longer time than usual to get the changes accepted. Maybe my iPad sent two requests?
My homepage: www.weiland24.de
My webtrees: webtrees.weiland24.de
The administrator has disabled public write access.

Integrity contraint violation - what to do? 1 year 4 months ago #6

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10823
If you edit the record, and accept the changes, then webtrees will re-run the code that errored.

If you don't see an error, then everything is OK.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.

Integrity contraint violation - what to do? 1 year 4 months ago #7

  • HonkXL
  • HonkXL's Avatar
  • Offline
  • Junior
  • Posts: 142
ok. It works without error when I change anything. So I think there was a double request from my iPad. Thank You!
My homepage: www.weiland24.de
My webtrees: webtrees.weiland24.de
The administrator has disabled public write access.

[SOLVED] Integrity contraint violation - what to do? 1 year 4 months ago #8

  • HonkXL
  • HonkXL's Avatar
  • Offline
  • Junior
  • Posts: 142
Problem solved.
My homepage: www.weiland24.de
My webtrees: webtrees.weiland24.de
The administrator has disabled public write access.
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: 
Powered by Kunena Forum