Fix #13644 Deleting an issue with assigned sponsorship throws error

atrol · atrol · commit 4a0510905483 · 2011-12-02T16:57:02.000+01:00
diff --git a/core/bug_api.php b/core/bug_api.php
@@ -1136,7 +1136,7 @@ function bug_delete( $p_bug_id ) {
 	bugnote_delete_all( $p_bug_id );
 
 	# Delete all sponsorships
-	sponsorship_delete( sponsorship_get_all_ids( $p_bug_id ) );
+	sponsorship_delete_all( $p_bug_id );
 
 	# MASC RELATIONSHIP
 	# we delete relationships even if the feature is currently off.
diff --git a/core/sponsorship_api.php b/core/sponsorship_api.php
@@ -352,6 +352,23 @@ function sponsorship_set( $p_sponsorship ) {
 	return $t_sponsorship_id;
 }
 
+/**
+ * delete all sponsorships of a bug
+ * @param int $p_bug_id
+ * @return null
+ */
+function sponsorship_delete_all( $p_bug_id ) {
+	$c_bug_id = db_prepare_int( $p_bug_id );
+
+	$t_sponsorship_table = db_get_table( 'sponsorship' );
+
+	$query = "DELETE FROM $t_sponsorship_table
+				  WHERE bug_id=" . db_param();
+	db_query_bound( $query, $c_bug_id );
+
+	sponsorship_clear_cache( );
+}
+
 /**
  * delete a sponsorship given its id
  * id can be an array of ids or just an id.
