EXO 24:9,10; AMO 9:1; GEN 26:2; and JOH 14:9
God CAN be seen:
"And I will take away my hand, and thou shalt see my backparts." (EXO 33:23)
"And the Lord spake to Moses face to face, as a man speaketh to his friend." (EXO 33:11)
"For I have seen God face to face, and my life is preserved." (GEN 32:30)
God CANNOT be seen:
"No man hath seen God at any time." (JOH 1:18)
"And he said, Thou canst not see my face; for there shall no man see me and live." (EXO 33:20)
"Whom no man hath seen nor can see." (1TIM 6:16)
That seems to be a bit more than a translation error.
The verses you quoted under "God can be seen" are taken out of context.
Ex 33:7-11 we are told that "the pillar of cloud" descended and stood at the door of the tabernacle and the Lord talked with Moses." vs 9
In Exo 13:21 we are told this "And the
LORD went before them by day in a pillar of cloud to lead the way, and
by night in a pillar of fire to give them light, so as to go by day and night". "Pillar of cloud" was a manifestation of God, it was not actually God.
In Exodus 33:20 right before God shows Moses His back He says
"...You cannot see My face; for no man shall see Me, and live."
Continue in Exodus 33:23 it says
"Then I will take away My hand, and you shall see My back; but My face shall not be seen."
For Genesis 32:30 where Jacob wrestles with God...we are told in Genesis 32:24
Then Jacob was left alone; and a Man wrestled with him until the breaking of day.
But we are told in Hosea 11:9
I will not execute the fierceness of My anger; I will not again destroy Ephraim. For I am God, and not man, The Holy One in your midst; And I will not come with terror.
.
The Man that Jacob wrested with could likely be a manifestation, because God came as "Man" therefore Jacob couldn't have seen God in all His glory. But both Him and Moses got to speak to God face to face for they encountered God, they just didn't get to see His actual true face or they would die. Remember, there was another Man that walked the face of this earth, the only begotten Son of God, whom those who walked among Him were allowed to see face to face and not die.
And the verses that says that "God cannot be seen"
The verses speak of His true nature, we cannot see Him face to face. We do not have any record of anyone seeing the actual face of God, face to face. Seeing Him through a "pilar of cloud", seeing His back and seeing Him as a manifestation of a Man wrestling with Jacob, shows that they had a close encounter and personal relationship with Him, but they did not see His true face.