Use PHPMaker 2020.0.5I have downloaded the program and the demo from the web, and installed without problems.
There is a bug in one of the links:Quarterly Orders by ProductThis is the error:Failed to execute SQL. Error: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘orders_by_product.OrderDate’ which is not in SELECT list; this is incompatible with DISTINCT (3065)It is the same error that I give in my project, when I make a report and select Ext. Search in a date field
I have done many tests selecting in Report Settings “Relative years” and in Date Inerval “Year”…
Also using the select lookup and other options with the same result.
Make sure that you are always using the latest template (Tools → Update Template). Also enable debug (Tools → Advanced Settings → Debug) to show the running SQL.