Custom field problems

[Ruskicowboy]

OS: Solaris 10 05/08
Sugar Version: 5.0.0g CE
Webserver: Apache 2
PHP: 5.2.4
Mysql: 5.0.45

It seems that Studio sometimes does not alter the {module_name}_cstm table to reflect a new custom field created. I created 5 different fields for Accounts, and only 2 of them were reflected in the table accounts_cstm. When I deleted the other 3 in Studio and recreated them, 2 more were added to the table. I looked at the permissions for the user I'm using to connect to mysql and it has all privileges. But, or course, if it didn't, it couldn't have created or altered the table anyway.

Also, I added one of the fields to the Accounts listview. it deployed fine, and when other accounts view the listview, it appears without problem. But when I view listview for Accounts, it doesn't display. Any ideas?

[andopes]

Hi, Ruskicowboy
Can you post here the definition for the fields you are trying to create?

Cheers

[Ruskicowboy]

I'm not sure if this is sufficient, but this was what was put into the fields_meta_data table, This was the field I created that was not added to the accounts_cstm table:

id: Accountsmerchantid_c
name: merchantid_c
vname: LBL_MERCHANTID
comments: The Merchant ID for this Account
help: NULL
custom_module: Accounts
type: int
len: 11
required: 0
default_value: NULL
date_modified: 2008-08-07 14:02:09
deleted: 0
audited: 0
massupdate: 0
duplicate_merge: 0
reportable: 0
ext1: NULL
ext2: NULL
ext3: 1
ext4: NULL

This is also the field that shows up fine on other users listview, but not mine.

[andopes]

Hi, Ruskicowboy

It seems to be OK.

Did you try to repair database?

Cheers

[Ruskicowboy]

Ok, I repaired the database...nothing was shown as wrong. I'll have to creating another field later. Any idea about the field not showing up in Accounts listview in my account only?

[Ruskicowboy]

Ok, we are still having problems. A co-worker modified the accounts list view and added 3 more columns in Studio. My account still will not show those columns, nor his. Other accounts show all columns correctly, and some show all but one column correctly. Does anyone have any ideas on this? I've cleared all template and vardef caches, and repaired the database. No change.

[chad.hutchins]

This is out there, but has worked for me in the past....

Turn on 'developer mode' in the system settings, go to the accounts list view and refresh, then turn developer mode back off.

[reginanickles]

I am having similiar problems in Studio adding custom fields in the PROJECT and PROJECT TASKS tables. Sometimes it works, sometimes it doesnt - it's just FLAKEY!!!! My problem is that I add the custom fields, the forms look wonderful, then when I hit the update button - nothing. It's having problems inserting the field, or the fields are just not there, I don't know. I have tried adding the new fields, then went and looked on the CSTM_PROJECT table and they are just not there sometimes, and sometimes it works fine.

This is very flakey. I never know when it is going to work and when it won't. I just cross my fingers.

My feeling is that it has something to do with Caching maybe? Memory - I don't know. And I don't know how to even try to troubleshoot this. I have been looking through this forum and on the net. This is a problem in all tables, not just one. If this can't be fixed, we need to document a code change/work around to manually add these custom fields.

Please advise.

[robhall]

I also have noticed this problem. I have been testing Sugar 5.2.0 CE on Solaris 10 Update 5. When I try to make some modifications to the layout using Studio it works fine on a Solaris SPARC based server. If I am using
Solaris 10 on an X64 based server, same release of OS and Sugar and try to do the same actions to modify a layout, edit a dropdown list or make any changes what so ever, nothing gets saved.

Has anyone else seen this or found what is possible the culprit? Reading this post, I'm going to turn on developer mode logging. Does this get written to the Apache logs for output?

Thanks much for any input on this thread.

[NickB]

Im having the same problems with Editing the layouts on an OpenSolaris Shared Server.

Sugar - Version 5.2.0a.

I can edit the listview but when editing the editview or detailview none of my changes come though. The custom field that i created in version 4.5.1 works fine in edit view (Ie displays and stores data).

Also when i test with non custom fields like salutation, or a panel or extra row. None of that works.

Really frustrating. I have turned on developer mode, repaired and rebuilt everything, chmod'd 777 my customs dir.

I have also chmod'd 775 my sugarcrm dir.

Noticed that my customisations from v4.5.1 are visible in my contacts views, and the fields are availale to drag and drop. But, they are not visible in the panel layout. Even when i create another panel and add various fields to it, i get nothing. My logs arent really giving me much in the way of advice