Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(year(`kjeldbjergslaegten_dk0_db`.`tng_people`.`deathdatetr`) - year(if((`kjeldbjergslaegten_dk0_db`.`tng_people`.`birthdatetr` <> '0000-00-00'),`kjeldbjergslaegten_dk0_db`.`tng_people`.`birthdatetr`,`kjeldbjergslaegten_dk0_db`.`tng_people`.`altbirthdatetr`)))' in /var/www/xn--kjeldbjergslgten-5ob.dk/public_html/tngconnect.php on line 157
Der er opstået en fejl i TNG-softwaren. Dette kan skyldes et opsætnings problem, en ufuldstændig opgradering eller en program fejl. Ejeren af webstedet kan kontakte TNG support for at få hjælp med dette problem. Kopier og indsæt forespørgslen herunder i henvendelsen.
Forespørgsel: SELECT YEAR( deathdatetr ) - YEAR(IF(birthdatetr !='0000-00-00',birthdatetr,altbirthdatetr))
AS yearsold, DAYOFYEAR( deathdatetr ) - DAYOFYEAR(IF(birthdatetr !='0000-00-00',birthdatetr,altbirthdatetr)) AS daysold,
IF(DAYOFYEAR(deathdatetr) and DAYOFYEAR(IF(birthdatetr !='0000-00-00',birthdatetr,altbirthdatetr)),TO_DAYS(deathdatetr) - TO_DAYS(IF(birthdatetr !='0000-00-00',birthdatetr,altbirthdatetr)),(YEAR(deathdatetr) - YEAR(IF(birthdatetr !='0000-00-00',birthdatetr,altbirthdatetr))) * 365) as totaldays
FROM tng_people
WHERE (birthdatetr != '0000-00-00' OR altbirthdatetr != '0000-00-00') AND deathdatetr != '0000-00-00'
AND (birthdate not like 'AFT%' OR altbirthdate not like 'AFT%') AND deathdate not like 'AFT%'
AND (birthdate not like 'BEF%' OR altbirthdate not like 'BEF%') AND deathdate not like 'BEF%'
AND (birthdate not like 'ABT%' OR altbirthdate not like 'ABT%') AND deathdate not like 'ABT%'
AND (birthdate not like 'BET%' OR altbirthdate not like 'BET%') AND deathdate not like 'BET%'
AND (birthdate not like 'CAL%' OR altbirthdate not like 'CAL%') AND deathdate not like 'CAL%'
AND gedcom= "kjeld"
ORDER BY totaldays DESC
BIGINT UNSIGNED value is out of range in '(year(`kjeldbjergslaegten_dk0_db`.`tng_people`.`deathdatetr`) - year(if((`kjeldbjergslaegten_dk0_db`.`tng_people`.`birthdatetr` <> '0000-00-00'),`kjeldbjergslaegten_dk0_db`.`tng_people`.`birthdatetr`,`kjeldbjergslaegten_dk0_db`.`tng_people`.`altbirthdatetr`)))'
