I had the same issue last month. I replaced the USB by this reference https://www.amazon.com/Female-Type-B-4-Pin-Socket-MXRS/dp/B07F6L1DHR?th=1 .
Now it's working fine. Thank to this topics, very helpful !
I made myself the replacement. For a clean job use a "desoldering pump" (not sure for translation) or buy a kit https://a.co/d/j7cAUQW
An electronic shop can do the job (is not complexe with good tool).