[ 
https://issues.apache.org/jira/browse/VCL-881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14619223#comment-14619223
 ] 

ASF subversion and git services commented on VCL-881:
-----------------------------------------------------

Commit 1689944 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1689944 ]

VCL-881 - cannot delete schedules

modified toggleDeleteResource - moved call to 
$this->submitToggleDeleteResourceExtra to before the query to delete the entry 
from the specific resource (i.e. "schedule" table, not "resource" table) table 
so that foreign key constraints on any entries deleted by the Extra function 
will not prevent the entry from being deleted from the specific resource table

> cannot delete schedules
> -----------------------
>
>                 Key: VCL-881
>                 URL: https://issues.apache.org/jira/browse/VCL-881
>             Project: VCL
>          Issue Type: Bug
>          Components: web gui (frontend)
>    Affects Versions: 2.4.2
>            Reporter: Josh Thompson
>             Fix For: 2.4.3
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to