Question Statistic page - Marriage counter

Dear all,

I updated some marriage locations directly on the DB, but I do not see the statistic page "Other" updated with the new information. Is there any counter that is updated on insertion that I need to take care of?

I am referring to the statistics of the marriage locations on tab Other for the statistic page.

Thanks
Federico

> I updated some marriage locations directly on the DB

What exactly did you do?

I updated them via the phpmyadmin web console: on the table wt_families I updated the f_gedcom field, in particular the PLAC value for some records.

If I do the search I see as a result what I expect, but nothing on the statistic page

The statistics aren't created from those tables.

There are many other tables (wt_link, wt_date, wt_name) that are created from wt_families, etc.

These are populated when the data is saved (edited or imported).

I would never update the database like you did. Too many interlinked tables, and too much scope for mistakes.

I suggest you export your data to a GEDCOM file, and re-import it.

(This will include the edits you made in wt_families).

This will regenerate all the other tables.

Ok thanks, this is was I supposed.

What about re-importing the GEDCOM file? Should I just export and re-import?
Will the data be automatically overwritten based on IDs ?

Thanks
Federico

Sorry, I found by myself the answer to my question, just looking at the Import Gedcom function within the control panel

Thanks
Regards
Federico