vb.org Archive - SQL Problem with Alphabetical Listings

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - SQL Problem with Alphabetical Listings (https://vborg.vbsupport.ru/showthread.php?t=172497)

Erika

03-08-2008 11:19 PM

SQL Problem with Alphabetical Listings

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:

Quote:

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

All times are GMT. The time now is 01:09 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01061 seconds Memory Usage 1,711KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: