Hi,
I'm trying to update existing Accounts via the api. It works for 2/3s of all Accounts but fails for the other 1/3. For those where it does not work, it fails regardless of which attribute we try to change. For example, an update to such a problematic Account produces the following log
The same issue occurs when the Account is updated via webbrowser. These Accounts were created via API without any issue.
Any ideas on how to narrow this issue down?
I'm trying to update existing Accounts via the api. It works for 2/3s of all Accounts but fails for the other 1/3. For those where it does not work, it fails regardless of which attribute we try to change. For example, an update to such a problematic Account produces the following log
Code:
2021-08-31 08:48:43] DEBUG: API (23000) SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id' cannot be null; PUT /Account/60c1defe09e2486bb; Input data: {"vatNumber": "XXXX"}; Route pattern: /{controller}/{id}; Route params: Array ( [controller] => Account [action] => update [id] => 60c1defe09e2486bb ) [] [] [2021-08-31 08:48:43] ERROR: (23000) SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id' cannot be null; PUT /Account/60c1defe09e2486bb; line: 72, file: /espocrm/application/Espo/ORM/SqlExecutor.php [] []
Any ideas on how to narrow this issue down?
Comment