Had it ever been soldered on in the first place? If so, someone with soldering iron, who knows how to use one should be able to fix it.
But even if this one can get (re)attached, I would expect that this circuit board could have other sockets that could come loose.
Edit: I think Suicidal_orange is right (see below)