I found a few other questions on here about this, but nothing that solved my problem.

I have a very simple grid with 4 columns, the first being a primary key ID. If I type in the filter box above a column, I get a MySQL error:

"Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( `type_id` LIKE '%1%' )) pg_tmp' at line 1 – SELECT count(*) as c FROM (SELECT * FROM Organizations AND ( `type_id` LIKE '%1%' )) pg_tmp"

It seems like the "AND" should be a "WHERE"?

I can't figure out why I only have this problem with this very simple grid and not with my other ones. It affects all 4 columns.

Code is here: http://pastebin.com/A68KkJev

Thanks in advance.