Male and Female descendant lines and Parental Lines

March 27, 2016

I have placed a new mod at

and would be most gratefull when one of the programming experts would have the time to modify the mod for TNG 11

March 27, 2016

The link for the existing v9/v10 mod on the wiki page is invalid. Without being able to see that mod it is not possible to tell what changes are required to make it compatible with TNG v11.

March 27, 2016

Sorry, the link is working now

March 27, 2016

Probably the first thing that should be fixed is to agree on a mod name:

The link above uses

2 hours ago, Henri Textor said:

Male and Female descendant lines and Parental Lines

The TNG Wiki uses Lines Sides InterestingPeople
The mod internal name is
Quote

%name:Add New Menu Items%

The %name: and TNG Wiki article name should be the same and any reference to the mod should use the same name to avoid confusion.

March 27, 2016

How have you managed to install the mod? There are location and syntax errors that would be flagged by Mod Manager:

Language file insert locations would fail on many sites and should use the php closing tag
the 'description' is not correctly terminated.

Also the same target text is used twice ($vitalinfo = getVitalDates( $crow );) which could cause a problem for uninstalling the mod.

March 27, 2016

I have created a version (attached) compatible/installs with TNGv11. At first I thought that no additional sub-menu items appear with the Descendants tab. I then discovered that they appear when the 'Text' option is selected (or configured as default in 'Admin > Config > Chart Settings > Descendancy Chart'). This needs to be included in installation instruction on the wiki page.

However, this version results in the following error when 'Interesting Descendants' is selected:

Fatal error: Call to undefined function dbExecuteQuery() in /homepages/42/d42111854/htdocs/genealogy/tngdblib.php on line 69

There is nothing on the wiki page about how the mod identifies 'Interesting Descendants'.

The only significant change I have made for the previous version of the mod is for the location starting at line 205 in the cfg file. TNGv11 introduced a new variable ($newdab) that needed to be accommodated in this section of descendtext.php.

male_and_female_lines_v11.0.0.2.cfg

March 27, 2016

The fatal error results from the following code in the mod:

===================================================
%target:tngdblib.php%
===================================================

