Fix #13644 Deleting an issue with assigned sponsorship throws error

atrol · atrol · commit fbcd8a63df87 · 2011-12-02T16:53:35.000+01:00
diff --git a/core/bug_api.php b/core/bug_api.php
@@ -1118,7 +1118,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
@@ -346,6 +346,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( 'mantis_sponsorship_table' );
+
+	$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.
