Stupidity: The last remaining Xindi, in desperation, attempts to release the virus over the fan, despite the virus not being fully ready. However, it seems the only reason he didn't release the virus at that time was he had to seek cover from Archer and T'Pol shooting at him and to start shooting back at them. However, he had plenty of cover from the rooftop stairwell, which was right next to the fan, and he had enough time to dump out the contents over the fan.
Star Trek: Enterprise (2001)
1 stupidity in season 3
Other mistake: Two Borg are discovered North of the Arctic Circle. One is covered in ice, the other encased in ice. Carbon dating shows the wreckage to be over 100 years old (to tie it in with Star Trek: First Contact). The Borg are inactive and unable to repair themselves until they are "defrosted". The temperature above the Arctic Circle doesn't usually drop below -100°F. The Borg have been shown to work very well in the vacuum of space which is 3-4K (roughly -454°F). If they can survive that, even being frozen in a solid block of ice would not slow them down. The nanites have to be in their "blood" and operate at the cellular level. That cannot be damaged by re-entry and the crash.
Commander Dolum: You don't want to know my specialty.
Captain Archer: Let me guess... stinking up the room?
Trivia: Season 3 of Enterprise is the only season of any Star Trek series to date in which no Klingons appear.
Question: Is the captain's dog still alive?
Answer: Yes. Porthos survives this episode, although many a viewers' sanity and the show's ratings were not so lucky.