Bruce Roy Posted July 31, 2019 Report Share Posted July 31, 2019 I have had several reports listing births/deaths/marriages in the last 12 months using the formula: ( Convert to Days Today (true date) - Convert to Days Birth Date (True) < 366 ) but they now produce an error code which I don't understand! 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,treename, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people , tng_trees) WHERE (( TO_DAYS(todayDATE_ADD(NOW(), INTERVAL 15 HOUR)) - TO_DAYS(birthdatetr) < 366 )) AND tng_people.gedcom = "rr_tree" AND tng_people.gedcom = tng_trees.gedcom ORDER BY birthdatetr,lastname,firstname LIMIT 200 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 ')) - TO_DAYS(birthdatetr) < 366 )) AND tng_people.gedcom = "rr_tree" AND tng_pe' 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.