When you upgrade MySQL from 4 to 5 there’s a decent chance you’re going to be seeing some Error #1054 action on any query with a left join.

There’s a description and solution available at CodingForums.com.