Quill Posted October 23, 2021 Report Share Posted October 23, 2021 Good morning, I have family members that are "Mayflower Descendants". I am trying to create a report that will contain on ly Mayflower "Descendants" Thank you, Mike Quill Quote Link to comment Share on other sites More sharing options...
theKiwi Posted October 23, 2021 Report Share Posted October 23, 2021 How have you identified them in TNG? With a Custom Event, or some other way? Roger Quote Link to comment Share on other sites More sharing options...
Quill Posted October 23, 2021 Author Report Share Posted October 23, 2021 (edited) Hello, I have it listed as another event. Also received this error msg "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 tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,birthdate,birthplace, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e112 ON tng_people.personID = e112.persfamID AND tng_people.gedcom = e112.gedcom AND e112.eventtypeID = "112" WHERE (LIKE "e112.eventdate%" != "") ORDER BY lastname,firstname LIMIT 300 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 'LIKE "e112.eventdate%" != "") ORDER BY lastname,firstname LIMIT 300' at line 1 Edited October 23, 2021 by Quill Quote Link to comment Share on other sites More sharing options...
Quill Posted October 23, 2021 Author Report Share Posted October 23, 2021 Hello, I have it listed as another event. Error Msg: 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 tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,lastname, firstname,birthdate,birthplace, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e112 ON tng_people.personID = e112.persfamID AND tng_people.gedcom = e112.gedcom AND e112.eventtypeID = "112" WHERE (LIKE "e112.eventdate%" != "") ORDER BY lastname,firstname LIMIT 300 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 'LIKE "e112.eventdate%" != "") ORDER BY lastname,firstname LIMIT 300' at line 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.