This Help forum is for issues relates to the latest release (1.7.10/11/12). For issues related to development versions please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."

TOPIC: SQLSTATE[23000]: Integrity constraint violation:..

SQLSTATE[23000]: Integrity constraint violation:.. 2 weeks 1 day ago #1

  • maikl11
  • maikl11's Avatar
  • Offline
  • New
  • Posts: 3
Hello

If I upload my GEDCOM file with pictures, then I always get this error message:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-M1' for key 'PRIMARY'

The upload without pictures...... perfect!


Can anybody help me?

Michael
Attachments:
Last Edit: 2 weeks 1 day ago by maikl11.
The administrator has disabled public write access.

Error 1906b87b226f1b752a8a51ef99b311​17 2 weeks 1 day ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 11118
Does your GEDCOM file contain more than one media record "M1".

Open the GEDCOM file with a text editor, and search for lines that contain
0 @M1@ OBJE

or
0 @m1@ OBJE
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.

SQLSTATE[23000]: Integrity constraint violation: 1 2 weeks 1 day ago #3

  • maikl11
  • maikl11's Avatar
  • Offline
  • New
  • Posts: 3
Thank you Greg...

but now I become this info

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-M2' for key 'PRIMARY'

but I dont find 1-M2 in my file.....

Its horror....


(I work with FTM2017)
Last Edit: 2 weeks 23 hours ago by maikl11.
The administrator has disabled public write access.

SQLSTATE[23000]: Integrity constraint violation: 1 2 weeks 21 hours ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 11118
> but I dont find 1-M2 in my file.....

Ignore the "1-".

Do you have "@M2@" ?
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.
Powered by Kunena Forum