=====statsNextTicketStatusTableNotPopulated=====

**Level:** Major :!:


**Purpose:** This alert checks whether there are entries in the reporting_stats.stats_next_ticket_status table within a time period and if there are no rows found we will be alerted

**Scenario:** When this query returns 0 rows<WRAP center round box 60%>
SELECT CASE WHEN DATE_FORMAT(NOW(), '%H:%i:%s') BETWEEN '00:00:00' AND '00:05:00' THEN 1 WHEN DATE_FORMAT(NOW(), '%H:%i:%s') NOT BETWEEN '00:00:00' AND '00:05:00' THEN COUNT(*) END as 'count(*)
</WRAP>


**Resolution:** In the past the resolution has been to disable the //--secure-file-priv// option in mysql

**Manual Action Steps:** Check the cron logs for this error 
<WRAP center round box 60%>
//ERROR 1290 (HY000) at line 19: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement//
</WRAP>
 
edit the /etc/my.cnf and disable this option in the mysql startup setting

**Auto Clear:** Will clear when data is found for the query