What's the difference? SQL_MODE error in one site and not the other
Answering my own question:
We ended up configuring MySQL as Routh suggests here:
Getting this SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by 

Problem solved.