I just realized what you meant about the Book of SMD components in your PM this is where I got them 15+yrs ago:
[Only registered and activated users can see links. ]
1206 series they where and not cheap at the time.
don't know if they are available like that now. But are lot cheaper .

On your pics they are 502 series smaller.

Your error maybe able to be fixed IF you are prepared to search deeper on the board "I feel it is connector related not PCB BUT worst case a Chip."
But you must persist to eliminate all cases.
That's what the Hobby is all about. Solving problems that the "Pros" can't or won't do because of costs.
That is where you learn and become proficient in the trade "Is also why I have multiple trade Knowledge" and I have run out of fingers to count them.
Mags