Trouble creating "Last Modified' report.

[Figi4]

I am trying to create a report similar, or exactly if needed, like the one on the demo site.  However I am only getting an error.  I'm simply trying to create a report for persons that have been created and/or modified  in the last 30-60 days.  Thank you.

This is what I have entered for the report:

 

This is what I get in return:

Quote

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,DATE_FORMAT(tng_people.changedate,'%d %b %Y') as changedate_disp, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (TO_DAYS(todayDATE_SUB(NOW(), INTERVAL -5 HOUR)) - TO_DAYS(tng_people.changedate) <= 60) AND tng_people.gedcom = "tree1" ORDER BY changedate,lastname,firstname LIMIT 50

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) - TO_DAYS(tng_people.changedate) <= 60) AND tng_people.gedcom = "tree1" ORDE' at line 1

 

[bhemph]

It looks like there may be an error on lines 250 and 252 of showreport.  They have .= when it looks like they should just be =  You could try making that change to see for sure.  If you are not comfortable doing that, a quick mod could be made for you to verify that is what is wrong.  After verifying that is the problem, then you would need to let Darrin know about the problem and fix so that he can make the correction to TNG itself.

Brent

[Figi4]

Thank you, that fixed it.  I will let him know!