- Posts: 342
Question Duplicate entry on github 5198d3b site
- meliza
- Topic Author
- Offline
- Senior Member
Less
More
9 years 2 months ago #1
by meliza
webtrees 1.8.0-dev at amitys.com/webtrees - php 5.6.29 - mysql 5.0.11-dev
Duplicate entry on github 5198d3b site was created 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
[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
9 years 1 month ago #2
by fisharebest
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
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.