Plot hole: Huge plot error: Apophis and Clorell (Skara) should not have survived the explosion in Season 2, Episode 1 (when they attack Earth with two ships). In "Family" they explain that Apophis and Clorell survived by escaping through the stargate aboard Clorell's ship moments after Daniel Jackson did the same. However, when Daniel Jackson escapes through it, Apophis and Clorell are not even on the right ship, and there is 1 second left on the C4 timer when Daniel escapes. They actually show Daniel Jackson escape, and then cut to Apophis and Clorell still aboard their ship. So apparently, Apophis was able to "ring" from his ship over to Clorell's ship, make it to the stargate room, dial an address, and escape through the stargate all within literally 1 second. Is this guy related to The Flash?
Continuity mistake: Daniel's interaction is inconsistent across the episode. Initially, Daniel emerges through the Stargate with no ripples in the event horizon or audible noise. Then he walks down the metal ramp making noise with each footfall. Later in the episode he returns through the Stargate with an audible noise and ripples in the event horizon. He remained "out of phase" for the entire segment of the episode.
Plot hole: Before the last chevron locks & the wormhole engages, Carter asks "Where's the iris" to which Hammond responds "Someone used a remote, whoever it is has our codes". All well and good, except without the wormhole being active, they wouldn't be able to receive the code.
Revealing mistake: As we know, the watery image of the event horizon is projected onto a blue backdrop. Ger'ak comes through the Stargate and we can see the image of the event horizon, though faint, around and above the Stargate itself and is not confined to normal area for the event horizon. Blatantly visible if you look for it on the airing of the episode on the Sci-Fi network.
Continuity mistake: During the scene where Jack is talking to Daniel aboard the Odyssey, there is only 1 star on each of his shirt collars, indicating that he is a Brigadier General, instead of the proper two stars for a Major General, as he does in every other scene of the episode.
Character mistake: The team are finding out who could have stolen the weather device from Madrona and find an energy spike at the same time SG2 are on a mission. "But SG2's mission is galaxies away from Madrona" Says Teal'c. At this time the only missions the teams could go on was in our own galaxy and couldn't be galaxies away.