From musicians to actors, many celebrities have made a misstep when meeting royalty