Got this error in MySQL on my dev box, but not online, despite running MySQL 5+ on both machines.
Turns out in some versions of MySQL you cannot have a space between a function name and it’s parameters, e.g.
CONCAT (MyField, ‘ some text’) <-BAD
CONCAT(MyField, ‘ some text’) <-GOOD
So good practice is to never put a space in 
Tanks