Web based family history software

Question Duplicate entry on github 5198d3b site

  • meliza
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
9 years 2 months ago #1 by meliza
I see in my github code tree site error-log
[13-Jan-2015 18:31:18 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I790-3' for key 'PRIMARY'' in /home/meliza/public_html/tree/webtrees/library/WT/DBStatement.php:83
Stack trace:
#0 /home/meliza/public_html/tree/webtrees/library/WT/DBStatement.php(83): PDOStatement->execute()
#1 /home/meliza/public_html/tree/webtrees/includes/functions/functions_import.php(670): WT_DBStatement->execute(Array)
#2 /home/meliza/public_html/tree/webtrees/includes/functions/functions_import.php(1129): import_record('0 @I790@ INDI\n1...', '3', true)
#3 /home/meliza/public_html/tree/webtrees/includes/functions/functions_import.php(1047): update_record('0 @I790@ INDI\n1...', '3', false)
#4 /home/meliza/public_html/tree/webtrees/library/WT/GedcomRecord.php(1219): accept_all_changes('I790', '3')
#5 /home/meliza/public_html/tree/webtrees/library/WT/GedcomRecord.php(1139): WT_GedcomRecord->updateFact(NULL, '1 FAMS @F322@', true)
#6 /home/meliza/public_html/tree/webtrees/edit_interface.p in /home/meliza/public_html/tree/webtrees/library/WT/DBStatement.php on line 83
[13-Jan-2015 18:31:19 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I790-3-0' for key 'PRIMARY'' in /home/meliza/public_html/tree/webtrees/library/WT/DBStatement.php:83
Stack trace:
#0 /home/meliza/public_html/tree/webtrees/library/WT/DBStatement.php(83): PDOStatement->execute()
#1 /home/meliza/public_html/tree/webtrees/includes/functions/functions_import.php(947): WT_DBStatement->execute(Array)
#2 /home/meliza/public_html/tree/webtrees/includes/functions/functions_import.php(675): update_names('I790', '3', Object(WT_Individual))
#3 /home/meliza/public_html/tree/webtrees/includes/functions/functions_import.php(1129): import_record('0 @I790@ INDI\n1...', '3', true)
#4 /home/meliza/public_html/tree/webtrees/includes/functions/functions_import.php(1047): update_record('0 @I790@ INDI\n1...', '3', false)
#5 /home/meliza/public_html/tree/webtrees/library/WT/GedcomRecord.php(1219): accept_all_changes('I790', '3')
#6 /home/meliza/public_html/tree/webtrees/library/WT/ in /home/meliza/public_html/tree/webtrees/library/WT/DBStatement.php on line 83

I see now in my production site pending changes
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I685-1-0' for key 'PRIMARY'' in /home/meliza/public_html/webtrees/library/WT/DBStatement.php:83 Stack trace: #0 /home/meliza/public_html/webtrees/library/WT/DBStatement.php(83): PDOStatement->execute() #1 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(947): WT_DBStatement->execute(Array) #2 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(675): update_names('I685', '1', Object(WT_Individual)) #3 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(1129): import_record('0 @I685@ INDI\n1...', '1', true) #4 /home/meliza/public_html/webtrees/edit_changes.php(110): update_record('0 @I685@ INDI\n1...', '1', false) #5 {main} thrown in /home/meliza/public_html/webtrees/library/WT/DBStatement.php on line 83

In the production site error-log I see for today
[27-Jan-2015 10:08:19 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I25044-1-0' for key 'PRIMARY'' in /home/meliza/public_html/webtrees/library/WT/DBStatement.php:83
Stack trace:
#0 /home/meliza/public_html/webtrees/library/WT/DBStatement.php(83): PDOStatement->execute()
#1 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(947): WT_DBStatement->execute(Array)
#2 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(675): update_names('I25044', '1', Object(WT_Individual))
#3 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(1129): import_record('0 @I25044@ INDI...', '1', true)
#4 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(1047): update_record('0 @I25044@ INDI...', '1', false)
#5 /home/meliza/public_html/webtrees/action.php(61): accept_all_changes('I25044', '1')
#6 {main}
thrown in /home/meliza/public_html/webtrees/library/WT/DBStatement.php on line 83
[27-Jan-2015 11:10:39 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I38532-1' for key 'PRIMARY'' in /home/meliza/public_html/webtrees/library/WT/DBStatement.php:83
Stack trace:
#0 /home/meliza/public_html/webtrees/library/WT/DBStatement.php(83): PDOStatement->execute()
#1 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(670): WT_DBStatement->execute(Array)
#2 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(1129): import_record('0 @I38532@ INDI...', '1', true)
#3 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(1047): update_record('0 @I38532@ INDI...', '1', false)
#4 /home/meliza/public_html/webtrees/action.php(61): accept_all_changes('I38532', '1')
#5 {main}
thrown in /home/meliza/public_html/webtrees/library/WT/DBStatement.php on line 83
[27-Jan-2015 12:03:04 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'I685-1-0' for key 'PRIMARY'' in /home/meliza/public_html/webtrees/library/WT/DBStatement.php:83
Stack trace:
#0 /home/meliza/public_html/webtrees/library/WT/DBStatement.php(83): PDOStatement->execute()
#1 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(947): WT_DBStatement->execute(Array)
#2 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(675): update_names('I685', '1', Object(WT_Individual))
#3 /home/meliza/public_html/webtrees/includes/functions/functions_import.php(1129): import_record('0 @I685@ INDI\n1...', '1', true)
#4 /home/meliza/public_html/webtrees/edit_changes.php(110): update_record('0 @I685@ INDI\n1...', '1', false)
#5 {main}
thrown in /home/meliza/public_html/webtrees/library/WT/DBStatement.php on line 83

I keep getting Duplicate entry Fatal errors almost daily.

What could cause these errors?
How can I get rid of them?

Meliza

webtrees 1.8.0-dev at amitys.com/webtrees - php 5.6.29 - mysql 5.0.11-dev

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

  • fisharebest
  • Away
  • Administrator
  • Administrator
More
9 years 1 month ago #2 by fisharebest
Replied by fisharebest on topic Duplicate entry on github 5198d3b site

What could cause these errors?


Pressing F5 ?

Trying to accept the same change twice at the same time might possibly cause it.

You don't say whether the action was sucessful. You can compare the "new" gedcom data in wt_change with the gedcom data in the record.

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

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

Powered by Kunena Forum
}