No search results in admin cp
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.
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.