Unless you are very tech savvy, I doubt that you will be able to fix this bad connector. This is a problem several other users have come across through the years as you can see from the thread below.
Good luck, but I think your best bet would be to purchase a new unit.