Log in

View Full Version : SQL Problem with Alphabetical Listings


Erika
03-08-2008, 11:19 PM
Hi - I just upgraded to the 2.6.6+ IProArcade from a 2.5 version.

2 of my members are reporting that there are issues accessing the games through the alphabetical listing and they receive this error:

There is a SQL error.
You can contact the board administrator by clicking here

Error Returned:
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 'P%' and gcat IN (1,)
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: Saturday 08th 2008f March 2008 09:26:54 AM

We apologise for any inconvenience

Does anyone know what the problem here is?

MrZeropage
03-09-2008, 05:39 PM
seems like a problem in the usergroup-settings, looks like for those users getting the error they have permission to access only category 1 but the setting stores one comma in it...

is it possible I can have a look on your site to find out the problem (and fix it) ? I would need AdminCP + FTP access via PM.
Oterwise I need detailed information about categories, usergroup-settings and -permissions and the usergroup-settings of those users getting the error

thanks