Could not obtain user info for moderator list

Posted: Fri Jan 15, 2010 1:58 pm

Code:

Could not obtain user info for moderator list





DEBUG MODE





SELECT user_id, username FROM nuke_users WHERE user_id = 2





Line : 119


File : admin_groups.php

I noticed after having 5 users registered on the site this problem get fixed itself. I runned the fixgroup when I am as Administrator and as a user but I still get this error. Is there any way to fix this when u have only one username?

I already read all the forums about but no clue. I would like u hear more details and deep answers about this problem. Thanks in advance Shocked

Posted: Fri Jan 15, 2010 3:15 pm

The SQL error there seems to be saying you don't have a user with the user_id of 2
user_id 0 is anonymous
user_id 1 is usually the one created when you set up the site i.e. the God admins 'normal' account so by my reckoning, that leaves user_id 2 as the first normal registered user.
Since you said you have 5 registered users, is it possible that user 2 has been deleted?
You'll need to verify it directly in the database I would think.

Posted: Fri Jan 15, 2010 3:33 pm

There is no user_id 0. Anonymous should be 1 and The user that is created during installation should be 2. Also with 2.4 we made it so you could not delete a user if he was a group moderator.

This error should never happen on a fresh install of 2.4.

Go into table nuke_bbgroup with phpmyadmin. Browse all the groups and any of them that have a 2 listed under the group_moderator column but not a 1 listed in the group_single_user column change to your user_id which can be found in the nuke_users table.

Posted: Fri Jan 15, 2010 4:19 pm

Oops, your right, the first one is user_id 1
Maybe I should quit this lark before my brain goes completely.

registered · Posted: Sat Jan 16, 2010 9:15 am

unicornio, I am confused. Didn't this thread help?

http://www.ravenphpscripts.com/posts18615.html

Posted: Sat Jan 16, 2010 12:00 pm

no montego. This is another problem. it is different than that one. I did what u told me but unfortunatly I get this error. I am gonna read right now but I guess guardian is right. user=2 doesnt exist. I what u told me montego and it helped a lot but when I go to forum admin and I want to give permission to one of my user I got the issue. I am gonna modify database and make user=2 into user=1 in order to see if that helps. I will come back soon to report it.

Posted: Sat Jan 16, 2010 12:09 pm

I am completly lost. I change the value but I get the same result but this time with user=1. ???????

Code:

Could not obtain user info for moderator list 





DEBUG MODE 





SELECT user_id, username FROM nuke_users WHERE user_id = 1

Posted: Sat Jan 16, 2010 12:18 pm

Ahhh!!!! user id in table nuke_user was 6. hmmm so I changed it to 2 and this solve the problem. Thanks Palbin. I was going crazy with this little problem but I learned from it. the problem was I remove my own user 5 times and when I created again user became 6. What was the mistake then? The problem is solved. Thanks to all users who participated on solving this problem. I like to work from the phpMyadmin. it is really easy.

This is a picture from my phpMyadmin

Posted: Sat Jan 16, 2010 12:36 pm

You should not be deleting users from phpmyadmin on a production site. You are going to have way more problems than this.

Posted: Sat Jan 16, 2010 1:04 pm

thanks Palbin for your suggestion but actually I didnt delete any user from phpMyadmin. I did it from admin control panel.

Posted: Sat Jan 16, 2010 1:27 pm

From the Your Account admin?

Posted: Sat Jan 16, 2010 3:21 pm

yes, from Your Account Admin!

Posted: Sat Jan 16, 2010 5:42 pm

If you are running 2.4 that is not possable. You should have recieved an error message saying the following.

Quote:

SomeName(2) is the moderator of the following groups. A new moderator must be set before the user can be deleted.
Moderators(3)

Posted: Sat Jan 16, 2010 6:12 pm

hmm, that is right. I tried that I got that result but later I removed with the last visit module.