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 IF(citetext NOT LIKE "%birth:%","xBir", IF(citetext NOT LIKE "%death:%","xDea", IF(page NOT LIKE "grid%" OR LENGTH(page)<13,"page", IF(x.note NOT LIKE "%GRid=%" OR length(x.note)<13,"note", IF(x.note LIKE "% %","Spc","?"))))) AS Why, personID, CONCAT(p.firstname,' ',p.lastname,' ',p.suffix) AS Name, p.Birthdate, REPLACE(printname1,"Cemetery","Cem") AS Burial, x.note AS BurialNote, IF(ASCII(MID(citetext, LOCATE('Death:',citetext)-1))=10 AND LOCATE('Death:', citetext)>1, CONCAT(LEFT(citetext,25), " |", MID(citetext, LOCATE('Death:', citetext))), citetext) AS citetext, c.page FROM people p LEFT JOIN notelinks n ON p.personid = n.persfamID AND p.gedcom = n.gedcom AND n.eventID = "BURI" LEFT JOIN xnotes x ON x.id = n.xnoteid AND x.gedcom = n.gedcom LEFT JOIN citations c ON c.persfamID=p.personID and c.gedcom=p.gedcom and c.eventid='BURI' LEFT JOIN places pc ON pc.place=p.burialplace AND pc.gedcom=p.gedcom LEFT JOIN sources s ON s.sourceID=c.sourceID and s.gedcom=c.gedcom WHERE burialplace<>'' AND p.gedcom='ftm17' AND (citetext NOT LIKE "%birth:%" or citetext NOT LIKE "%death:%" OR page NOT LIKE "grid%" or LENGTH(page)<13 OR x.note NOT LIKE "%GRid=%" OR LENGTH(x.note)<13 OR x.note LIKE "% %") AND s.title like '%find a grave%' LIMIT 50

Unknown column 'printname1' in 'field list'