Thread Details
  • State Not Answered
  • Replies 6 replies
  • Subscribers 354 subscribers
  • Views 1075 views
  • Users 0 members are here
Forum Actions
Related

Cannot Download Import Template

Benjie Monterde

Help,

We added custom relate fields to the leads module using vardefs, and these fields are stored in the cstm table. However, when we tried to download the import template, we encountered an error message that says "Database failure. Please refer to sugarcrm.log for details."

Upon checking the logs, we discovered that SugarCRM is fetching the custom relate fields we created from the core table instead of the cstm table, which is causing the error.

We're currently investigating why SugarCRM is not referencing the correct table and exploring possible solutions to address this issue. If you have any insights or suggestions, we would appreciate your input.

We found on fix but it creates another problem. We added the the "custom_module" in the vardef of the relate field the input element becomes unacceptable some becomes text fields.

Thank you.

Parents Reply Children
  • 0 in reply to Benjie Monterde

    I suppose that you create a vardef file that contains the name, field type etc.

    I you try to create a field from the studio (same type that the one you created from code), you will see that Sugar will create a new entry in the fields_meta_data table and maybe a sugarfield_xxxx.php file in the custom folder with additionnal parameter.

    So the ID, if you want to keep the fields in the _cstm class is

    * to remove the custom vardef file

    * to create the field from the studio OR manually to create the corresponding line in the DB

    If you want more help, maybe you can share here your vardef.