Thread Details
  • State Not Answered
  • Replies 6 replies
  • Subscribers 354 subscribers
  • Views 1070 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
  • 0

    Hi ,

    if you created your fields through vardefs, Sugar is expecting those fields to be in the core table and not the _cstm (dedicated to fields created from the studio and declared in fields_meta_data table.

    I supposed that, if you launch a quick repair, Sugar will propose a SQL query to align your vardef definition with the core table (so an alter table order to create the missing fields). This should solve your problem (and you will also need to delete the fields you created on the cstm table).

    Other option : change your vardef definition to fields_meta_data definition.

    Fred

Reply
  • 0

    Hi ,

    if you created your fields through vardefs, Sugar is expecting those fields to be in the core table and not the _cstm (dedicated to fields created from the studio and declared in fields_meta_data table.

    I supposed that, if you launch a quick repair, Sugar will propose a SQL query to align your vardef definition with the core table (so an alter table order to create the missing fields). This should solve your problem (and you will also need to delete the fields you created on the cstm table).

    Other option : change your vardef definition to fields_meta_data definition.

    Fred

Children