My whole foot sole is sore at night when im in bed during the day i mostly fine, i m not on any medication nor do i have other illnesses and im not over weight .

Foot discomfort: Apparently there is no foot soreness when you're up and around bearing weight on that foot. Since the discomfort is only noted in bed at night, it could be a type of perpheral neuropathy or be a nerve impingement. I would start with an evaluation by a podiatrist. Referral may be made to a neurologist depending upon the findings.