Results 1 to 2 of 2

Thread: Saving new lead error

  1. #1
    warish is offline Junior Member
    Join Date
    Nov 2007
    Posts
    3

    Default Saving new lead error

    I just installed 4.5.1.g and I am having a problem when I try to save a new lead from the main leads page. I am getting the following SQL error:

    Retrieving record by id leads:e2cf881d-76e2-48e4-d731-472a60a5558a found Query Failed:SELECT leads.* , leads_cstm.* FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c WHERE leads.id = 'e2cf881d-76e2-48e4-d731-472a60a5558a' AND leads.deleted=0 LIMIT 0,1::MySQL error 1146: Table 'sugarcrm.leads_cstm' doesn't exist

    This was the first thing I tried to do after I installed it. What are the minimum permissions that the db user needs? And are permissions what is wrong?

    Thanks,

    Warren

  2. #2
    Angel's Avatar
    Angel is offline Sugar Community Member
    Join Date
    Jul 2005
    Location
    Los Angeles
    Posts
    4,813

    Default Re: Saving new lead error

    See if the following helps...

    Login as admin, access Studio in the Admin control panel and then click "Repair Custom Fields."
    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)
    ______________________________________________

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 2007-09-20, 03:51 AM
  2. Replies: 0
    Last Post: 2007-08-08, 02:47 PM
  3. From lead to order
    By george_bbch in forum Feature Requests
    Replies: 0
    Last Post: 2006-09-26, 02:02 PM
  4. Module builder help
    By sjilumudi in forum Downloads
    Replies: 3
    Last Post: 2006-08-18, 11:25 PM

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
  •