Updating records is not working

[rsp]

Check in this forum for that error:

---

Cannot add, see details, or change contacts since migration to 8.7

Since the migration to 8.7 from 7.14.5, we cannot add any contacts. The Suitecrm log does not show anything special. We have verified the rights and they are fine. We deleted the cache as well. The php log has the following errors: [14-Oct-2024 16:12:54 UTC] PHP Deprecated: Return type of SuiteCRM\Search\SearchQuery::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the n…

Database failure. Please refer to suitecrm.log for details.

Hello @Marty42 This is precisely the same issue and the fix is the same. This issue impacts subpanels in every module as all the subpanels use SugarBean.php when pulling data. Where the user first encounters the error depends on what part of the CRM they use after the MySQL environment on their server is updated. To fix: In SuiteCRM/data/SugarBean.php Replace $final_query = ‘(’ . $tmp_final_query . ‘)’; With $final_query = $tmp_final_query ; AND on line number 930 comment out: $query…