[Boofo]

Originally posted by Squirre1
Hey FireFly, you might want to check me on this one...

I looked into this because I have not been able to see any searchs that I am performing

Are you searching with a regular user account?

.. Based on the below quote from the MySQL manual:

If the search was performed by a guest which has an account value of "0", it tries to do the NOT IN which it can not compare to anything because that account does not exist in the user table...

I think this should be a correct query, I have tested here and it is working with no issues:

SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE querystring!="" AND (usergroupid NOT IN (5,6,7) OR search.userid = "0") ORDER BY searchid desc LIMIT 0,10

I guess I'm not sure why you would need to add the OR search.userid = "0" part. I'm not very good at mySQL, though.

Also, as a note to some people, I had to upgrade my search.php in order the get the links created correctly so other users could access them. Otherwise, I got a user is not authorized message.

Enjoy this info folks.... !!

How did you upgrade? I am running 2.2.9 and it seems to work fine here.