Jump to content
TNG Community

MOD "Add DNA Test Results" - causes no connection to localhost

tobias.kemper

By tobias.kemper
in Code Discussion

 Share

Recommended Posts

tobias.kemper

tobias.kemper

Posted
Posted

Hello,

I am running TNG on my local system (Wamp64 local server). Yesterday, I have installed the "Add DNA Test Results" MOD - as far as I can use it, the MOD is great. I have started adding yDNA and mtDNA tests - everything ok.
But now I have tried to add an atDNA test. And now there is a problem: I have added one atDNA test. Now I want to edit the test (http://localhost:8080/tng/admin_edit_dna_test.php?testID=9) - but then my system is waiting for the localhost - and waiting - and waiting ...

And that's the end of it. After minutes of waiting, I only can stop the Wamp server and boot it again.

It seems that there is an issue with adding an atDNA test? Any ideas?

Best regards

Tobias A. Kemper

Link to comment
Share on other sites
Ken Roy

Ken Roy

Posted
Posted

Tobias,

Can you provide additional details?  such as which fields were entered, which check box were checked, etc.  I am able to enter the atDNA test and then edit it.

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

Ken,

I have tried different combinations of input. For example:

DNA Tests - add:

test type: atDNA

Test Number: 1111 [only for testing purposes]

Vendor: FTDNA

Date: 2014

Test Taker: I1

And save.

That's it. I cannot enter more information. When I want to edit the test, TNG starts looking for localhost - waiting - waiting - waiting. And I cannot click another menu entry. I must finish at least the browser tab and restart my local wamp server. The only thing what I can do then is to delete the test.

The problem is only with atDNA - mtDNA and yDNA works very well.

I am using the newest version of TNG. Might this be the reason for the problem?

Tobias

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

An addition: I really need to completely shutdown the server. Restarting only the 3 processes of the wamp server is not sufficient, only 2 of 3 are starting (I do not know which).
Tobias

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

Might this help?


 

( ! ) Fatal error: Maximum execution time of 120 seconds exceeded in C:\wamp64\www\TNG\begin.php on line 28
Call Stack
# Time Memory Function Location
1 0.0016 359000 {main}( ) ...\admin_edit_dna_test.php:0
2 0.0024 371976 include( 'C:\wamp64\www\TNG\begin.php' ) ...\admin_edit_dna_test.php:2
Link to comment
Share on other sites
Ken Roy

Ken Roy

Posted
Posted

What version of PHP are you using?  Are there any errors in the Apache Log or the PHP error log?

 

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

PHP 5.6.31

PHP error log:
[24-Feb-2018 15:10:54 UTC] PHP Fatal error:  Maximum execution time of 120 seconds exceeded in C:\wamp64\www\TNG\begin.php on line 28
[24-Feb-2018 15:10:54 UTC] PHP Stack trace:
[24-Feb-2018 15:10:54 UTC] PHP   1. {main}() C:\wamp64\www\TNG\admin_edit_dna_test.php:0
[24-Feb-2018 15:10:54 UTC] PHP   2. include() C:\wamp64\www\TNG\admin_edit_dna_test.php:2
[24-Feb-2018 15:10:54 UTC] PHP Fatal error:  Maximum execution time of 120 seconds exceeded in C:\wamp64\www\TNG\begin.php on line 28
[24-Feb-2018 15:10:54 UTC] PHP Stack trace:
[24-Feb-2018 15:10:54 UTC] PHP   1. {main}() C:\wamp64\www\TNG\admin_edit_dna_test.php:0
[24-Feb-2018 15:10:54 UTC] PHP   2. include() C:\wamp64\www\TNG\admin_edit_dna_test.php:2
[24-Feb-2018 15:10:54 UTC] PHP Fatal error:  Maximum execution time of 120 seconds exceeded in C:\wamp64\www\TNG\begin.php on line 28
[24-Feb-2018 15:10:54 UTC] PHP Stack trace:
[24-Feb-2018 15:10:54 UTC] PHP   1. {main}() C:\wamp64\www\TNG\admin_modhandler.php:0
[24-Feb-2018 15:10:54 UTC] PHP   2. include() C:\wamp64\www\TNG\admin_modhandler.php:13

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

I do not know how the lines are counted:

 

<?php
$cms = array();
if(isset($_GET['lang']) || isset($_GET['mylanguage']) || isset($_GET['language']) || isset($_GET['session_language']) || isset($_GET['rootpath'])) die("Sorry!");
$tngconfig = array();

if(strpos($_SERVER['SCRIPT_NAME'],"/admin_updateconfig.php") === FALSE)
    include("processvars.php");

include("subroot.php");
include_once("tngconnect.php");
include($tngconfig['subroot'] . "config.php");
$subroot = $tngconfig['subroot'] ? $tngconfig['subroot'] : $cms['tngpath'];

global $tmp;
include($subroot . "templateconfig.php");
$templatepfx = is_numeric($templatenum) ? "template" : "";
$templatepath = $templateswitching && $templatenum ? "templates/$templatepfx$templatenum/" : "";

if(isset($sitever))
    setcookie("tng_siteversion", $sitever, time()+31536000, "/");
else if(isset($_COOKIE['tng_siteversion']))
    $sitever = $_COOKIE['tng_siteversion'];
    
include_once("siteversion.php");
if(!$sitever)
    $sitever = getSiteVersion();

session_start();
$session_language = $_SESSION['session_language'];
$session_charset = $_SESSION['session_charset'];

$languages_path = "languages/";
include($cms['tngpath'] . "getlang.php");
$link = tng_db_connect($database_host,$database_name,$database_username,$database_password,$database_port,$database_socket);
?>
 

Link to comment
Share on other sites
Ken Roy

Ken Roy

Posted
Posted

I copied your above lines and pasted them in Notepad++

Line 28 is session_start();

so the question is why is "Sessions are blocking. session_start()"?

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

Now it returned this message: Problem with TNG,

Abfrage: SELECT p.lastname, p.famc, f.husband, f.wife FROM tng_people AS p LEFT JOIN tng_families AS f ON (p.famc = f.familyID AND p.gedcom = f.gedcom) WHERE p.personID = 'I6693' AND p.gedcom = 'Kemper'
 

This test in question was connected to I3383, not to I6693.

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

I have found: The problem with "session_start()" appears only when I shutdown the local server after minutes of waiting and when at least 2 TNG pages are open. 

Having only one page open (the DNA page), the message is: problem with 
SELECT p.lastname, p.famc, f.husband, f.wife FROM tng_people AS p LEFT JOIN tng_families AS f ON (p.famc = f.familyID AND p.gedcom = f.gedcom) WHERE p.personID = 'I6693' AND p.gedcom = 'Kemper'

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

It depends from the person connected to the test. I added another atDNA test associated to another person - there it works. Hmm. 

It seems to work if I connect the test to a person WITHOUT another yDNA / mtDNA test. It does not work if there is already another test for the same person. 

Link to comment
Share on other sites
Ken Roy

Ken Roy

Posted
Posted

Is there not anything that identifies what the problem is with the query?  like an error message or something identified as not defined?

 

Link to comment
Share on other sites
Ken Roy

Ken Roy

Posted
Posted
1 minute ago, tobias.kemper said:

It depends from the person connected to the test. I added another atDNA test associated to another person - there it works. Hmm. 

It seems to work if I connect the test to a person WITHOUT another yDNA / mtDNA test. It does not work if there is already another test for the same person. 

I have all 3 test types connected.  It has be something else.  Can you post everything that is on the screen when you get the query error display

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

You are right. For me (I1) it does not work, even after deleting mtDNA and yDNA.

The error display depends how long I wait. 

If I wait only 1 minute before I shutdown the server, I get:

Testkenndaten

Ein Fehler ist in TNG aufgetreten. Ursache kann das Setup , ein unvollständiges Upgrade oder ein Programmfehler sein. Wenn Sie der Webseitenbetreiber sind, kontaktieren Sie den TNG-Support, um Hilfe zu erhalten. Bitte kopieren Sie die untenstehende Meldung in ihre Nachricht.

Abfrage: SELECT p.lastname, p.famc, f.husband, f.wife FROM tng_people AS p LEFT JOIN tng_families AS f ON (p.famc = f.familyID AND p.gedcom = f.gedcom) WHERE p.personID = 'I6656' AND p.gedcom = 'Kemper'

Server shutdown in progress
 
 
Waiting 5 minutes results:
 
( ! ) Warning: mysqli_query(): MySQL server has gone away in C:\wamp64\www\TNG\tngconnect.php on line 157
Call Stack
# Time Memory Function Location
1 0.0013 359000 {main}( ) ...\admin_edit_dna_test.php:0
2 0.0286 1187592 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:306
3 0.0293 1191432 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
4 0.0296 1195432 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
5 0.0299 1199288 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
6 0.0301 1203128 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
7 0.0305 1207048 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
8 0.0434 1212888 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
9 0.0508 1217256 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
10 0.0585 1222320 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
11 0.0588 1226248 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
12 0.0635 1230760 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
13 0.0638 1234688 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
14 0.0641 1238536 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
15 0.0644 1242384 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
16 0.0684 1247144 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
17 0.0687 1251072 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
18 0.0690 1254920 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
19 0.0709 1259008 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
20 0.0712 1262936 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
21 0.0715 1266784 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
22 0.0718 1270632 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
23 0.0725 1274480 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
24 0.0727 1278408 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
25 0.0730 1282272 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
26 0.0733 1286160 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
27 0.0741 1290024 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
28 0.0759 1293952 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
29 0.0764 1297880 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
30 0.0767 1301808 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
31 0.0769 1305656 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
32 0.0772 1309504 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
33 0.0774 1313352 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
34 0.0777 1317200 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
35 0.0780 1321048 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
36 0.0782 1324896 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
37 0.1081 1328824 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
38 0.1086 1332672 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
39 0.1089 1336520 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
40 0.1091 1340368 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
41 0.1094 1344216 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
42 0.1096 1348064 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
43 0.1099 1351912 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
44 0.1102 1355760 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
45 0.1118 1359608 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
46 0.1124 1363456 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
47 0.1147 1367304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
48 0.1149 1371152 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
49 0.1156 1375000 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
50 0.1159 1378848 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
51 0.1170 1382696 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
52 0.3223 1386704 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
53 0.3226 1390552 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
54 0.3228 1394400 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
55 0.3231 1398248 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
56 0.3233 1402096 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
57 0.3252 1405944 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
58 0.3255 1409792 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
59 0.3257 1413640 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
60 0.3280 1417488 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
61 0.3282 1421336 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
62 0.3308 1425184 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
63 0.3310 1429032 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
64 0.3313 1432880 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
65 0.3319 1436728 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
66 0.3323 1440576 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
67 0.3326 1444424 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
68 0.3328 1448272 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
69 0.3336 1452120 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
70 0.3350 1455968 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
71 0.3352 1459816 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
72 0.3355 1463664 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
73 0.3357 1467512 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
74 0.3360 1471360 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
75 0.3362 1475208 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
76 0.3376 1479056 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
77 0.3379 1613888 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
78 0.3391 1617736 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
79 0.3407 1621584 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
80 0.3410 1625432 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
81 0.3444 1629280 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
82 0.3450 1633128 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
83 0.3452 1636976 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
84 0.3455 1640824 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
85 0.3457 1644672 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
86 0.3490 1648520 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
87 0.3534 1652368 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
88 0.3539 1656216 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
89 0.3541 1660064 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
90 0.3544 1663912 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
91 0.3546 1667760 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
92 0.3549 1671608 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
93 0.3552 1675456 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
94 0.3555 1679304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
95 0.3557 1683152 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
96 0.3560 1687000 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
97 0.3562 1690848 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
98 0.3667 1694720 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
99 0.3670 1698568 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
100 0.3673 1702416 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
101 0.3717 1706264 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
102 0.3720 1710112 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
103 0.3722 1713960 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
104 0.3755 1717808 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
105 0.3758 1721656 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
106 0.3760 1725504 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
107 0.3763 1729352 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
108 0.3773 1733200 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
109 0.3793 1737048 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
110 0.3795 1740896 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
111 0.3798 1744744 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
112 0.3801 1748592 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
113 0.3803 1752504 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
114 0.3806 1756376 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
115 331.2939 1760248 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
116 331.2942 1764096 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
117 331.2944 1767944 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
118 331.2947 1771792 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
119 331.2958 1775640 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
120 331.2961 1779488 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
121 331.2963 1783336 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
122 331.2966 1787240 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
123 372.3312 1791400 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
124 382.5425 1795616 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
125 392.7654 1799816 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
126 392.7663 1804064 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
127 403.1299 1808288 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
128 403.1302 1812512 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
129 403.1305 1816736 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
130 403.1308 1820960 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
131 403.9852 1825184 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
132 403.9855 1829240 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
133 403.9857 1833256 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
134 403.9860 1837296 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
135 403.9863 1841232 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
136 404.4170 1845168 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
137 404.4173 1849104 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
138 404.4175 1853112 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
139 404.4178 1857136 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
140 404.4181 1861056 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
141 404.4184 1864952 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
142 404.4187 1868872 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
143 404.4198 1872800 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
144 404.4200 1876736 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
145 404.4203 1880656 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
146 404.4205 1884592 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
147 404.4208 1888544 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
148 404.4211 1892496 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
149 404.4213 1896464 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
150 404.4216 1900424 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
151 404.4218 1904408 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
152 404.4221 1908408 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
153 404.4223 1912368 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
154 404.4228 1916344 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
155 404.4231 1920328 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
156 404.4242 1924304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
157 404.4245 1928312 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
158 404.4247 1932328 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
159 404.4250 1936328 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
160 404.4252 2071312 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
161 404.4912 2075304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
162 404.5581 2079288 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
163 404.5584 2083208 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
164 404.5586 2087136 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
165 404.5597 2091072 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
166 404.5602 2095024 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
167 404.5608 2098968 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
168 404.5610 2102896 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
169 404.5614 2106792 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
170 404.5617 2110744 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
171 404.5620 2114672 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
172 404.5624 2118576 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
173 404.5630 2122488 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
174 404.5635 2126352 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
175 404.5639 2130240 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
176 404.5644 2134160 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
177 404.5648 2138072 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
178 404.5652 2141984 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
179 404.5655 2145928 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
180 404.5660 2149864 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
181 404.5660 2150144 tng_query( ) ...\admin_edit_dna_test.php:123
182 404.5660 2150240 mysqli_query ( ) ...\tngconnect.php:157
 
( ! ) Warning: mysqli_query(): Error reading result set's header in C:\wamp64\www\TNG\tngconnect.php on line 157
Call Stack
# Time Memory Function Location
1 0.0013 359000 {main}( ) ...\admin_edit_dna_test.php:0
2 0.0286 1187592 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:306
3 0.0293 1191432 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
4 0.0296 1195432 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
5 0.0299 1199288 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
6 0.0301 1203128 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
7 0.0305 1207048 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
8 0.0434 1212888 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
9 0.0508 1217256 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
10 0.0585 1222320 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
11 0.0588 1226248 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
12 0.0635 1230760 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
13 0.0638 1234688 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
14 0.0641 1238536 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
15 0.0644 1242384 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
16 0.0684 1247144 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
17 0.0687 1251072 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
18 0.0690 1254920 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
19 0.0709 1259008 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
20 0.0712 1262936 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
21 0.0715 1266784 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
22 0.0718 1270632 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
23 0.0725 1274480 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
24 0.0727 1278408 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
25 0.0730 1282272 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
26 0.0733 1286160 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
27 0.0741 1290024 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
28 0.0759 1293952 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
29 0.0764 1297880 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
30 0.0767 1301808 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
31 0.0769 1305656 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
32 0.0772 1309504 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
33 0.0774 1313352 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
34 0.0777 1317200 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
35 0.0780 1321048 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
36 0.0782 1324896 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
37 0.1081 1328824 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
38 0.1086 1332672 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
39 0.1089 1336520 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
40 0.1091 1340368 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
41 0.1094 1344216 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
42 0.1096 1348064 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
43 0.1099 1351912 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
44 0.1102 1355760 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
45 0.1118 1359608 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
46 0.1124 1363456 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
47 0.1147 1367304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
48 0.1149 1371152 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
49 0.1156 1375000 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
50 0.1159 1378848 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
51 0.1170 1382696 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
52 0.3223 1386704 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
53 0.3226 1390552 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
54 0.3228 1394400 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
55 0.3231 1398248 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
56 0.3233 1402096 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
57 0.3252 1405944 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
58 0.3255 1409792 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
59 0.3257 1413640 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
60 0.3280 1417488 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
61 0.3282 1421336 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
62 0.3308 1425184 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
63 0.3310 1429032 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
64 0.3313 1432880 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
65 0.3319 1436728 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
66 0.3323 1440576 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
67 0.3326 1444424 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
68 0.3328 1448272 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
69 0.3336 1452120 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
70 0.3350 1455968 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
71 0.3352 1459816 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
72 0.3355 1463664 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
73 0.3357 1467512 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
74 0.3360 1471360 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
75 0.3362 1475208 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
76 0.3376 1479056 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
77 0.3379 1613888 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
78 0.3391 1617736 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
79 0.3407 1621584 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
80 0.3410 1625432 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
81 0.3444 1629280 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
82 0.3450 1633128 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
83 0.3452 1636976 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
84 0.3455 1640824 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
85 0.3457 1644672 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
86 0.3490 1648520 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
87 0.3534 1652368 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
88 0.3539 1656216 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
89 0.3541 1660064 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
90 0.3544 1663912 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
91 0.3546 1667760 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
92 0.3549 1671608 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
93 0.3552 1675456 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
94 0.3555 1679304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
95 0.3557 1683152 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
96 0.3560 1687000 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
97 0.3562 1690848 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
98 0.3667 1694720 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
99 0.3670 1698568 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
100 0.3673 1702416 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
101 0.3717 1706264 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
102 0.3720 1710112 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
103 0.3722 1713960 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
104 0.3755 1717808 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
105 0.3758 1721656 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
106 0.3760 1725504 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
107 0.3763 1729352 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
108 0.3773 1733200 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
109 0.3793 1737048 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
110 0.3795 1740896 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
111 0.3798 1744744 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
112 0.3801 1748592 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
113 0.3803 1752504 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
114 0.3806 1756376 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
115 331.2939 1760248 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
116 331.2942 1764096 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
117 331.2944 1767944 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
118 331.2947 1771792 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
119 331.2958 1775640 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
120 331.2961 1779488 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
121 331.2963 1783336 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
122 331.2966 1787240 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
123 372.3312 1791400 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
124 382.5425 1795616 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
125 392.7654 1799816 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
126 392.7663 1804064 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
127 403.1299 1808288 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
128 403.1302 1812512 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
129 403.1305 1816736 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
130 403.1308 1820960 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
131 403.9852 1825184 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
132 403.9855 1829240 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
133 403.9857 1833256 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
134 403.9860 1837296 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
135 403.9863 1841232 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
136 404.4170 1845168 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
137 404.4173 1849104 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
138 404.4175 1853112 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
139 404.4178 1857136 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
140 404.4181 1861056 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
141 404.4184 1864952 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
142 404.4187 1868872 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
143 404.4198 1872800 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
144 404.4200 1876736 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
145 404.4203 1880656 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
146 404.4205 1884592 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
147 404.4208 1888544 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
148 404.4211 1892496 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
149 404.4213 1896464 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
150 404.4216 1900424 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
151 404.4218 1904408 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
152 404.4221 1908408 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
153 404.4223 1912368 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
154 404.4228 1916344 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
155 404.4231 1920328 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
156 404.4242 1924304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
157 404.4245 1928312 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
158 404.4247 1932328 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
159 404.4250 1936328 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
160 404.4252 2071312 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
161 404.4912 2075304 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
162 404.5581 2079288 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
163 404.5584 2083208 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
164 404.5586 2087136 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
165 404.5597 2091072 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
166 404.5602 2095024 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
167 404.5608 2098968 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
168 404.5610 2102896 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
169 404.5614 2106792 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
170 404.5617 2110744 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
171 404.5620 2114672 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
172 404.5624 2118576 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
173 404.5630 2122488 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:131
174 404.5635 2126352 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
175 404.5639 2130240 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
176 404.5644 2134160 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
177 404.5648 2138072 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
178 404.5652 2141984 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
179 404.5655 2145928 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
180 404.5660 2149864 get_ancestor_surnames( ) ...\admin_edit_dna_test.php:130
181 404.5660 2150144 tng_query( ) ...\admin_edit_dna_test.php:123
182 404.5660 2150240 mysqli_query ( ) ...\tngconnect.php:157
Ein Fehler ist in TNG aufgetreten. Ursache kann das Setup , ein unvollständiges Upgrade oder ein Programmfehler sein. Wenn Sie der Webseitenbetreiber sind, kontaktieren Sie den TNG-Support, um Hilfe zu erhalten. Bitte kopieren Sie die untenstehende Meldung in ihre Nachricht.

Abfrage: SELECT p.lastname, p.famc, f.husband, f.wife FROM tng_people AS p LEFT JOIN tng_families AS f ON (p.famc = f.familyID AND p.gedcom = f.gedcom) WHERE p.personID = 'I6783' AND p.gedcom = 'Kemper'

MySQL server has gone away
Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

It has to do with the number of "Other events". No problem with persons with only few other events. Does not work with persons with a large number of other events (profession, residence, military service and whatever). 

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

I have it: The problem is the get_ancestor_surnames( ) routine.

I have a large genealogy with some noble families, researched in detail, including the medieval dynasties back the Charlemagne and further back. I have approx. 10,000 different ways from my son to Charlemagne. There are too many ancestral surnames for some persons.

The MOD cannot handle too many surnames. It works for persons with an average number of ancestors (6 or 8 generations more or less complete). It does not work with persons having 30 or 40 generations of ancestors with many cousin marriages.

The process for ancestral surnames should stop after a certain number of generations. Do you think you could add something to make the MOD stop after 10 generations or so?

Thank you for your help, Ken Roy!

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted

Yes, I think so. yDNA and mtDNA are limited to one line, i.e. less persons.
But by the way: Would it be possible to find automatically all related persons in direct female line = all persons with the same mtDNA (not only the female ancestral line)? Or all carrier of the yDNA?

Link to comment
Share on other sites
tobias.kemper

tobias.kemper

Posted
  • Author
Posted
vor 16 Stunden schrieb Ken Roy:

Thanks Tobias,

Probably only an issue with the atDNA test.  Will take a look at it.

Hello Ken,
it would help if I could delete the "get_ancestor_surnames" routine which starts when I click the "edit" button. 
It seems that one should modify the admin_edit_dna_test.php . I have deleted:

function get_ancestor_surnames($personID, $tree, $type) {
   global $surnamesarr, $surnamesexc, $pass1;
   
   $select = "SELECT p.lastname, p.famc, f.husband, f.wife FROM tng_people AS p LEFT JOIN tng_families AS f ON (p.famc = f.familyID AND p.gedcom = f.gedcom) WHERE p.personID = '" . $personID . "' AND p.gedcom = '" . $tree . "'";
   $result = tng_query($select);
    while( $surrow = tng_fetch_assoc($result) ) {
      $father = ($type != "mtDNA") ? $surrow['husband'] : "";
      $mother = ($type != "Y-DNA") ? $surrow['wife'] : "";
    if (!in_array($surrow['lastname'], $surnamesarr) && !in_array($surrow['lastname'], $surnamesexc) && !$pass1)
     array_push($surnamesarr, $surrow['lastname']);
     $pass1 = false;
      if ($father) get_ancestor_surnames($father, $tree, $type);
      if ($mother) get_ancestor_surnames($mother, $tree, $type);
   }
tng_free_result($result);
if ($type == "atDNA") sort($surnamesarr);
$ancestorstr = implode(', ', $surnamesarr);

return $ancestorstr;
}

And:

        <?php if (!$row['surnames'] && $row['personID']) $ancestorstr = get_ancestor_surnames($row['personID'], $row['gedcom'], $row['test_type']);
                        else $ancestorstr = $row['surnames'];
$ancestorstr = $ancsurnameupper ? strtoupper($ancestorstr) : ucwords(strtolower($ancestorstr));
?>
 

Now it seems to work as a "quick and dirty" solution for me (now no surnames at all are listed automatically).

I am convinced that you will find a better solution.

Best regards

Tobias

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...