Ticket #5307 (closed defect: fixed)

Opened 2 years ago

Last modified 1 year ago

Campaign Related Getting Lost

Reported by: prasad Assigned to: vikas
Priority: major Milestone: 5.1.0
Component: vtigercrm Version: 5.0.4
Keywords: Cc:

Description (Last modified by prasad)

I create a campaign "Mailing 1". Then I load a list of (view) from contacts:

- If there were any contacts with same lastname only one of them will be stored

- If I use the same list on another campaign (lets say "Mailing 2"), all entries on "Mailing 1" will be deleted.

Change History

07/17/08 00:27:21 changed by prasad

  • description changed.

The problem is more likely to be due to the DELETE SQL in use.

In the file modules/Campaigns/LoadList.php @ ~line 32

Replace: 

    $sql = "delete from $reltable where $relid = ?";
    $adb->pquery($sql, array($row["crmid"]));

With: 

    $sql = "delete from $reltable where $relid = ? and campaignid=?";
    $adb->pquery($sql, array($row["crmid"],$_REQUEST["return_id"]));

07/17/08 01:25:45 changed by asha

  • status changed from new to closed.
  • resolution set to fixed.

This issue has been fixed and integrated. Please refer to the changeset #12089

Regards, Asha

11/07/08 03:08:33 changed by nitin

  • status changed from closed to reopened.
  • resolution deleted.

this part of the issue is still not fixed:

if we are using load list option and If there were contacts with same last name only one of them will be stored

03/10/09 02:23:35 changed by asha

  • status changed from reopened to new.
  • owner changed from developer to vikas.

03/10/09 02:24:14 changed by asha

  • status changed from new to closed.
  • resolution set to fixed.

This issue is fixed and the changes are integrated with the following changeset - http://trac.vtiger.com/cgi-bin/trac.cgi/changeset/12418