Script Malfunction: administration/members.php in 7.02.07
Asked Modified Viewed 2,379 times
asked
Hey guys I have a problem that I never noticed before now. When I select 'user admin/members' in admin system it only displays 8 users out of 39. And if I click a letter in the alphabet for a known user it doesn't display that user. If I click Show All it still shows only the first 8 users. If I search on a user name it won't work either, same result except it says there is no such user. I can't believe I never noticed this before. Any clues?
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Answered 1 question
Just for sure (I know you must have checked it)
This is the query:
Are the user level < 103?
Are the users activated not banned or something like that? That is holding the variable $usr_mysql_status through the dropdown box on top of the screen
This is the query:
Code Download source
"SELECT user_id, user_name, user_level FROM ".DB_USERS."
WHERE $user_name user_status='$usr_mysql_status' AND user_level<'103'
ORDER BY user_level DESC, user_name
LIMIT $rowstart,20"Are the user level < 103?
Are the users activated not banned or something like that? That is holding the variable $usr_mysql_status through the dropdown box on top of the screen
answered
Yep. That is the query and all users are level 101 and status 0. What next?
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Answered 1 question
Is the ID on the users table Unique?
answered
Of course they are. Update on this function: Users shown are 9 not 8 and clicking a letter on search does in fact work. Typing a known username does not work. The 'members.php' script in root works correctly the way it should.
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Answered 1 question
The SQL Query in both script files is almost the same.
Big difference in the one in the admin folder is $user_name variable that holds the part of the where clausule for selecting a user name.
So maybe omit this part and try again.
I know it sounds stupid, but are you sure the script file in the admin section is the right one?
I have multiple sites running but not having this problem before
Big difference in the one in the admin folder is $user_name variable that holds the part of the where clausule for selecting a user name.
So maybe omit this part and try again.
I know it sounds stupid, but are you sure the script file in the admin section is the right one?
I have multiple sites running but not having this problem before
answered
I re-wrote the query as you suggested and it does work now according to how many users I set for rowstart however; clicking on a letter in the search no longer works. Trying to wrap my head around the way this script was written. It's not easy.
Merged on Jan 23 2018 at 11:40:21:
I found the problem. Although it should not be a problem and I don't understand it. Under Settings, User management with 'De-activation System' set to YES it screws up 'administration/members.php' now why is another question and I'm not going to worry about it. My problem is solved.
Merged on Jan 23 2018 at 11:40:21:
I found the problem. Although it should not be a problem and I don't understand it. Under Settings, User management with 'De-activation System' set to YES it screws up 'administration/members.php' now why is another question and I'm not going to worry about it. My problem is solved.
Edited by Grimloch on 23-01-2018 18:40,
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Answered 1 question
Hmm Typical an RTFM-Error :)
I did not know it either.
Thanks for reporting
I did not know it either.
Thanks for reporting
answered
Hmmm... don't know what an RTFM-Error is. BTW I had already replaced 'administration/members.php' and 'includes/classes/ (both userfield class files).php' with files from a fresh download. My question to you is: are you willing to try setting 'Deactivation System' to yes on one of your sites to verify that what I found is in fact a boo-boo or if it's just something in my site? Would be nice to know which. :)
douwe_yntema
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Answered 1 question
I tested and indeed, setting deactivation to YES and admin members is screwed up.
You are the lucky person that indeed found a bug.
You are the lucky person that indeed found a bug.
Category Forum
User Administration - 8Labels
None yet
Statistics
- Views 0 views
- Posts 9 posts
- Votes 0 votes
- Topic users 2 members
2 participants
Grimloch 31
Energy can neither be created nor destroyed; only transformed !
- Senior Member, joined since
- Contributed 722 posts on the community forums.
- Started 141 threads in the forums
- Started this discussions
- Answered 2 questions
douwe_yntema 33
- Senior Member, joined since
- Contributed 667 posts on the community forums.
- Started 57 threads in the forums
- Answered 1 question
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions