If you need to upgrade your PGV installation, then hopefully you will also consider that you can conveniently move to webtrees with our PGV-to-webtrees wizard. It will move ALL your users, news, favorites and family trees to webtrees in a matter of minutes.

TOPIC: Database Error in Migration from PGV

Database Error in Migration from PGV 1 year 5 months ago #1

  • grobyx
  • grobyx's Avatar
  • Offline
  • New
  • Posts: 3
Hello
I want to migrate from PhpGedView 4.2.4 to webtrees 1.7.9. The setup has worked and I use the same database.
After starting the migration, I always get the same error at about 81%
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-M3' for key 'PRIMARY'
I have already checked with all users the mail addresses and with two missing mail addresses, these both PGV, as well as registered in the database.
I could not find another error. Also, the expression was not found in the PGV tables.
I have already repeated the installation and migration 4 times, but always get the same error in the same place.
Can anybody help me further?
Last Edit: 1 year 5 months ago by grobyx. Reason: spelling
The administrator has disabled public write access.

Database Error in Migration from PGV 1 year 5 months ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
You have two media objects with the same internal unique ID (called an "XREF") - both are called "M3" (or "m3").

Perhaps look in the PGV media table (pgv_media??) in the database and look for these duplicates?

Perhaps export, and then import the data on PGV before migrating to webtrees? This can fix many problems.
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.

Database Error in Migration from PGV 1 year 5 months ago #3

  • grobyx
  • grobyx's Avatar
  • Offline
  • New
  • Posts: 3
Thanks for the hint, I will check the media table.
For the installation of webtrees, I have exported the PGV database and imported into a new database. Then I connected PGV to this new database.
The errors in the media table were apparent not fixed.
The administrator has disabled public write access.

Database Error in Migration from PGV 1 year 5 months ago #4

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 10500
> For the installation of webtrees, I have exported the PGV database and imported into a new database. Then I connected PGV to this new database.

Sorry, I meant export from PGV to a GEDCOM file, and then import this GEDCOM file back into PGV.
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.

Database Error in Migration from PGV 1 year 5 months ago #5

  • grobyx
  • grobyx's Avatar
  • Offline
  • New
  • Posts: 3
Oh, ok. Thank you, I will try.
The administrator has disabled public write access.
Moderators: makitso
Powered by Kunena Forum