[C1] Error in calendar when deleting user that has registries in agenda_event_invitee

[NicoDucou]

In Chamilo 1.11.x when deleting a user the registry agenda_event_invitee.user_id take a NULL value, but this generate error "Uncaught Error: Call to a member function getId() on null" in main/inc/lib/agenda.lib.php:2135

So to avoid this problem and to have a better coherence in the content in the database if the user is deleted then the registries in agenda_event_invitee related to this user should be deleted to.

[AngelFQC]

🤔 This commit is in case the user is null
9a6496a

Otherwise, the AgendaEventInvitee entity would have to be changed, to do onDelete=CASCADE in the user relation

[AngelFQC]

It's necessary to change the foreign key in agenda_event_invitee.user_id so that the record is deleted when deleting a user

ALTER TABLE agenda_event_invitee DROP FOREIGN KEY FK_4F5757FEA76ED395;
ALTER TABLE agenda_event_invitee ADD CONSTRAINT FK_4F5757FEA76ED395 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE;

[NicoDucou]

All good now the user is delete with no error and all the event inscription or invitation are also deleted.