Unable to delete an assignation in an activity

Hello,

I have an activity, with 3 "sub-activites", like this




The "main" activity has 3 assignations, with no input work :




One of the "sub-activity" hase 4 assignations (3 are the same as the main activity, 2 are specific to the sub-activity




My problem appear when I want to delete one of the assigation of this sub-activity

When I try to delete Quentin, I have this message :



When I try to delete Adil, Vincent, I have the same message, except (1) that replace (4)
When I try to delete Sébastien or Jérôme, it works....

I don't understand why happend

No ressources has assigned work, or real work...and some ressources can be deleted, some other no

Can somebody explain me what I do that is not correct ?

Thanks

Hello Babynus,

After the execution of the first SQL request, here is what PhPMyAdmin return




After the second SQL request :



One precision

• My tables begin all with prefix prj, that why I modified the SQL request to take this point into account.

Hello

I executed the SQL request

and have this result




For the ressource 92 on the project 98, I go to corresponding week / resource on Real Work allocation screen to remove work but there is no work entered




For the ressource 15 on the project 95, I go to corresponding weeks / resource on Real Work allocation screen to remove work but there is no work entered

For the week 49


For the week 50


For the week 51


I can't delete real workload because I don't have anything in the field mentionned in the request