After changing the formula, I can't change or create any record

[sobolevfff]

What to provide in the bug report:

1. In many cases it's helpful to know if there are any errors logged:
   1. in EspoCRM log in data/logs directory;- no errors associated with this 500 at this time
   2. in server's error log; no errors associated with this 500 at this time
   3. in browser console (F12 key).

Failed to load resource: the server responded with a status of 500 ()
DevTools failed to load source map: Could not parse content for https://aaaaaax.com/crm/purify.min.js.map: Unexpected end of JSON input
DevTools failed to load source map: Could not parse content for https://aaaaaaax.com/crm/vis.map: Unexpected end of JSON input

Before the change in the formula, everything worked correctly.
I changed the value in the formula I created earlier and then I cannot change or create any record even in other entities. I am getting a 500 error.


jquery-2.1.4.min.js:4 PUT https://aaaaaax.com/crm/api/v1/Conta...20d680c4ad4178 500
send @ jquery-2.1.4.min.js:4
ajax @ jquery-2.1.4.min.js:4
Backbone.ajax @ backbone-min.js:1460
Backbone.sync @ backbone-min.js:1443
sync @ backbone-min.js:437
sync @ model.js:55
save @ backbone-min.js:648
inlineEditSave @ VM996:573
eval @ VM996:604
dispatch @ jquery-2.1.4.min.js:3
r.handle @ jquery-2.1.4.min.js:3

Even if you return the previous values in the formula, the error is not removed. Even if you remove the entire formula, the error is not removed.
I uploaded a backup of the entire folder where the CRM was without changing the databases and everything began to work correctly.
But how now to change or create new formulas?


Provide the EspoCRM version number. Current version: 6.1.9 (And I don't want to update it, because after the update, the API stopped working for me and I had to create topics on this forum, but the error was never found. I spent several days of nerves and time.)

Provide PHP 7.4 (ea-php74) and MySQL version numbers. Server version: 5.7.38 - MySQL Community Server (GPL)

[sobolevfff]

@yuri Please, help

[yuri]

Find your formula in the file custom/Espo/Custom/Resources/metadata/formula/YourEntityType.json. Delete this file. Clear cache from CLI by running:

php clear_cache.php


If the problem is with formula, please post the formula here so we could examine where was the problem.