Posts

Attempt to run Facts and Events > Custom Fact > Type: Common ancestor (or any other type of custom fact) and no results. (The results should be the records that I’ve so far found with Relationship  info after the 1 NAME). Is this too a server capacity issue?

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

I’ve been looking at this, and can’t see what the problem is. Similar searches work OK on other sites I have access to.

Server resources is a possibility, but I can’t see any evidence of that. I tries a general search (using Search menu) for “Common ancestors” which ‘should’ find all those FACT entries PLUS any others where that term just appeared in a note or source or anywhere. It only found 378 individuals, which is not great number. So I suspect it is some other problem completely.

What I would like to try is running the SQL database query that search uses directly on the database itself. Any chance you could organise access to the database for A&D temporarily?

Nigel
My personal kiwitrees site is www.our-families.info

Will review how I did the setup previously later today (too tired to think :). The two Custom Facts in question that I know I use are “Common ancestor” and “Relationship”. (I have FACT as managers so restrict use of it if I want people to see)

Another matter if you are in the SQL — I previously asked about a stuck tree. You did reply but I didn’t follow through. (Chicken). It was “The Kennedys” that’s in with my A-D. Could you remove it please? It doesn’t belong there.

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

Okay, with images out of the way (I presume), did anything you saw answer why I can’t run F&E > Custom Fact > Common Ancestor?

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

Yes. Confirmed it is a resource issue, but still working on ways to improve performance.
For most sites it only happens on common facts like BIRT  For your data FACT is more common than birth! More than 11000 individuals have one or more. Creating the list is quick and easy, but preparing them for display, sorted, filtered, duplicates removed, privacy checked, etc is the problem.

For now try adding further limits to the query, such as date and or place.

Nigel
My personal kiwitrees site is www.our-families.info

Not good news!  Date/Place Filters don’t apply. I *think* there’s just over 500 so far with the FACT I’ve used. Not many with number of records I have but obviously takes far more than I imagined to report.

Trying to identify “core” family. Blood and marriage related. So far most are immediate to third/fourth ascending or descending relations. The ones kiwitrees identifies doesn’t have a “report” so created the custom fact. Others aren’t blood so identified in Reunion or Geni as connected.

Using F&E would allow me to sort on Details.

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

I think you must have lost count somewhere!! If I search the database for FACT tags with the TYPE “Relationship” there are 9,818 !!

Nigel
My personal kiwitrees site is www.our-families.info

YES, “Relationship” is huge. “Common Ancestor” isn’t.

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1

I might be able to improve it. But I’m not sure it will ever work with those numbers. Reports like that are a very inefficient solution for a web application.

The more dynamic Relationship chart is more appropriate for kiwitrees, and works well.

Nigel
My personal kiwitrees site is www.our-families.info

But the Relationship Chart is one to one  connection. I can’t view all. And it’s in chart form, not list which includes the Details part of the Fact. Which is why I ruled out using general search for “Common Ancestor”.

Of course, as a user, no idea what goes on behind scenes to make a report/list work. Seemed simple enough request to generate. Thought it was along the lines of showing Individuals where there could be large results.

What’s my alternatives for this endeavour?

----- [updated: 31Aug2023]

 Alter-Drukarsh connections |The Garelicks|Journal 3.3.12 -  PHP Version 8.1.17 - mySQL 8.1
The Royals |The Kennedys|The Gerrer Rabbis  3.3.12 -  PHP Version 8.1.17 - mySQL 8.1