Det har oppstått en feil i TNG programvaren. Dette kan skyldes et konfigurasjonsproblem, en ufullstendig oppgradering eller en programfeil. Hvis du er eieren av nettstedet, kan du kontakte TNG systemstøtte for å få hjelp med dette problemet. Vennligst kopier spørringen under og lim den inn i meldingen.
Spørring: 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= "IEA"
ORDER BY totaldays DESC
BIGINT UNSIGNED value is out of range in '(year(`vestrybb_iea`.`tng_people`.`deathdatetr`) - year(if((`vestrybb_iea`.`tng_people`.`birthdatetr` <> '0000-00-00'),`vestrybb_iea`.`tng_people`.`birthdatetr`,`vestrybb_iea`.`tng_people`.`altbirthdatetr`)))'
Erik Berntsens slektssider