Last month my forum (
http://www.ikf.forum.eu) succesfull repaired by HLF-Larry. He did a great job.
How My forum was repaired
- back up from database 1.6
- install a complete new forum 1.8.21
- import database
- some small issues repaired
- working
Today I wanne search for users in the admin CP and there is some what not work correct. Only the users who became member after this repaires are found.
When i search for myselfes by mail adres, or admin function no results.
When I search by users name, no results.
When I search for registerend users only 480 users showed up, I have 3000 registered usersl.
For every search I get the message
No users were found matching the specified search criteria. Please modify your search criteria and try again.
Go to AdminCP's home and figure out how many users does your forum has. The number of users is shown in AdminCP's Dashboard.
If the number isn't right, maybe the repair went wrong. If the number if somehow correct, go to user group management to check if the former users are in another user group other than registered.
3136 Users and believe me te most of them are registred users and not administrators or moderators.
Default view of all users comes up with 157 pages of 20 entries = 3140 members.
Creating a new view of users without selecting any filters, showing the same fields comes up with 25 pages of 20 entries = 500 members.
I don't know how to read the database fields, but the 2 views are different.
Comparing default to new:
fields (identical)
a:7:{i:0;s:6:"avatar";i:1;s:8:"username";i:2;s:5:"email";i:3;s:7:"regdate";i:4;s:10:"lastactive";i:5;s:7:"postnum";i:6;s:8:"controls";}
a:7:{i:0;s:6:"avatar";i:1;s:8:"username";i:2;s:5:"email";i:3;s:7:"regdate";i:4;s:10:"lastactive";i:5;s:7:"postnum";i:6;s:8:"controls";}
conditions (very much different)
a:0:{}
a:17:{s:8:"username";s:0:"";s:5:"email";s:0:"";s:7:"website";s:0:"";s:3:"icq";s:0:"";s:5:"yahoo";s:0:"";s:5:"skype";s:0:"";s:6:"google";s:0:"";s:9:"signature";s:0:"";s:9:"usertitle";s:0:"";s:11:"postnum_dir";s:12:"greater_than";s:7:"postnum";s:0:"";s:13:"threadnum_dir";s:12:"greater_than";s:9:"threadnum";s:0:"";s:7:"regdate";s:0:"";s:5:"regip";s:0:"";s:6:"lastip";s:0:"";s:6:"postip";s:0:"";}
custom profile fields (very different)
null
a:5:{s:4:"fid3";a:1:{s:4:"fid3";s:3:"N/A";}s:5:"fid17";a:1:{s:5:"fid17";s:0:"";}s:5:"fid15";s:0:"";s:4:"fid1";s:0:"";s:4:"fid2";s:0:"";}
These results are similar on the local copy I made. My new view results in 3 times as many results: 75 pages of 20 entries = 1500 members. Which is far fewer than the 4480 members with the default view. You culled quite a few spammers or invalid registrations after your update went live.
It is interesting that the results boundaries are quite similar, your 500 and my 1500. I suspect that the query formed from the created new view is similar to the one formed by simply filling out the search form. And that there may be a server limit imposed by searching with a malformed query.
It appears that the forum view search on the memberlist yields correct results. Something is not right on the queries generated in the AdminCP.