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: Roll back changes

Roll back changes 2 months 23 hours ago #1

  • clivejo
  • clivejo's Avatar
  • Offline
  • New
  • Posts: 5
Hi folks,

One of my admins accidentally done a Search and Replace on the database and changed 138 Individuals and 5 Families . Is there an easy way to revert these changes, or will I have to manually go through and correct them?
Last Edit: 2 months 23 hours ago by clivejo.
The administrator has disabled public write access.

Roll back changes 2 months 22 hours ago #2

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 11102
> Is there an easy way to revert these changes

That depends on your definition of "easy".

Using SQL, you could

1) query the wt_change table to find these changes. (search by user ID and change timestamp).
2) join this to the individual table in an update query - to set the individual gedcom in the gedcom table to the "old" gedcom in the change table.
3) repeat for the family table.
4) export and import the GEDCOM file to rebuild all the search indexes.
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