An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message.

Query: select concat('', p.firstname,' ', if(length(p.nickname),concat('"',p.nickname, '" '),''), if(length(p.lnprefix),concat(p.lnprefix, ' '),''), p.lastname,if(length(p.suffix),concat(', ', p.suffix, ' '),''), '') as name, if(isnull(dayname(p.birthdatetr)),p.birthdate,concat(left(dayname(p.birthdatetr),3),', ',p.birthdate)) as birthdate, p.birthplace, concat('', if(isnull(w.lastname),h.lastname,concat( '', h.lastname,'/ ',w.lastname)), '') as `Family Name`, 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, ' '),''), '') as Father, concat('', w.firstname,' ', if(length(w.nickname),concat('"',w.nickname, '" '),''), if(length(w.lnprefix),concat(w.lnprefix, ' '),''), w.lastname,if(length(w.suffix),concat(', ', w.suffix, ' '),''), '') as Mother from tng_people as p left join tng_families as f on p.gedcom = f.gedcom and p.famc = f.familyid left join tng_people as h on f.gedcom = h.gedcom and f.husband = h.personid left join tng_people as w on f.gedcom = w.gedcom and f.wife = w.personid where p.gedcom ='bryd2' and p.lastname <> '' order by h.lastname, w.lastname, p.lastname, p.firstname LIMIT 30

Illegal mix of collations (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE), (latin1_swedish_ci,IMPLICIT) for operation 'concat'