Saving and updating custom fields data

[jones70]

We have had a lot of problems with saving and updating data in custom fields. We started with 3.0c version and created some custom fields to Accounts, Contacts, Calls, Appointments and Opportunities with Sugar Studio. First we had problems with dropdowns options, which did not show up in certain custom field especially in call module. We inserted loading of custom field dropdown list directly to ediview.php file and it solved problem.

Later we noticed that part of the custom fields data won't be inserted or updated to database. if we have eg. 6 custom fields in Opportunity. 2 will be inserted and updated fine (row is created to opportunity_cstm -table), but rest of custom field data won't be saved. However if I edit just inserted record and save it again, all data will be saved fine. Most of the problems are related to Call and Opportunity modules. Accounts, Appointments and Contacts are more stable.

We have also noticed that different custom fields are not working in different installations. Eg. we have 2 installations on our web server. One of these does not save any Opportunity custom field data and other is not saving one custom field data.

Last week we updated to 3.5.0c and problems did not vanish. Actually custom fields are now more untable than with version 3.0c.

I read posts from forum concerning this and find couple of reasons (eg. database rights). However did not find anything similar.

Most confusing is that different installations with same php/html -files on same server are working diffrerently. Only idea which I have not tested yet is to test with clean database to see if old data is cousing problems. Any other ideas?

[jones70]

I managed to fix Opportunity custom fields working by creating Editview.html again. There is still problems with call custom field data update. Looks like dropdown fields are working but text area and date fields are not. Data is saved fine, but it won't show up in edit form.

[mangesh1757]

Hi,

Seems to be a quite old post but in case if any ones stuck at same issue can make things work by clearing cache by using below code at location,
<root directory>\custom\modules\<module name>\controller.php

function action_editview() {
//Starts : Clearing cache
$mod_strings = return_module_language('en_us', 'Administration');
require_once('modules/Administration/QuickRepairAndRebuild.php');
$clear_cache=new RepairAndClear();
$clear_cache->repairAndClearAll(array('clearTpls'),array('<modu le name>'),false,false);
$mod_strings = return_module_language('en_us', '<module name>');
//Ends : Clearing cache
}

Thanks.