%location:%
//Get most info for children in a family
function getChildrenData($tree, $familyID) {
%end:%

%insert:before%
function getInfoPersonData($tree, $personID) {
    global $people_table, $events_table, $eventtypes_table;

		$query = "SELECT info
		FROM $people_table LEFT JOIN $events_table on $people_table.personID=$events_table.persfamid AND $events_table.gedcom=$people_table.gedcom LEFT JOIN $eventtypes_table ON $events_table.eventtypeid=$eventtypes_table.eventtypeid
	  WHERE $eventtypes_table.description=\"IMPO\" AND $people_table.personID=\"$personID\" AND $people_table.gedcom = \"$tree\"" ;

    return dbExecuteQuery($query);
}

%end:%

March 28, 2016

Ken, I will take care for the name problem as soon as possible

March 28, 2016

Hiraeth

First of all thanks for your interest

Thanks for noticing that Chart Settings >> Descendancy Chart should be set to "Text Only" and the missing description of the IMPO-event

I have changed Lines Sides InterestingPeople on TNG Wiki

The mod is installed and working on TNG10 and gives a location/target error in the modmanager of TNG11

I changed the location in the original mod and got similar error messages as you show

I installed your mod and got alltogether following error messages

Father's paternal line and mother's maternal line
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, object given in /customers/7/0/c/geneagraphie.com/httpd.www/members/lines.php on line 232
Warning: mysql_free_result() expects parameter 1 to be resource, object given in /customers/7/0/c/geneagraphie.com/httpd.www/members/lines.php on line 243
Warning: Cannot modify header information - headers already sent by (output started at /customers/7/0/c/geneagraphie.com/httpd.www/members/lines.php:232) in /customers/7/0/c/geneagraphie.com/httpd.www/members/genlib.php on line 57

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, object given in /customers/7/0/c/geneagraphie.com/httpd.www/members/lines.php on line 52
Warning: mysql_free_result() expects parameter 1 to be resource, object given in /customers/7/0/c/geneagraphie.com/httpd.www/members/lines.php on line 66
Warning: mysql_query(): Access denied for user ''@'10.246.74.25' (using password: NO) in /customers/7/0/c/geneagraphie.com/httpd.www/members/lines.php on line 77
Warning: mysql_query(): A link to the server could not be established in /customers/7/0/c/geneagraphie.com/httpd.www/members/lines.php on line 77
Cannot execute query: SELECT husband, wife FROM tng_families WHERE familyID = "" AND gedcom = "1"

Descendants
Male lines/Female lines
Fatal error: Cannot use object of type mysqli_result as array in /customers/7/0/c/geneagraphie.com/httpd.www/members/descendtext.php on line 96

Imteresting People
Fatal error: Call to undefined function dbExecuteQuery() in /customers/7/0/c/geneagraphie.com/httpd.www/members/tngdblib.php on line 67

The Link Queue Descendants should be removed of course

I am no sql expert and I have only minimal programming knowledge, so I don't have any idea in the moment what to change in the original mod.

I hoped to finf an advanced member who would be able to do the job

Diolch, Iechyd da!

March 28, 2016

I have changed all instances of 'mysql_' to 'tng_' as required for TNGv10.1+ (see TNG Wiki article). The errors for 'Interesting People' (tngdblib.php) and 'Male and Female Descendants' persist.

The former is no doubt caused by 'hard-coding' the event type description ('IMPO') of the 'Interesting People' data.

The latter it seems is caused by missing 'curly braces' ( {...} ) in the following 'insert' code:

%location:%
					$vitalinfo = getVitalDates( $crow );
%end:%

%insert:before%
				if($displayoption=="interesting")
					$result3 = tng_fetch_assoc(getInfoPersonData($tree, $crow['personID']));
					$crow[info] = $result3[info];
%end:%

In the attached new version the 'Queue Descendants' option has been disabled (commented out in the mod code). It now seems to require only a solution to the 'IMPO' problem. Maybe an editable value in Mod Manager would work, but I'm not sure how to implement that.

male_and_female_lines_v11.0.0.3.cfg

I have this installed and you can view this page as an example: http://www.katiandgraham.com/genealogy/descendtext.php?personID=I28&tree=kegcTree&generations=12

March 28, 2016

Many, many thanks.

I must wait until tomorrow to study your work my regret

Please note that the page on tng wiki will be renamed to

Male and Female Direct Lines

Regards

Hans

March 28, 2016

Hi Hiraeth

splendid job, it seems you are very close to the final solution

There are some errors. You will probably have noticed theem yourself but allow me to mention some of them

descendant male nd female lines are limited to 4

When clicking the family tab most other tabs disappear

I tried intereting descendants and got the before mentioned error message

Diolch, Iechyd da!

March 28, 2016

The only error on my site that I have identified is with the 'Interesting People' (I don't use 'IMPO')

I don't have a problem with descendant male and female lines: see http://www.katiandgraham.com/genealogy/descendtext.php?personID=I160&tree=kegcTree&displayoption=all&generations=12

The family tab behaviour is new and correct in TNG v11. Check it from the above link (I have Group Sheet disabled).

Croeso i ti

March 28, 2016

If you click the Ancestor's tab and then the Parents Side, I get a recusrive loop error in the created lines.php file.

Quote

Father's paternal line and mother's maternal line

( ! ) Fatal error: Maximum function nesting level of '100' reached, aborting! in D:\wamp\www\tng\lines.php on line 156

Call Stack

# Time Memory Function Location

1 0.0398 863024 {main}( ) ..\lines.php:

2 0.0985 3256808 displayIndividual( ) ..\lines.php:290

3 0.0995 3266040 displayfather( ) ..\lines.php:91

4 0.1003 3272200 displayfather( ) ..\lines.php:156

5 0.1009 3278176 displayfather( ) ..\lines.php:156

6 0.1016 3284664 displayfather( ) ..\lines.php:156

March 28, 2016

Ken

I have been unable to generate such an error. Can you provide a link to the individual concerned. Or are you getting that error with all individuals?

March 29, 2016

Graham,

Mod is install only on my WampServer. I will install on a subdomain and send you the credentials is I can re-create the problem.

Edited: Mod is installed on a test subdomain now, but I am not able to recreate the problem. I was using my page, selecting the Ancestor tab and them selecting the Parent Sides. It never displayed any data and just returned the messages I posted above

March 29, 2016

Graham, Ken

I tried all links again and must admit I made interpretation errors (I hope to learn quick)

The family Tab works well, the male and female lines are also displayed correct, Parent sides looks splendid

Only Interesting people (IMPO event) doesn't work. Why don't we exclude this tool from this mod

It should be a seperate mod to my opinion, most users with small databases will most likely not be interested. Altough I would like to use this tool In my database, I didn't find the time last years to activate the IMPO event for much persons

I tried it out to show the line of the Princes/Fürsten zu Salm who have my private interest. Other male descendant are excluded. See TNG v10.0.1

http://geneagraphie.com/descendtext.php?personID=I10941&tree=1&displayoption=interesting&generations=12

Very much obliged

Hans

March 29, 2016

Ken, Graham

Ian Fettes had in the past some problems to get his mod working and added following timout.cfg to the modlist

I have no idea if this takes care for the error message using the link "interesting people"

My brain is working but not so quick anymore

%location:%
$textpart = "pedigree";
%end:%
%insert:after%
@set_time_limit(0);
%end:%

Cheers, Hans

March 29, 2016

16 hours ago, Ken Roy said:

If you click the Ancestor's tab and then the Parents Side, I get a recusrive loop error in the created lines.php file.

Hi Ken

I am wondering if it is some setting which is built into the WAMPServer which causes this problem. I noticed a similar problem with the Relationship display mod and with the relationship chart whenever I looked at relationships for someone with over 100 ancestors in my file. I always got the "Maximum function nesting level of '100' reached..." error. The problem always went away if I reduced the number generations that were searched for a relationship. It never happened on my public site nor does it ever happen with Uniform Server.

My guess is there is some kind of limit set somewhere in the WampServer that assumes a nesting level of 100 is an indication of a recursive loop. Once I came to that conclusion I never investigated beyond this to see if the limit could be changed.

Harold

March 30, 2016

Harold,

You might have a point there. The mod contained code within a function that call itself. I personally don't consider a function calling itself thus creating a loop a good programming technique but don't have time to re-engineer the mod especially since I will not likely use it. i did change the max iteration down from 100 to 30 generations. After all the TNG max gen is lower than that.

Graham has been posted the Male and Female Descendant and Parent Ancestor Lines mod for TNG V11.

October 16, 2017

Hi,

I had the same error. I could fix it on my Wampserver installation. See this post:

Relationship Display Mod ---Function Nest Overflow

Dan

( ! ) Fatal error: Maximum function nesting level of '100' reached, aborting! in D:\wamp\www\tng\lines.php on line 156
Call Stack
#	Time	Memory	Function	Location
1	0.0398	863024	{main}( )	..\lines.php:
2	0.0985	3256808	displayIndividual( )	..\lines.php:290
3	0.0995	3266040	displayfather( )	..\lines.php:91
4	0.1003	3272200	displayfather( )	..\lines.php:156
5	0.1009	3278176	displayfather( )	..\lines.php:156
6	0.1016	3284664	displayfather( )	..\lines.php:156

Male and Female descendant lines and Parental Lines

Recommended Posts

Henri Textor

Link to comment

Share on other sites

Hiraeth

Link to comment

Share on other sites

Henri Textor

Link to comment

Share on other sites

Ken Roy

Link to comment

Share on other sites

Hiraeth

Link to comment

Share on other sites

Hiraeth

Link to comment

Share on other sites

Hiraeth

Link to comment

Share on other sites

Henri Textor

Link to comment

Share on other sites

Henri Textor

Link to comment

Share on other sites

Hiraeth

Link to comment

Share on other sites

Henri Textor

Link to comment

Share on other sites

Henri Textor

Link to comment

Share on other sites

Hiraeth

Link to comment

Share on other sites

Ken Roy

Link to comment

Share on other sites

Hiraeth

Link to comment

Share on other sites

Ken Roy

Link to comment

Share on other sites

Henri Textor

Link to comment

Share on other sites

Henri Textor

Link to comment

Share on other sites

crashar

Link to comment

Share on other sites

Ken Roy

Link to comment

Share on other sites

Dan Cote

Link to comment

Share on other sites

Join the conversation

TNG

Activity

Browse