Der er fejl i TNG-softwaren. Hvad skal man gøre:

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.

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.

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.



Forespørgsel: SELECT if (f.familyid ='none', concat('', h.firstname,' ', if(length(h.nickname),concat('"',h.nickname, '" '),''), if(length(h.lnprefix),concat(h.lnprefix, ' '),''), h.lastname,if(length(h.suffix),concat(', ', h.suffix, ' '),''), ''), concat('',if(isnull(h.lastname),' ',h.lastname), '/ ',if(isnull(w.lastname),' ',w.lastname),'',', ', if(isnull(h.firstname),' ',h.firstname), '/ ',if(isnull(w.firstname),' ',w.firstname)) ) as name, date_format(f.datetr,'%a, %e %b %Y') as date, datetype,date_format(f.nextannivday,'%a, %e %b %Y') as Årsdag, year(nextannivday) - year(datetr) as År from tng_people as p join (SELECT gedcom,personid,familyid,wife, date, datetr , datetype, datetr + INTERVAL year(curdate())-year(datetr)+((datetr + INTERVAL year(curdate())-year(datetr) YEAR) < curdate()) YEAR as nextannivday FROM (select dte.gedcom, personid, familyid, wife,date, datetr, datetype from (select gedcom, personid,'none' as familyid, 'none' as wife, birthdate as date, birthdatetr as datetr, '1. Fødselsdag' as datetype FROM tng_people where gedcom ='schroeder' and birthdatetr union all select gedcom, husband, familyid, wife, marrdate, marrdatetr, '2. Bryllupsdag' as type FROM tng_families where gedcom ='schroeder' and marrdatetr union all select gedcom, persfamid, 'none' as familyid, 'none' as wife, eventdate, eventdatetr, concat('6. ',display) as type FROM tng_eventtypes as t join tng_events as e using (eventtypeid)where gedcom ='schroeder' and eventdatetr) as dte ) as dt where day(datetr) order by nextannivday, datetype) as f on p.gedcom=f.gedcom and p.personid=f.personid left join tng_people as h on f.gedcom=h.gedcom and f.personid=h.personid left join tng_people as w on f.gedcom=w.gedcom and f.wife=w.personid where datediff(nextannivday, curdate()) <= 28 order by nextannivday,datetype,p.lastname, p.firstname LIMIT 50

Illegal mix of collations (utf8mb3_general_ci,COERCIBLE) and (latin1_danish_ci,IMPLICIT) for operation 'UNION'