MyBB Community Forums

Does anyone know the right syntax anguage to fix sql errors when the using AND "field" NOT iN

I get the following error in a plugin, but it can happen in any if the syntax is not right.

1064 - 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 fid NOT IN

What kind of query are you trying to insert into the DB?

This particular one is a search query using mybb tags

http://community.mybb.com/thread-159795-...pid1138110

---

Ignore this thread for this particular issue.  Fixed this issue by combining the two versions of mybb tags.  Don't know the exact issue, but if the SQL error comes up with another plugin, IF the language can be changed feel free to add an answer.