You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello, good afternoon.
I am having a problem that when creating a contact in "Persons" and then saving it without having entered any organization. When trying to update the contact and add the name of an organization, the system fails and returns me
"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (laravelcrm.persons, CONSTRAINT persons_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE SET NULL)"
Could you help me? I don't understand how to solve it.
PS: Attached screen print with 3 messages and 2 exceptions.
Are you doing some sort of customization or you reproduced in core. Can you share me the steps so that i can check.
Hi @devansh-webkul .
I am not doing any customization. Just as the step by step indicates, I have installed it and created its mysql database. Within Krayin, I go to "Contacts" and create 1 new person without adding anything in the "Organization" field... But, if I later decide to "update" said contact by adding it in the organization field, it generates the aforementioned error.
Do you need any additional details?
Thank you very much in advance.
PD: attachment pictures for the error. The only way that does not fail is by previously creating the organization and adding it to the contact from minute 0. If you later decide to update the contact with the organization, it generates this error.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Hello, good afternoon.
I am having a problem that when creating a contact in "Persons" and then saving it without having entered any organization. When trying to update the contact and add the name of an organization, the system fails and returns me
"SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (
laravelcrm.persons, CONSTRAINTpersons_user_id_foreignFOREIGN KEY (user_id) REFERENCESusers(id) ON DELETE SET NULL)"Could you help me? I don't understand how to solve it.
PS: Attached screen print with 3 messages and 2 exceptions.


All reactions