Notice: Undefined index: countquery in /home/jamescobban/public_html/FamilyTree/Names.php on line 403

RecordSet::rewind: 2927 query='SELECT tblIR.*, EBirth.EventD AS EBirthD, EDeath.EventD AS EDeathD, tblNX.Surname AS indexsurname, tblNX.GivenName AS indexgivenname, tblNX.`Type` AS indextype FROM tblIR JOIN tblNX ON tblNX.IDIR=tblIR.IDIR JOIN tblNR ON tblNR.Surname=tblNX.Surname LEFT JOIN tblER AS EBirth ON (EBirth.IDIR=tblIR.IDIR AND EBirth.IDType=0 AND EBirth.IDET=3 AND EBirth.Preferred=1) LEFT JOIN tblER AS EDeath ON (EDeath.IDIR=tblIR.IDIR AND EDeath.IDType=0 AND EDeath.IDET=6 AND EDeath.Preferred=1) WHERE tblNX.`Surname`=? AND tblNX.TreeName=? AND tblNX.`Type`>=0 GROUP BY `tblIR`.IDIR, tblIR.ID, EBirth.EventD, EDeath.EventD, tblNX.Surname, tblNX.GivenName, tblNX.`Type`, EBirth.EventSD, tblIR.BirthSD ORDER BY `tblIR`.Surname,`tblIR`.GivenName,COALESCE(EBirth.EventSD,`tblIR`.BirthSD,-99999999) LIMIT 100', 'SELECT tblIR.*, EBirth.EventD AS EBirthD, EDeath.EventD AS EDeathD, tblNX.Surname AS indexsurname, tblNX.GivenName AS indexgivenname, tblNX.`Type` AS indextype FROM tblIR JOIN tblNX ON tblNX.IDIR=tblIR.IDIR JOIN tblNR ON tblNR.Surname=tblNX.Surname LEFT JOIN tblER AS EBirth ON (EBirth.IDIR=tblIR.IDIR AND EBirth.IDType=0 AND EBirth.IDET=3 AND EBirth.Preferred=1) LEFT JOIN tblER AS EDeath ON (EDeath.IDIR=tblIR.IDIR AND EDeath.IDType=0 AND EDeath.IDET=6 AND EDeath.Preferred=1) WHERE tblNX.`Surname`='Risdon' AND tblNX.TreeName='' AND tblNX.`Type`>=0 GROUP BY `tblIR`.IDIR, tblIR.ID, EBirth.EventD, EDeath.EventD, tblNX.Surname, tblNX.GivenName, tblNX.`Type`, EBirth.EventSD, tblIR.BirthSD ORDER BY `tblIR`.Surname,`tblIR`.GivenName,COALESCE(EBirth.EventSD,`tblIR`.BirthSD,-99999999) LIMIT 100'

Unhandled error 'RecordSet::rewind: "SELECT tblIR.*, EBirth.EventD ...MIT 100", Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'tblNX.Type' in 'field list' ) ' at /home/jamescobban/includes/Genealogy/RecordSet.inc:2933

Trace: #0 /home/jamescobban/public_html/FamilyTree/Names.php(485): Genealogy\RecordSet->rewind() #1 {main}