I found out what is causing error after turning off one module at a time. 

It turns out it's the "Photo Contest" module. 

I tested by turning it back on and did the search producing the database error!

This is from a module I purchased from AQB Soft #AQBSoft