Ick! Sounds awful. What made mine particularly bad was being buckled in, awaiting takeoff, and knowing that there is nothing you can do but grab the bag.

I'm about to get assigned to S America so I'm sure I'll have another fun bout with such things, although not food poisoning nor viral.