An error has occurred in the TNG software. What to do:

If you just installed an upgrade, you might have skipped part of the installation instructions. Go back to the upgrade readme page reread the instructions. Pay special attention to the database structure step.

If you just installed TNG for the first time, you might still need to create the database tables. Return to the readme.html page to find that step.

If you are the site owner, you may contact TNG support for further assistance with this problem. Please copy the query below and paste it into your message.



Query: SELECT P1.personID, CONCAT('')," ") AS Image, 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, E1.info AS Newspaper_Info, X1.note AS Note FROM tng_people P1 LEFT OUTER JOIN tng_families F1 ON P1.gedcom = F1.gedcom AND P1.personID = F1.wife LEFT OUTER JOIN tng_people P2 ON F1.gedcom = P2.gedcom AND F1.husband = P2.personID LEFT OUTER JOIN tng_notelinks N1 ON P1.gedcom = N1.gedcom AND P1.personID = N1.persfamID LEFT OUTER JOIN tng_events E1 ON P1.gedcom = E1.gedcom AND N1.eventID = E1.eventID LEFT OUTER JOIN tng_eventtypes E2 ON E1.eventtypeID = E2.eventtypeID LEFT OUTER JOIN tng_xnotes X1 ON N1.gedcom = X1.gedcom AND N1.xnoteID = X1.ID INNER JOIN tng_medialinks AS l ON P1.personID = l.personID AND P1.gedcom = l.gedcom INNER JOIN tng_media AS M1 ON l.mediaID = M1.mediaID AND l.gedcom = M1.gedcom AND M1.mediatypeID = 'obituaries' WHERE (E1.eventtypeID LIKE '130') Group BY P1.personID ORDER BY P1.deathdatetr DESC LIMIT 1000

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS Image, P1.lastname AS Last_Name, P1.firstname AS First_Name, IF( P1.sex...' at line 1