[VCL-881] Schedules cannot be deleted from web UI

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.2
• Fix Version/s: 2.5
• Component/s: web gui (frontend)
• Assignee: Unassigned
• Reporter: Josh Thompson
• Created: 08/Jul/15 16:59
• Updated: 12/Aug/15 17:10
• Resolved: 08/Jul/15 19:38

Description

Schedules cannot be deleted. In toggleDeleteResource in resource.php, the call to $this->submitToggleDeleteResourceExtra($rscid); needs to be moved to be above the query to delete the entry from the resource table.

The problem is that it attempts to delete the entry from the schedule table before deleting any entries from the scheduletimes table, which has a foreign key constraint on the schedule table.