Continuity mistake: The lipstick on Picard changes between when he is kissed, and later when he leaves the holodeck (it's darker and on and above his lips.) Also, and more importantly, being holodeck matter, it should have disappeared after re-emerging in the real world.
Continuity mistake: When Picard tells Q in the final scene "Get off my ship." Q is standing to his right, and Picard has his head turned towards Q. But when the angle changes to show Q's response, Picard is standing facing Q directly, and without his head turned.
Continuity mistake: When Data brings up a picture of the original Kirk-era Enterprise in conjunction with the log talking about the water-intoxicant, the picture is of the refitted movie-style Enterprise - not the original round-nacelled model that was involved in the events of "The Naked Time."
Continuity mistake: Several episodes have stardates after this episode, but still have Tasha Yar in them (even though she dies in this episode). They aired before this episode. The series producers later formalized their stardate system so that they take place in the order the episodes air.
Add timeK.C. Sierra
Continuity mistake: Watch when Geordi on the bridge calls up Dr. Crusher in Sick Bay. There's a white-haired medical assistant working on someone behind Geordi. Then when Dr. Crusher responds to Geordi's page, the same assistant is down in Sick Bay with her. Then they cut back to Geordi and the assistant is back up on the bridge again.
Continuity mistake: When the away team encounters the evil oily blob thing, it makes their equipment fly away. Later they have apparently recovered it. But strange things keep happening to Geordi's weapon: when he and the others run forward to rescue Riker, Geordi accidentally drops it in the black pool when he stops abruptly. Admittedly, you can't prove that's a mistake even though it has no purpose in the story. But shortly afterwards the phaser is back on Geordi's belt, clean. Did the sticky, malicious, bullying blob give it back just like that? (People often try and find justifications for mistakes, but in this case, wishful thinking can only give us an extremely unlikely explanation.)
Continuity mistake: Near the end of the episode, right after Lore fires the phaser at Dr. Crusher, Data tackles Lore and knocks the phaser out of Lore's hand. The phaser flies towards the cargo transporter and when it impacts, it breaks in two. You can see a piece of it go flying off to the left. Then shortly after when Data throws Lore onto the transporter pad and Lore picks up the phaser, it's in one piece again.