Warning: mysqli_query() [function.mysqli-query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(year(`olderne_dk_db`.`tng_people`.`deathdatetr`) - year(if((`olderne_dk_db`.`tng_people`.`birthdatetr` <> '0000-00-00'),`olderne_dk_db`.`tng_people`.`birthdatetr`,`olderne_dk_db`.`tng_people`.`altbirthdatetr`)))' in /var/www/olderne.dk/public_html/TNG/tngconnect.php on line 157
Der er opstået en fejl i TNG-softwaren. Dette kan skyldes et opsætningsproblem, en ufuldstændig opgradering eller en programfejl. Ejeren af hjemmesiden 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= "Olderne"
ORDER BY totaldays DESC
BIGINT UNSIGNED value is out of range in '(year(`olderne_dk_db`.`tng_people`.`deathdatetr`) - year(if((`olderne_dk_db`.`tng_people`.`birthdatetr` <> '0000-00-00'),`olderne_dk_db`.`tng_people`.`birthdatetr`,`olderne_dk_db`.`tng_people`.`altbirthdatetr`)))'
