i created a graph ‘single stats’, everything is ok when in my request MYSQL find a value to display. But if my request find nothing, i have this message : “Found row with no time value”
Climbing_time --> datetime
here my request :
SELECT UNIX_TIMESTAMP(opening_time) as time_sec, count(id) as value, id as metric FROM communication WHERE (opening_time BETWEEN DATE_SUB(CURDATE(), interval 24 HOUR) AND DATE_ADD(CURDATE(), interval 7 HOUR)) AND (status = 'OUVERTURE' OR status = 'INFORMATION' OR status = 'OPÉRATION')
some people can help me ?