AnsweredAssumed Answered

Patch not adding a custom field's definition in fields_meta_data table

Question asked by ananth ananth on Oct 27, 2014
Latest reply on Oct 27, 2014 by Jeff Bickart

I have created a patch with custom field details. When i try to apply that patch in a new instance, a particular field definition is not added to the fields_meta_data table. So I am facing the an following Fatal error when i try to access the "Detail View" or "Edit View".

So i added the field definition in the database table using a following direct query. Then its working fine. But i'm trying to create the field without this step.

Query :

INSERT INTO 'db_sugar_sugarcrm'.'fields_meta_data' ('id', 'name', 'vname', 'comments', 'help', 'custom_module', 'type', 'len', 'required', 'default_value', 'date_modified', 'deleted', 'audited', 'massupdate', 'duplicate_merge', 'reportable', 'importable', 'ext1', 'ext2', 'ext3', 'ext4') VALUES ('Casesnum_exp_abiertos_c', 'num_exp_abiertos_c', 'LBL_NUM_EXP_ABIERTOS_C', '', '', 'Cases', 'int', '50', '0', NULL, '2014-10-27 13:26:05.000000', '0', '0', '0', '0', '1', 'true', NULL, NULL, NULL, '');


Fatal error:  Smarty error: [in cache/modules/Cases/EditView.tpl   line 5540]: syntax error: unbalanced parenthesis in if statement   (Smarty_Compiler.class.php, line 1268)

Any help would be greatly appreciated.