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 P1.living, P1.personID, CONCAT('') AS Photo, P1.lastname AS Last_Name, P1.firstname AS First_Name, IF( P1.sex = 'F' AND P2.lastname IS NOT NULL , P2.lastname, ' ' ) AS MarriedName, P1.birthdate AS Birth_Date, P1.deathdate AS Death_Date, E1.eventdate AS Rec_DATE, YEAR( p.birthdatetr ) - YEAR( E1.eventdatetr ) AS Est_age, E1.eventplace AS _Event_Place_Location, X1.note AS Note FROM tng_xnotes X1 INNER JOIN tng_notelinks N1 ON X1.gedcom = N1.gedcom AND X1.ID = N1.xnoteID INNER JOIN tng_events E1 ON N1.gedcom = E1.gedcom AND N1.eventID = E1.eventID INNER JOIN tng_eventtypes E2 ON E1.eventtypeID = E2.eventtypeID INNER JOIN tng_people P1 ON N1.persfamID = P1.personID AND N1.gedcom = P1.gedcom LEFT JOIN tng_families F1 ON P1.gedcom = F1.gedcom AND P1.personID = F1.wife LEFT JOIN tng_people P2 ON F1.gedcom = P2.gedcom AND F1.husband = P2.personID LEFT JOIN tng_medialinks AS ml ON P1.personID = ml.personID LEFT JOIN tng_media AS m ON ml.mediaID = m.mediaID WHERE (X1.note LIKE '%St. John High School Little Chute Class of 1947%') GROUP BY P1.personID ORDER BY P1.lastname, P1.firstname LIMIT 1000

Unknown column 'p.birthdatetr' in 'field list'