How to reproduce the bug:
- Create a table like this:
CREATE TABLE BIRTHDAY
(
NAME CHAR(50) NOT NULL,
BIRTHDAY DATE NOT NULL
)
- Populate the table with few records:
INSERT INTO BIRTHDAY (NAME,BIRTHDAY) VALUES (‘FRED’,‘2/2/1971’)
INSERT INTO BIRTHDAY (NAME,BIRTHDAY) VALUES (‘TOM’, ‘2/2/1971’)
INSERT INTO BIRTHDAY (NAME,BIRTHDAY) VALUES (‘JOHN’,‘2/2/1971’)
- Create a grid application on BIRTHDAY table with this sql select clause. This clause computes how many birthdays there are in a month (for the sake of this example the year is not important).
SELECT
MONTH(BIRTHDAY) AS MONTH,
COUNT(*) AS NUMBER_OF_BIRTHDAY
FROM
BIRTHDAY
GROUP BY
MONTH(BIRTHDAY)
-
Enable charting against NUMBER_OF_BIRTHDAY using MONTH as a label column (see image1 attached)
-
Generate the app and run. Press the graph icon (see image2 attached) and you will get this error:
Fatal error: Call to undefined function 2() in /opt/NetMake/v81/wwwroot/scriptcase/app/TestBug/grid_BIRTHDAY_1/grid_BIRTHDAY_1_grafico.class.php on line 600
…