SCOOTERDOD Posted April 1, 2007 Share Posted April 1, 2007 when i try to permission some one to the arcade secton i get this ....error so i said ill create a group and just permission the group only to the arcade well it kinda worked some see the arcade and some dont ..so then i tried to permission by user name and i get this error ................ Could not select info from user/user_group table DEBUG MODE SQL Error : 1064 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 '' at line 1 SELECT arcade_catid FROM nuke_bbauth_arcade_access WHERE group_id = Line : 125 File : admin_arcade_auth.php i have not a clue on this and i really don't want to mess with the mysql tables in fear of messing up my hard work for the last week..lol any one got any ideas.....dont even know were the manual is . Quote Link to comment Share on other sites More sharing options...
AndyB Posted April 1, 2007 Share Posted April 1, 2007 the manual is online and easily found with google. Problem is likely that the value of group_id never makes it to the query. Show us the query and explain where group_id comes from in it. Quote Link to comment Share on other sites More sharing options...
SCOOTERDOD Posted April 1, 2007 Author Share Posted April 1, 2007 andy this is all new to me im a noob at this not trying to waste your time but i have no idea what you mean by show us..... ??? Quote Link to comment Share on other sites More sharing options...
AndyB Posted April 1, 2007 Share Posted April 1, 2007 Post relevant parts of your code (between CODE tags). Quote Link to comment Share on other sites More sharing options...
SCOOTERDOD Posted April 1, 2007 Author Share Posted April 1, 2007 every thing it says is in my post i apoligize but i still dont know what you mean.... what is in my first post is all it says... Quote Link to comment Share on other sites More sharing options...
AndyB Posted April 1, 2007 Share Posted April 1, 2007 If you can't post code, it's going to be impossible to tell you how to fix the problem. Quote Link to comment Share on other sites More sharing options...
SCOOTERDOD Posted April 1, 2007 Author Share Posted April 1, 2007 i can post code i just don't know were to go to get the code :-\ or where the code is please be patient i am just learning this.. . sorry to discourage you Quote Link to comment Share on other sites More sharing options...
AndyB Posted April 1, 2007 Share Posted April 1, 2007 Line : 125 File : admin_arcade_auth.php Why not start with showing us lines 110-130? Quote Link to comment Share on other sites More sharing options...
SCOOTERDOD Posted April 1, 2007 Author Share Posted April 1, 2007 well i wnt through the db tables and i did find it but it said 0 lines so i assume this is the problem.. if this file is in the sql file it is not thier ??? Quote Link to comment Share on other sites More sharing options...
SCOOTERDOD Posted April 1, 2007 Author Share Posted April 1, 2007 and i also submited a ticket to hosting company and they said<quote>Upgrade your scripts to the latest version. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.