Mysql error

[msvi007]

Here is an error I get when clicking on the A B C, etc to find games starting with those letters or when searching for games from the search box

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 'A%' and gcat IN (1,0,2,5,3,)
order by gtitle 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 gtitle ASC' at line 3
mySQL error code:
Date: Wednesday 05th of September 2007 02:25:28 PM

Any ideas on how to fix it?

[MrZeropage]

check your categories, seems there is something wrong there... ?

[msvi007]

We only have 5 categories and there is nothing wrong there, I can click on the categories and play the games in there, just can;t search.

[MrZeropage]

I guess there is a problem with your categories, try running this query:

SELECT * FROM games_cats

tell me what the output is...

[msvi007]

When I execute that query it shows me all the categories, passwords and number of games in each.
example:
c_id cat_name active show_all pos password num_of_games description skin
1 Default 1 0 1 106 0

[MrZeropage]

how many rows do you get ? All c_id values are valid and filled ?

[msvi007]

This is what i get when i run the query

Results: 5 (0.0002s), Page 1 of 1
c_id cat_name active show_all pos password num_of_games description skin
1 Default 1 0 1 106 0
2 Ivy League 1 0 2 52 0
3 Toga Tales 1 0 3 3 0
5 The Keg Zone 1 0 4 34 0
7 Bleskop 1 0 5 1 0

[MrZeropage]

I need access to your site to find the reason for this, please provide FTP+adminCP access via PM

[msvi007]

sent

[msvi007]

any news on this? I am still having this issue. I sent you the login back on the 6th and have not heard back from you. Please let me know.