Sorry about the photo, taken with my phone.
Nothing to apologize for, it shows the problem quite clearly. 8)
It looks like you got very lucky. While the large pads that hold the connector in place have been torn off, the smaller pads that make the electrical connection appear to be intact. From the look of it, when the connector was soldered back in place, only the small electrical connections were holding the connector in place, so it's no wonder it came loose again. But it's very encouraging that neither time pulled the pads off.
It looks like the reason it won't stay is that the large pads that physically hold the connector in place have separated from the board and are still soldered to the connector. I don't think a new connector will help you, as the pads that it would be soldered to that hold in place are gone. You could unsolder the pads from the connector, and that would pretty much give you a new connector, but that won't help the situation, in fact it may make it worse.
You won't get very far without a strong mechanical connection. Personally, what I would do in your situation is carefully clean that area of the board and the mating surface of the connector (the bottom of the pads that used to be on the board that are visible in the photo.) I would probably use flux remover followed by alcohol. Then, with the board clean and dry, I would use some epoxy to glue the connector down to the board being careful that no glue goes anywhere near the contacts or inside the connector, and that the connector pins line up. Then, when the glue has cured and the connector is stable, resolder the actual contacts. The reason I say unsoldering the mounting pads from the connector might make it worse is that the pads that are still on the connector give you a good surface area for the glue, and should help to act as a shield to prevent the glue from creeping into the connector space. If you use a new connector, and remove the old pads from the old connector, you will likely have more surface area and it may be harder to keep the glue out of the connector space.
The big concern is that you have a solid physical connection between the connector and the board, the small contacts won't accomplish that. It used to be soldered down, but the mounting pads on the board have been pulled off, so you will need a more imaginative solution.