Newbie - custom field display problems

[rhoyle]

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

[andopes]

Hi rhoyle

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

 echo "<PRE>$main_query"; 
  

Just after the line

 $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

[rhoyle]

Thanks for the help, will have a play with it

Cheers

R