Error 500

[robson]

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

[robson]

I appears when I migrate from 5.5.6 to 5.6.3 using CLI: sudo php upgrade.php EspoCRM-upgrade-5.5.6-to-5.6.3.zip

[yuri]

Will be fixed in the next version.

[robson]

Thanks Yuri, can I downgrade app to 5.5.6 and keep the database? I mean are there any major modifications to db structure between versions 556 and 563?

[robson]

Yuri, I made upgrade to 5.6.5 and I'm getting new errors, including 500:
First one happens when I want find lead with wrong emails (without @) so I try NOT CONTAIN @ and get 500 error. Second one I just noticed in log.


Here is log

[2019-07-21 22:28:03] Espo.ERROR: (42) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lead.email_address' in 'where clause'; GET /api/v1/Lead?select=salutationName%2CfirstName%2ClastName% 2Cname%2CaccountName%2Cstatus%2CassignedUserId%2Ca ssignedUserName%2CmodifiedAt%2CcreatedAt%2Ccreated ById%2CcreatedByName%2CstatusCC%2CemailAddressIsOp tedOut%2CemailAddress%2CemailAddressData%2CphoneNu mberIsOptedOut%2CphoneNumber%2CphoneNumberData%2Cd oNotCall%2Ctype&maxSize=20&offset=0&orderBy=create dAt&order=desc&where%5B0%5D%5Btype%5D=notContains& where%5B0%5D%5Battribute%5D=emailAddress&where%5B0 %5D%5Bvalue%5D=%40; line: 122, file: /var/www/crm.szybkieskladki.pl/public_html/application/Espo/ORM/DB/Mapper.php [] []

[2019-07-21 22:28:04] Espo.ERROR: EmailAccount 5b505a31662e79556 (Select Folder) [0] cannot change folder, maybe it does not exist [] []