Error in query

@pedrossjr,

Have you tried the Sql statement without the user defined variables? Have you tried removing the problem portion of the query and running it again?

Also, have you tried using the Query binding method instead ( https://www.codeigniter.com/user_guide/d...y-bindings )?