error when searching for games

[jilly]

I updated to newest version - when I try to use the search function to search for games, I am getting this error message:

mySQL query error: select g.*, c.password from games_list as g
left join games_cats as c on (g.gcat = c.c_id)
where g.active = 1 and trim(password)='' and gtitle like '%marble motion%' and gcat IN (1,)
order by added ASC

mySQL error: 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 added ASC' at line 3
mySQL error code:
Date: Sunday 22nd of June 2008 08:49:40 AM

[MrZeropage]

check the usergroup-permissions for the usergroup of the user getting this error, or simply refresh it

But I also implemented some more verification for this in v2.6.8+ to avoid this error

[jilly]

check the usergroup-permissions for the usergroup of the user getting this error, or simply refresh it
check the usergroup permissions where? I tried looking in the regular usergroup options, but didnt see anything about searching restrictions

[MrZeropage]

check group-permissions for accessing game-categories, if this is setup correctly.

the sql-query above in your error-message tells that the user searching is only allowed to play games in category 1 and has one additional separator ( , ) without any following category-id

[jilly]

check group-permissions for accessing game-categories, if this is setup correctly.

the sql-query above in your error-message tells that the user searching is only allowed to play games in category 1 and has one additional separator ( , ) without any following category-id

On the back end, each one of them is set to _ALL_ for the categories - maybe i shoudl try selecting all the categories?