Not Solved No search results in admin cp
#4
Not Solved
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.
Reply


Messages In This Thread
No search results in admin cp - by spinning - 2019-12-18, 04:56 PM
RE: mo search results in admin cp - by noyle - 2019-12-18, 06:41 PM
RE: mo search results in admin cp - by spinning - 2019-12-18, 06:45 PM
RE: No search results in admin cp - by HLFadmin - 2019-12-18, 10:38 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)