Results 1 to 3 of 3

Thread: Newbie - custom field display problems

  1. #1
    rhoyle is offline Junior Member
    Join Date
    Oct 2008
    Posts
    2

    Question Newbie - custom field display problems

    Can someone help? I am new to Sugar, and cant find an answer to what is happening when I create custom fields.

    As soon as I create a custom field under contacts, the contacts view does not display the contacts for any user.
    If I delete the field the data is then displayed once again.

    The same happens under Accounts. If I create a field the data disapears, cant be searched and no user can see it. When I delete the field all is restored.

    The account and contact data are only hidden when a field is created under that section.

    Im using 5.1.0

    Thanks
    R

  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: Newbie - custom field display problems

    Hi rhoyle

    It is due a query error while listing all Accounts/Contacts.
    Open the file include/ListView/ListViewData.php and add the line

    PHP Code:
    echo "<PRE>$main_query"
    Just after the line

    PHP Code:
    $main_query $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
    Save the file, create a new custom field in Accounts and go to Accounts module.
    A query will be displayed above the ListView pagination.

    Let me know this query.

    Cheers
    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
    rhoyle is offline Junior Member
    Join Date
    Oct 2008
    Posts
    2

    Default Re: Newbie - custom field display problems

    Thanks for the help, will have a play with it

    Cheers

    R

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 2006-06-06, 07:56 PM
  2. Custom Field Issue still lingering
    By rengstrom in forum General Discussion
    Replies: 9
    Last Post: 2005-06-07, 07:37 AM
  3. Problems With Custom Field
    By CoreyMcF in forum Developer Help
    Replies: 8
    Last Post: 2005-02-28, 10:34 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
  •