Before asking for help please read "How to request help" by clicking on that tab above here.
  • Page:
  • 1

TOPIC:

Integrity constraint violation: 1062 Duplicate entry 2 weeks 2 days ago #1

  • xilef
  • xilef's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 68
Today I transferred from webtrees V. 1.7.17 to V. 2.0.10. In version 2.0.10 I could only see the errors in the photos. Example:
SQLSTATE [23000]: Integrity constraint violation: 1062 Duplicate entry '1-M10' for key 'PRIMARY' (SQL: insert into `wt_media` (` m_id`, `m_file`,` m_gedcom`) values (M10, 1, 0 @ M10 @ OBJE 1 FILE Kaete_Pries.JPG 2 FORM jpeg 3 TYPE photo 1 _PRIM Y 1 CHAN 2 DATE 08 MAR 2008 3 TIME 18:54:07 1 _UID E263C00356374FE6867BA8D84AB8EDBEF8C2)). In September I was still able to work a little with version 2.0.10. I was not satisfied with that and stayed with the webtrees version V. 1.7.17.
Karl
webtrees 1.7.17
https.//www.stammbaum-staeck.de/Webtrees

webtrees V2.07
www.stammbaum-staeck.de/webtrees/
PHP Version 7.2.30
MySql 5.5.32

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

Integrity constraint violation: 1062 Duplicate entry 2 weeks 2 days ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13892
What were you doing when the error occurred?

If you were importing a GEDCOM file, did you select the "keep media objects" option?
If so, and your GEDCOM file contains media objects, then this error is expected.
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.

Integrity constraint violation: 1062 Duplicate entry 2 weeks 1 day ago #3

  • xilef
  • xilef's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 68
If you imported a GEDCOM file, did you choose the Keep Media Assets option? Yes

If it does and your GEDCOM file contains media objects, this error is expected. Ok what do i have to do?
Karl
webtrees 1.7.17
https.//www.stammbaum-staeck.de/Webtrees

webtrees V2.07
www.stammbaum-staeck.de/webtrees/
PHP Version 7.2.30
MySql 5.5.32

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

Integrity constraint violation: 1062 Duplicate entry 2 weeks 1 day ago #4

  • Sir Peter
  • Sir Peter's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 66
Try to import WITHOUT keeping the media assets.
Peter

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

Integrity constraint violation: 1062 Duplicate entry 2 weeks 1 day ago #5

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 13892
This options exists for one purpose.

* you edit your data using a desktop application and transfer to webtrees via GEDCOM
* you add media objects in webtrees
* your desktop application does not support media objects (and deletes them if they exist).
* you want to combine the edits from the desktop program (without media) with the media added in webtrees.
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.

  • Page:
  • 1
Powered by Kunena Forum