general error

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   general error
19delta
CZ Super Newbie
19delta has been a member for over 20 year's 20 Year Member
Occupation: Military Police Officer
Gender: Male
Website:
Status: Offline
Joined: Jan 04, 2004
0.01 posts per day
Posts: 74
Points: 18,002
 Yahoo Messenger MSN Messenger ICQ Number
I am trying to update user permissions and get this error, any ideas?

General Error
Couldn't obtain user/group permissions

DEBUG MODE

SQL Error : 1104 The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok

SELECT u.user_id FROM ( ( phpbb_users u LEFT JOIN phpbb_user_group ug ON ug.user_id = u.user_id ) LEFT JOIN phpbb_auth_access aa ON aa.group_id = ug.group_id ) WHERE u.user_level NOT IN (0, 1) GROUP BY u.user_id HAVING SUM(aa.auth_mod) = 0

Line : 491
File : /mnt/web_g/d04/s45/b01b61eb/www/phpBB2/admin/admin_ug_auth.php



Attached Files
admin_ug_auth.txt (31.49 KB, Downloaded: 5232 Time(s))


Back to top Reply with quote
#2   re: general error
Gareth
CZ Addict
 Codezwiz Site Donator
Gareth has been a member for over 20 year's 20 Year Member
uk.gif
Occupation: Student, Webmaster
Gender: Male
Fav. Sports Team: Liverpool FC
Status: Offline
Joined: May 29, 2004
0.08 posts per day
Posts: 587
Points: 38,220
   
guessing this is when you try make mods or admins? try this one



Back to top Reply with quote
#3   
19delta
CZ Super Newbie
19delta has been a member for over 20 year's 20 Year Member
Occupation: Military Police Officer
Gender: Male
Website:
Status: Offline
Joined: Jan 04, 2004
0.01 posts per day
Posts: 74
Points: 18,002
 Yahoo Messenger MSN Messenger ICQ Number
i uploaded it and it didn't work. i'm able to manage my users but when i goto assign permissions to a user for the forums is when i'm getting the error.Thank for trying i really need to get this figured out. I also noticed when i try to change a users profile through the admin panel it doesn't save the settings, ugggggggg i'm at a loss here, Telli if you could help me i'd really appreciate it, i know your a genius at these type of things.. I have the following mods installed: gender, flags, cash, vault, medals,shop, etc. if you can look at my files and see where i messed up, which is likely, lol.
here's my site [ Register or login to view links on this board. ] i've left posts at phpBB and phpBB hacks and get no response, i know your dependable so that's why i posted it here.



Attached Files
admin_users.txt (48.49 KB, Downloaded: 5231 Time(s))


Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum