Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Leads Not saving data

  1. 2011-08-10, 09:29 PM #1
    art G
    art G is offline Sugar Community Member
    Join Date
    Dec 2010
    Posts
    46

    Default Leads Not saving data

    I am not sure what happened, but whenever I edit a Lead and try to put something inside the new fields that I have created it will not save the data.

    I have a dev server with same info and same db but that one works, not sure what happened to live one.

    Where do I look for changes and which file does the Lead calls when saving?
    Or would it be easier to swap the file from dev server, but again not sure which file i should be replacing.

    Thx
    Reply With Quote Reply With Quote
  2. 2011-08-10, 10:13 PM #2
    Angel's Avatar
    Angel
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Leads Not saving data

    Performing a Quick Repair and Rebuild via Admin > Repair tends to resolve these types of issues on a lot of occasions.
    Regards,

    Angel Magaña
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________
    Reply With Quote Reply With Quote
  3. 2011-08-10, 10:16 PM #3
    art G
    art G is offline Sugar Community Member
    Join Date
    Dec 2010
    Posts
    46

    Default Re: Leads Not saving data

    Done quick repair and rebuild didn't work
    Reply With Quote Reply With Quote
  4. 2011-08-10, 10:18 PM #4
    Angel's Avatar
    Angel
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Leads Not saving data

    Check the sugarcrm.log fatal for any SQL errors. Chances are it is trying to save to a column name that doesn't exist.
    Regards,

    Angel Magaña
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________
    Reply With Quote Reply With Quote
  5. 2011-08-10, 10:20 PM #5
    art G
    art G is offline Sugar Community Member
    Join Date
    Dec 2010
    Posts
    46

    Default Re: Leads Not saving data

    Quote Originally Posted by Angel View Post
    Check the sugarcrm.log fatal for any SQL errors. Chances are it is trying to save to a column name that doesn't exist.
    Can you tell me which directory that file is located?
    Reply With Quote Reply With Quote
  6. 2011-08-10, 10:22 PM #6
    Angel's Avatar
    Angel
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Leads Not saving data

    I noticed I threw in an extra "fatal" in there after sugarcrm.log, ignore that. The sugarcrm.log file is in the root install directory, usually sugarcrm.
    Regards,

    Angel Magaña
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________
    Reply With Quote Reply With Quote
  7. 2011-08-10, 11:46 PM #7
    art G
    art G is offline Sugar Community Member
    Join Date
    Dec 2010
    Posts
    46

    Default Re: Leads Not saving data

    Quote Originally Posted by Angel View Post
    I noticed I threw in an extra "fatal" in there after sugarcrm.log, ignore that. The sugarcrm.log file is in the root install directory, usually sugarcrm.
    ok i got the log file there are lots of:

    Wed Aug 10 16:15:01 2011 [30605][1][FATAL] Error fetching relationship from cache schedulers_created_by_rel

    and couple other ones :

    Wed Aug 10 14:55:47 2011 [5852][86010780-ca76-361a-09d8-4dd4022cf2f0][FATAL] Error fetching relationship from cache quotes_billto_accounts
    Reply With Quote Reply With Quote
  8. 2011-08-11, 01:08 AM #8
    Angel's Avatar
    Angel
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Leads Not saving data

    I assume you couldn't find any that reference MySQL within the batch of fatal errors that you did get?

    Another idea worth trying is temporarily renaming the custom/modules/Leads folder to something else. i.e. Leads.ORI, and then rebuilding and trying it again. That would tell us if it is a customization that's been applied that causing it.
    Regards,

    Angel Magaña
    Co-Author: Implementing SugarCRM 5.x (Packt Publishing -- Sept. 2010)
    Blog: http://cheleguanaco.blogspot.com.
    Twitter: @cheleguanaco.

    ________
    | Projects: |_____________________________________
    |
    | CandyWrapper (.NET Wrapper for SugarCRM SOAP API). Source now available on GitHub!
    | GoldMine to SugarCRM Express Conversion. Latest: 1.0.1.7 (Nov. 3, 2009)
    | CRM SkyDialer (Skype Integration). Latest: 1.0.2 (Feb. 17, 2010)
    | Round Robin Leads Assignment
    | Phone Number Formatter
    | CaseTwit (Twitter Integration)
    ______________________________________________
    Reply With Quote Reply With Quote
  9. 2011-08-11, 11:32 AM #9
    andopes's Avatar
    andopes
    andopes is offline A Sugar Hero | Help Forum Moderator
    Send a message via MSN to andopes Send a message via Skype™ to andopes
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Leads Not saving data

    Quote Originally Posted by art G View Post
    ok i got the log file there are lots of:

    Wed Aug 10 16:15:01 2011 [30605][1][FATAL] Error fetching relationship from cache schedulers_created_by_rel

    and couple other ones :

    Wed Aug 10 14:55:47 2011 [5852][86010780-ca76-361a-09d8-4dd4022cf2f0][FATAL] Error fetching relationship from cache quotes_billto_accounts
    Delete script cache/modules/Relationships/relationship.cache.php
    Go to Admin -> Repair -> Quick Repair and Rebuild
    Try again

    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.
    Reply With Quote Reply With Quote
  10. 2011-08-11, 04:51 PM #10
    art G
    art G is offline Sugar Community Member
    Join Date
    Dec 2010
    Posts
    46

    Default Re: Leads Not saving data

    Quote Originally Posted by andopes View Post
    Delete script cache/modules/Relationships/relationship.cache.php
    Go to Admin -> Repair -> Quick Repair and Rebuild
    Try again

    Regards
    I tried that didnt work.
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Saving data manually
    By nimjec101 in forum Developer Help
    Replies: 0
    Last Post: 2010-11-25, 04:59 AM
  2. No Response from Sugar on saving data
    By fabivomsee in forum Help
    Replies: 2
    Last Post: 2009-03-24, 11:11 AM
  3. No data saving in Opportunities
    By Deland01 in forum Help
    Replies: 2
    Last Post: 2007-05-11, 05:51 PM
  4. Custom Field data not saving
    By erick.wolfe in forum Help
    Replies: 0
    Last Post: 2006-09-21, 07:04 PM
  5. Not saving data
    By pfo in forum Help
    Replies: 2
    Last Post: 2006-07-17, 10:30 AM

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
  •  

Forum Rules