issue adding email field to cases module

I am trying to add the email field to the cases module, I tried to follow the Adding the Emails Field to the Record View from the sugar developer guide and everything seemed to work well, the field appears but when the record is saved it throw me the following error: 

  

HTTP: 500 Internal Server Error

An exception occurred while executing 'SELECT jt0_email_addresses_primary.email_address email FROM cases LEFT JOIN email_addr_bean_rel cases_email_addresses_primary ON (cases_email_addresses_primary.deleted = ?) AND (cases_email_addresses_primary.bean_module = ?) AND (cases_email_addresses_primary.primary_address = ?) LEFT JOIN cases jt0_email_addresses_primary ON (jt0_email_addresses_primary.id = cases_email_addresses_primary.bean_id) AND (jt0_email_addresses_primary.deleted = ?) LEFT JOIN cases_cstm cases_cstm ON cases_cstm.id_c = cases.id WHERE (cases.id = ?) AND (cases.deleted = ?) LIMIT 1' with params [0, "Case", 1, "0", "6d64d318-2e86-11eb-bfbb-02df47d122c6", 0]: Unknown column 'jt0_email_addresses_primary.email_address' in 'field list'

I don't know what can be, if anyone have an idea is welcome, thanks for helping

Parents
  • I put the files of the post, modified for Cases, into an installation package and installed it in a vanilla demo instance.

    The result seems to work.

    The installable:

    Cases_Email.zip

    Perhaps you should check your custom/Extension/application/Ext/Include/ and custom/Extension/modules/Cases/Ext/Vardefs/ directories for any remaining bodies of former tries. Each of the files in the extension directories will be included, so old or unwanted files like editor backups are very often an issue.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Reply
  • I put the files of the post, modified for Cases, into an installation package and installed it in a vanilla demo instance.

    The result seems to work.

    The installable:

    Cases_Email.zip

    Perhaps you should check your custom/Extension/application/Ext/Include/ and custom/Extension/modules/Cases/Ext/Vardefs/ directories for any remaining bodies of former tries. Each of the files in the extension directories will be included, so old or unwanted files like editor backups are very often an issue.

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Children
No Data