Plot hole: General Hammond is promoted to 3-star general and command of the SGC is given to General O'Neill before the Atlantis gang even left earth. Why is it, that none of them find it the least bit odd that a 2-star Hammond greeted their return instead of O'Neill?
Suggested correction: The dream-state induced by the aliens had some ability to stop them from questioning their reality. (One of them takes quite a while to realise that a friend they're partying with died years before they left for Atlantis). It's not infallible or entirely consistent, but it would theoretically explain this.
Plot hole: After Zelenka is finished with his description of how Atlantis rose from the ocean, Ford asks him if he said anything that would require security clearance to see. But if he is worried about security, why did he film Zelenka sitting in front of a top-secret Naquadah generator? This would be the equivalent of a soldier filming Enrico Fermi (speaking in Italian) in front of a nuclear bomb prototype then asking if he said anything secret.
