Editing a module with custom fields creates a duplicate record in the "_cstm" table

[bretweinraub]

OS: Redhat EL 4
Sugar Version : 4.5.1d (bundle)

We have a strange problem involving duplicate records.

For our opportunities module, we have added a single custom column.

Now when editing an opportunity record, a duplicate record in the "_cstm" table is created. This
causes duplicates to appear in the list view.

Many things have been checked and sugar repair buttons clicked, all to no avail. It seems some meta-data
must be out of date somewhere. Fields_meta-data has been checked and looks valid.

Any hints or suggestions appreciated.

[bretweinraub]

A little more information.

If I open the opportunity and edit the custom column, no duplicate _cstm record is created. All the existing _cstm records (with the matching 'id') are updated in this case.

Its only when editing a non-custom column that the duplicate is created.

I'm assuming the logic of this is in SugarBean.php .....

[bretweinraub]

For no apparent reason I can resolve this problem by

- droping the columns from *_cstm
- deleting the entries from fields_meta_data
- re-adding the rows to *_cstm
- re-adding the rows to fields_meta_data
- deleting the cache/dynamic_fields/*/fields.php file

things that make ya go hmmmmmmm

[ffeog]

I haven't tried bret's solution yet, but I'm having a duplicate records problem - so far in calls and emails and seemingly related to when a lead is promoted to a contact or account added, the related email/call is duplicated/triplicated in the list view. I post this here because I'm also using a custom field so this might be the cause of it, but it certainly looks like a bug to me. I'm using Sugar OS 4.5.1g

[kuske]

Please give more details, this custom field, how did you define it excatly?
Perhaps it happens only for such fields.

hk

[bretweinraub]

I haven't tried bret's solution yet, but I'm having a duplicate records problem - so far in calls and emails and seemingly related to when a lead is promoted to a contact or account added, the related email/call is duplicated/triplicated in the list view. I post this here because I'm also using a custom field so this might be the cause of it, but it certainly looks like a bug to me. I'm using Sugar OS 4.5.1g

What database type/version are you using? One of my subcontractors has hit this in the mean time and they believe they've developed a bug fix in

if((($this->db->dbType=='mysql' || $this->db->dbType=='mssql') && $this->db->getAffectedRowCount($result) == 0) || (($this->db->dbType=='oci8' ) && $this->db->getRowCount($result) == 0) ){
echo'ttt';
$this->db->query($queryInsert);
}

from

modules/DynamicField/DynamicField.php

Looks like mysql was always showing getAffectedRowCount as 0 - and was thus creating duplicate records.

I'll post some more about this if I get a little more info