Contacts transfer ownership fails to transfer related Opportunites ownership

Discussion Ref

This is due to relation between Contacts to Opportunites is not pushed to table 'vtiger_contpotentialrel' table. Where as while transferring ownership it will fetch records details from this table.

FWIW a grep of the 7.4.0 branch reveals the following for "contpotentialrel":

./vtlib/Vtiger/Functions.php:977:			"vtiger_contpotentialrel:contactid" => "V",
./vtlib/Vtiger/Functions.php:978:			"vtiger_contpotentialrel:potentialid" => "V",
./include/Webservices/ConvertLead.php:160:			$sql = "insert into vtiger_contpotentialrel values(?,?)";
./data/CRMEntity.php:2490:			// To get all the Contacts from vtiger_contpotentialrel table
./data/CRMEntity.php:2491:			$condition .= " OR $table_name.potentialid = vtiger_contpotentialrel.potentialid";
./data/CRMEntity.php:2492:			$query .= " left join vtiger_contpotentialrel on  vtiger_contpotentialrel.contactid = vtiger_contactdetails.contactid";
./data/CRMEntity.php:2494:			// To get all the Potentials from vtiger_contpotentialrel table
./data/CRMEntity.php:2495:			$condition .= " OR $table_name.contactid = vtiger_contpotentialrel.contactid";
./data/CRMEntity.php:2496:			$query .= " left join vtiger_contpotentialrel on vtiger_potential.potentialid = vtiger_contpotentialrel.potentialid";
./schema/DatabaseSchema.xml:1483:	<table name="vtiger_contpotentialrel">
./schema/DatabaseSchema.xml:1494:		<index name="contpotentialrel_potentialid_idx">
./schema/DatabaseSchema.xml:1497:		<index name="contpotentialrel_contactid_idx">
./schema/DatabaseSchema.xml:1503:	<table name="vtiger_contpotentialrel" alter="true">
./schema/DatabaseSchema.xml:1504:		<constraint>ADD CONSTRAINT fk_1_vtiger_contpotentialrel FOREIGN KEY (contactid) REFERENCES vtiger_contactdetails(contactid) ON DELETE CASCADE</constraint>
./schema/DatabaseSchema.xml:1505:		<constraint>ADD CONSTRAINT fk_2_vtiger_contpotentialrel FOREIGN KEY (potentialid) REFERENCES vtiger_potential(potentialid) ON DELETE CASCADE</constraint>
./modules/Contacts/Contacts.php:357:		left join vtiger_contpotentialrel on vtiger_contpotentialrel.contactid=vtiger_contactdetails.contactid
./modules/Contacts/Contacts.php:358:		left join vtiger_potential on (vtiger_potential.potentialid = vtiger_contpotentialrel.potentialid or vtiger_potential.contact_id=vtiger_contactdetails.contactid)
./modules/Contacts/Contacts.php:1259:		$rel_table_arr = Array("Potentials"=>"vtiger_contpotentialrel","Potentials"=>"vtiger_potential","Activities"=>"vtiger_cntactivityrel",
./modules/Contacts/Contacts.php:1266:		$tbl_field_arr = Array("vtiger_contpotentialrel"=>"potentialid","vtiger_potential"=>"potentialid","vtiger_cntactivityrel"=>"activityid",
./modules/Contacts/Contacts.php:1273:		$entity_tbl_field_arr = Array("vtiger_contpotentialrel"=>"contactid","vtiger_potential"=>"contact_id","vtiger_cntactivityrel"=>"contactid",
./modules/Contacts/Contacts.php:1487:			$sql = 'DELETE FROM vtiger_contpotentialrel WHERE contactid=? AND potentialid=?';
./modules/Contacts/Contacts.php:1561:				$adb->pquery("insert into vtiger_contpotentialrel values(?,?)", array($crmid, $with_crmid));
./modules/Contacts/Contacts.php:1591:        $query = "SELECT DISTINCT vtiger_crmentity.crmid FROM vtiger_contactdetails LEFT JOIN vtiger_contpotentialrel ON 
./modules/Contacts/Contacts.php:1592:            vtiger_contpotentialrel.contactid = vtiger_contactdetails.contactid LEFT JOIN vtiger_potential ON 
./modules/Contacts/Contacts.php:1593:            (vtiger_potential.potentialid = vtiger_contpotentialrel.potentialid OR vtiger_potential.contact_id = 
./modules/Contacts/models/Module.php:174:						LEFT JOIN vtiger_contpotentialrel ON vtiger_contpotentialrel.contactid = vtiger_contactdetails.contactid
./modules/Contacts/models/Module.php:176:						WHERE deleted = 0 AND (vtiger_contpotentialrel.potentialid = ? OR vtiger_potential.potentialid = ?)
./modules/Contacts/models/Module.php:309:				case 'Potentials'	: $tableName = 'vtiger_contpotentialrel';	$fieldName = 'contactid';	$relatedFieldName ='potentialid';	break;
./modules/Vtiger/models/Module.php:1684:                        $tablename = 'vtiger_contpotentialrel';
./modules/Vtiger/models/Module.php:1703:							$tablename = 'vtiger_contpotentialrel';
./modules/Potentials/Potentials.php:238:					left join vtiger_contpotentialrel on vtiger_contpotentialrel.potentialid = vtiger_potential.potentialid
./modules/Potentials/Potentials.php:239:					inner join vtiger_contactdetails on ((vtiger_contactdetails.contactid = vtiger_contpotentialrel.contactid) or (vtiger_contactdetails.contactid = vtiger_potential.contact_id))
./modules/Potentials/Potentials.php:614:		$rel_table_arr = Array("Activities"=>"vtiger_seactivityrel","Contacts"=>"vtiger_contpotentialrel","Products"=>"vtiger_seproductsrel",
./modules/Potentials/Potentials.php:618:		$tbl_field_arr = Array("vtiger_seactivityrel"=>"activityid","vtiger_contpotentialrel"=>"contactid","vtiger_seproductsrel"=>"productid",
./modules/Potentials/Potentials.php:622:		$entity_tbl_field_arr = Array("vtiger_seactivityrel"=>"crmid","vtiger_contpotentialrel"=>"potentialid","vtiger_seproductsrel"=>"crmid",
./modules/Potentials/Potentials.php:753:			$sql = 'DELETE FROM vtiger_contpotentialrel WHERE potentialid=? AND contactid=?';
./modules/Potentials/Potentials.php:761:			// Potential directly linked with Contact (not through Account - vtiger_contpotentialrel)
./modules/Potentials/Potentials.php:780:				$sql = "insert into vtiger_contpotentialrel values (?,?)";
./modules/Accounts/Accounts.php:351:		// These relations are captued in vtiger_contpotentialrel

Milestone removed

This problem has been functioning properly in the latest source code. Please verify and reopen the issue if it still persists.

closed

changed the description

changed milestone to %8.1.0

@apparao Please can you link your comment and closing of this ticket to a commit? I'd like to know what was changed to address this particular issue.

@lord_alan - In our release validation (8.1.0), the QA team has confirmed that this issue is functioning correctly. Please double-check the latest source (master).

If you require an actual fix for this issue, I will verify and provide you with an update shortly.