getting some sql error

Question

I have recently restored my joomla website and it was working perfectly fine, but suddenly I am receiving the following error:

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 ') ORDER BY `registerDate` DESC LIMIT 20' at line 1
SQL=

SELECT * FROM `jnx_users` WHERE `block`='0' AND `id` NOT IN() ORDER BY `registerDate` DESC LIMIT 20

An error has occurred while processing your request.

You may not be able to visit this page because of:

• an out-of-date bookmark/favourite
  
• a mistyped address
  
• a search engine that has an out-of-date listing for this site
  
• you have no access to this page

Go to the Home Page

Home Page

If difficulties persist, please contact the System Administrator of this site and report the error below.

Answer 1

While using IN() or NOT IN() clause comma (,) separated values or empty string must be passed as parameter.

For example: IN(1,2,3) OR IN('') OR IN('a', 'b', 'c')

Answer 2

The problem you are having is due to the id NOT IN() filter in your query. You can't use NOT IN() without an array being passed inside it, even if it is an empty array. Change your query to this:

SELECT * FROM jnx_users WHERE block='0' AND id NOT IN('') ORDER BY registerDate DESC LIMIT 20

Notice the 2 single quotations inside the NOT IN('') portion of the statement. That fixes this issue. You can also remove the id NOT IN() AND portion of the query if you are not going to filter any ids with it.