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 c.familyID, p.personID, p.lastname, p.firstname, p.birthdate, p.birthplace, p.living, COUNT( c.familyID ) AS Number, p.gedcom FROM tng_children AS c INNER JOIN tng_people AS p ON p.personID = c.personID INNER JOIN tng_children AS c2 ON c2.familyID = c.familyID INNER JOIN tng_people AS p2 ON p2.personID = c2.personID WHERE ( p2.birthdatetr = p.birthdatetr OR p2.birthdatetr = DATE_ADD( p.birthdatetr, INTERVAL 1 DAY ) OR p2.birthdatetr = DATE_SUB( p.birthdatetr, INTERVAL 1 DAY ) ) AND YEAR( p.birthdatetr ) <>0 AND MONTH( p.birthdatetr ) <>0 AND DAYOFMONTH( p.birthdatetr ) <>0 GROUP BY c.familyID, p.personID, p.birthdatetr HAVING COUNT( c2.familyID ) >=2 ORDER BY Number, p.lastname, c.familyID, p.birthdatetr LIMIT 50

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay