Der er fejl i TNG-softwaren. Hvad skal man gøre:<p>Hvis man netop har installeret en opgradering, kan man muligvis have sprunget over en del af installationsinstruktionerne. Gå tilbage til opgraderings readme siden og læst instruktionerne igen. Vær særlig opmærksom på databasestruktur trinnet. </p><p>Hvis det er første gang, at TNG er blevet installeret, kan det være nødvendigt at oprette databasetabellerne. Gå tilbage til siden readme.html for at finde det trin.</p><p>Ejeren af webstedet kan kontakte TNG support for yderligere hjælp til dette problem. Kopier nedenstående forespørgsel, og indsæt den i en meddelelse.</p><br /><br />Forespørgsel: select CONCAT('<a href = \"familygroup.php?familyID=', F1.familyID, '&tree=', F1.gedcom, '\" target=\"_blank\" class=\"fam\">', F1.familyID, '</a>') as FamilyID ,F1.living ,CONCAT(P1.lastname, ', ', P1.firstname) as HusbandName ,CONCAT(P2.lastname, ', ', P2.firstname) as WifeName ,case when YEAR(F1.divdatetr) != 0 then YEAR(F1.divdatetr)-YEAR(F1.marrdatetr) when YEAR(P1.deathdatetr) != 0 and YEAR(P2.deathdatetr) != 0 and YEAR(P1.deathdatetr) <= YEAR(P2.deathdatetr) then YEAR(P1.deathdatetr)-YEAR(F1.marrdatetr) when YEAR(P1.deathdatetr) != 0 and YEAR(P2.deathdatetr) != 0 and YEAR(P1.deathdatetr) > YEAR(P2.deathdatetr) then YEAR(P2.deathdatetr)-YEAR(F1.marrdatetr) else 0 end as YearsMarried ,F1.marrdate ,F1.divdate ,P1.deathdate as HusbandDeathDate ,P2.deathdate as WifeDeathDate ,case when YEAR(F1.divdatetr) != 0 or (YEAR(P1.deathdatetr) != 0 and YEAR(P2.deathdatetr) != 0) then ' ' when YEAR(P1.deathdatetr) = 0 then 'Husband death date not known' when YEAR(P2.deathdatetr) = 0 then 'Wife death date not known' end as Comment from tng_families F1 inner join tng_people P1 on F1.gedcom = P1.gedcom and F1.husband = P1.personID inner join tng_people P2 on F1.gedcom = P2.gedcom and F1.wife = P2.personID where F1.marrdate != '' and UPPER(P1.deathdate) not like 'ABT%' and UPPER(P1.deathdate) not like 'AFT%' and UPPER(P1.deathdate) not like 'BEF%' and UPPER(P1.deathdate) not like 'BET%' and UPPER(P1.deathdate) not like 'CAL%' and UPPER(P1.deathdate) not like 'EST%' and UPPER(P2.deathdate) not like 'ABT%' and UPPER(P2.deathdate) not like 'AFT%' and UPPER(P2.deathdate) not like 'BEF%' and UPPER(P2.deathdate) not like 'BET%' and UPPER(P2.deathdate) not like 'CAL%' and UPPER(P2.deathdate) not like 'EST%' and UPPER(F1.marrdate) not like 'ABT%' and UPPER(F1.marrdate) not like 'AFT%' and UPPER(F1.marrdate) not like 'BEF%' and UPPER(F1.marrdate) not like 'BET%' and UPPER(F1.marrdate) not like 'CAL%' and UPPER(F1.marrdate) not like 'EST%' and UPPER(F1.marrdate) != 'Y' and UPPER(F1.divdate) not like 'ABT%' and UPPER(F1.divdate) not like 'AFT%' and UPPER(F1.divdate) not like 'BEF%' and UPPER(F1.divdate) not like 'BET%' and UPPER(F1.divdate) not like 'CAL%' and UPPER(F1.divdate) not like 'EST%' and UPPER(F1.divdate) != 'Y' and (F1.divdate != '' or P1.deathdate != '' or P2.deathdate != '') and not (YEAR(F1.divdatetr) = 0 and YEAR(P1.deathdatetr) = 0 and YEAR(P2.deathdatetr) = 0) having Comment = '' order by YearsMarried desc, P1.lastname, F1.marrdatetr desc   LIMIT 50<br /><br />BIGINT UNSIGNED value is out of range in '(year(`olhus_dk_db`.`P1`.`deathdatetr`) - year(`olhus_dk_db`.`F1`.`marrdatetr`))'