Records displayed in Statistics even after deleting tickets in Osticket v1.7
Open class.ticket.php file.
Find:
$sql = 'DELETE FROM '.TICKET_TABLE.' WHERE ticket_id='.$this->getId().' LIMIT 1';
if(!db_query($sql) || !db_affected_rows())
return false;
Replace with:
$sql = 'DELETE FROM '.TICKET_TABLE.' WHERE ticket_id='.$this->getId().' LIMIT 1';
$sql1 = 'DELETE FROM '.TICKET_EVENT_TABLE.' WHERE ticket_id='.$this->getId();
if(!db_query($sql) || !db_query($sql1) || !db_affected_rows())
return false;
Save and refresh.