The Arcive of vBulletin Modifications Site. |
|
error when searching for games Details »»
|
|||||||||||||||||||||||||
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 Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
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 |
|
#3
|
|||
|
|||
|
check the usergroup permissions where? I tried looking in the regular usergroup options, but didnt see anything about searching restrictions
|
|
#4
|
||||
|
||||
|
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 |
|
#5
|
|||
|
|||
|
Quote:
|
![]() |
|
|