search

setrem / time-tracking-osTicket

Simple time tracking for osTicket.
7 stars 3 forks source link

Error trying to delete ticket with timetracking #6

Open nsnnsn opened 3 years ago

nsnnsn commented 3 years ago

Getting this error:

1451 - Cannot delete or update a parent row: a foreign key constraint fails (debXXXXX_os1.os_ticket_time_tracking, CONSTRAINT ticket_id_time_tracking FOREIGN KEY (ticket_id) REFERENCES os_ticket (ticket_id))

when trying to delete a ticket where timetracking is used.

DELETE FROM os_ticket WHERE os_ticket.ticket_id = 15 LIMIT 1

claudioscheer commented 3 years ago

This is a bug! Thanks for reporting.

Perhaps a better idea would be to remove the constraint between os_ticket_time_tracking and os_ticket, so that we can keep the time tracked even after deleting a ticket.