Extra fields showing up in Opportunity Change Log

[marclangston]

Whenever a user Edits an Opportunity, the Change Log shows that change as well as a lines for two other (custom) fields. The image below shows an example of what I see when a user changed just the expected close date; even though no changes were made to those other two fields, they show up in the change log.

Can anybody provide some ideas about where I can look to investigate why this is happening? It hasn't always been the case; it's possible that it started when we upgraded to 6.1.0 (CE) a few months ago and nobody noticed it until now.

Thanks for any insight.
marc

[andopes]

Can you confirm if the database under your SugarCRM is MS SQL?

Regards

[marclangston]

No, actually, it's MySQL. I believe it's version 5.1.
marc

[andopes]

Are you able to reproduce that issue anytime?
If you can reproduce it again then go to Admin -> System Settings and set Log Level to debug.
Clean up the file sugarcrm.log and try again.
Open sugarcrm.log and look for any log entry regarding that field.
Zip the sugarcrm.log and attach it into your next post.

Regards

[marclangston]

For this example I converted a lead to an opportunity (85ec34d6-e990-b799-06c5-4de4f5864189) and then changed the sales stage. I've attached a segment of the debug log file, starting just before the first instance of the new opportunity's mention and ending just after the last mention. The changes appear to be in the log around lines 1670-1700; the audit lines are specifically 1687-1691:

5/31/2011 4:04:14 PM [11004][1c30fd26-7a6d-4241-1109-4aae955d5e1c][INFO] Query:INSERT INTO opportunities_audit(id,parent_id,field_name,data_t ype,before_value_string,after_value_string,date_cr eated,created_by) VALUES('a6a7d3b1-40d9-6154-706b-4de4f5570c3f','85ec34d6-e990-b799-06c5-4de4f5864189','sales_stage','enum','First Appointment','Gathering Information','2011-05-31 14:04:14','1c30fd26-7a6d-4241-1109-4aae955d5e1c')

5/31/2011 4:04:14 PM [11004][1c30fd26-7a6d-4241-1109-4aae955d5e1c][INFO] Query Execution Time:0.012862920761108

5/31/2011 4:04:14 PM [11004][1c30fd26-7a6d-4241-1109-4aae955d5e1c][INFO] Query:INSERT INTO opportunities_audit(id,parent_id,field_name,data_t ype,before_value_string,after_value_string,date_cr eated,created_by) VALUES('aa0ef57f-5dfa-e882-07e0-4de4f5da1391','85ec34d6-e990-b799-06c5-4de4f5864189','cpe_nrc_amount_c','currency','0.00' ,'0','2011-05-31 14:04:14','1c30fd26-7a6d-4241-1109-4aae955d5e1c')

5/31/2011 4:04:14 PM [11004][1c30fd26-7a6d-4241-1109-4aae955d5e1c][INFO] Query Execution Time:0.012866020202637

5/31/2011 4:04:14 PM [11004][1c30fd26-7a6d-4241-1109-4aae955d5e1c][INFO] Query:INSERT INTO opportunities_audit(id,parent_id,field_name,data_t ype,before_value_string,after_value_string,date_cr eated,created_by) VALUES('ad7489fd-d8ec-928b-35ae-4de4f5077097','85ec34d6-e990-b799-06c5-4de4f5864189','nrc_amount_c','currency','0.00','0' ,'2011-05-31 14:04:14','1c30fd26-7a6d-4241-1109-4aae955d5e1c')

It's puzzling that there are three separate audits recorded, one for the item I changed, one for the cpe_nrc_amount, and one for nrc_amount_c. I did not make changes to either of the "nrc" values during my edit.

I'll take a look at the code to see if there is something weird in the opportunities Edit section although I don't believe anything has been changed/customized there. Thanks for any ideas you can provide.
marc

[ZeeG]

I'm having the exact same problem..

Any help would be great

[andopes]

I'm having the exact same problem..

Any help would be great

Can you confirm the version of your SugarCRM instance?
Follow the same steps I requested marclangston to follow.
Additionally provide us the cached vardefs for the buggy module.

Regards