I 'm getting Error 500 when trying to filter Leads with Email Address is Opted-Out option. Other filtering options work fine. Just this one fails. When I edit leads which have opted out I see them properly. I can also manually opt-out email address of the lead.
Log says: [2019-07-15 19:15:46] Espo.ERROR: (42) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'emailAddresses.opt_out' in 'where clause'; GET /api/v1/Lead?select=salutationName%2CfirstName%2ClastName% 2Cname%2Cstatus%2CemailAddressIsOptedOut%2CemailAd dress%2CemailAddressData%2CassignedUserId%2Cassign edUserName%2CcreatedAt&maxSize=20&offset=0&orderBy =createdAt&order=desc&where%5B0%5D%5Btype%5D=isTru e&where%5B0%5D%5Battribute%5D=emailAddressIsOptedO ut [] []
I have tried php rebuild.php but no effect
My issue looks similar to this: https://forum.espocrm.com/forum/bug-...pgrade-to-v5-6
Log says: [2019-07-15 19:15:46] Espo.ERROR: (42) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'emailAddresses.opt_out' in 'where clause'; GET /api/v1/Lead?select=salutationName%2CfirstName%2ClastName% 2Cname%2Cstatus%2CemailAddressIsOptedOut%2CemailAd dress%2CemailAddressData%2CassignedUserId%2Cassign edUserName%2CcreatedAt&maxSize=20&offset=0&orderBy =createdAt&order=desc&where%5B0%5D%5Btype%5D=isTru e&where%5B0%5D%5Battribute%5D=emailAddressIsOptedO ut [] []
I have tried php rebuild.php but no effect
My issue looks similar to this: https://forum.espocrm.com/forum/bug-...pgrade-to-v5-6
Comment