On further inspection of the Hard Drive I found that the plastic L joint on the sata port on the Hard Drive was broken.
So I fixed it with the following, epoxy, thermal paste cleaner and a upside down L joint sata cable.
I found this method out by accident, lol.:D
I was trying to hold in the old sata cable at a 90 degree angle so I tried gluing the sata cable on top of the old sata Hard Drive with epoxy which didn't work and some of the epoxy had fallen onto the sata port on the Hard Drive. I then waited for it to go slightly hard then cleaned the pins on the sata port on the old sata Hard Drive with thermal paste cleaner (expensive not cheap stuff) and tried my other sata hard drive's upside down L joint sata cable and I'll be damned it worked!!!!
So I grabbed a new upside down L joint sata cable, stuck the other in my new current sata hard drive and put the new upside down L joint sata cable in the old sata Hard Drive and luckily both sata Hard Drives are now detected but I am free standing the old sata Hard Drive without being screwed in, just being held by the lower Hard Drive bay and the extra length of the cables shoved on top of the old sata Hard Drive.
[video]
[/video]