Results 1 to 7 of 7

Thread: Extra fields showing up in Opportunity Change Log

  1. #1
    marclangston is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    98

    Default Extra fields showing up in Opportunity Change Log

    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
    Attached Images Attached Images  

  2. #2
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Extra fields showing up in Opportunity Change Log

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

    Regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  3. #3
    marclangston is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    98

    Default Re: Extra fields showing up in Opportunity Change Log

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

  4. #4
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Extra fields showing up in Opportunity Change Log

    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
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  5. #5
    marclangston is offline Sugar Community Member
    Join Date
    Oct 2009
    Posts
    98

    Default Re: Extra fields showing up in Opportunity Change Log

    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
    Attached Files Attached Files

  6. #6
    ZeeG is offline Sugar Community Member
    Join Date
    May 2011
    Posts
    14

    Default Re: Extra fields showing up in Opportunity Change Log

    I'm having the exact same problem..

    Any help would be great

  7. #7
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Extra fields showing up in Opportunity Change Log

    Quote Originally Posted by ZeeG View Post
    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
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert lead displays extra fields
    By cramermp in forum Help
    Replies: 3
    Last Post: 2011-02-09, 05:36 PM
  2. Extra Fields in accounts
    By time2see in forum General Discussion
    Replies: 6
    Last Post: 2010-04-12, 07:41 PM
  3. Extra fields on a many-to-many relationship
    By craigw9292 in forum Developer Help
    Replies: 3
    Last Post: 2008-07-01, 01:17 PM
  4. Newb question: how to add extra fields?
    By mwillems in forum Help
    Replies: 2
    Last Post: 2006-11-06, 07:04 PM
  5. Question about extra fields
    By summitsys in forum Help
    Replies: 1
    Last Post: 2006-07-27, 06:31 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •