Can't Search One User's Posts

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
E.Isolation
Registered User
Posts: 25
Joined: Sat Apr 12, 2008 3:07 am

Can't Search One User's Posts

Post by E.Isolation » Sun Aug 17, 2008 8:25 am

Version of phpBB2: 2.0.23
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? Fresh install
Did you use an automated wizard provided by your host to install phpBB? No

MODs you have installed: Admin User List2, Super Quick Reply, Split Posts and Merge in One Step 1.0.4, Insert BBcode Equal to phpbb3..(color palette), Global Announcement 1.2.9, RAC Mod.

When the problem started: Not sure. Was informed about it today.
Your level of expertise (be honest): intermediate

Additionally, you may wish to provide the following (where applicable)
Template(s) used: SubBlack
Language(s) used: English
Version of PHP used: 5.2.6
Database and version used: MySQL 4.1.22 standard
-----------------------------------------------------------------------
When I (or the member herself) tries to "find all posts by.." when clicking the link that says that when viewing her profile, it brings up the first page of results which displays her latest posts, but if you click on any of the other page numbers to view more, you only get a "No topics or posts met your search criteria" message.

It works fine for viewing anyone else's posts, and the general search feature seems to be working fine too. Hers are the only posts that are unsearchable.

Any idea what could be the problem? She has 9994 posts, if that matters.
Last edited by ric323 on Sun Aug 17, 2008 10:18 pm, edited 1 time in total.
Reason: Topic icon changed

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Can't Search One User's Posts

Post by ric323 » Sun Aug 17, 2008 9:58 am

E.Isolation wrote:...
She has 9994 posts, if that matters.
That is what is causing the problem, the search is returning too many results.
There is a workaround, just a minute while I dig it up.

Edit: Here it is - http://www.phpbbdoctor.com/blog/2008/03 ... not-found/
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

E.Isolation
Registered User
Posts: 25
Joined: Sat Apr 12, 2008 3:07 am

Re: Can't Search One User's Posts

Post by E.Isolation » Sun Aug 17, 2008 8:43 pm

Thanks for your help! That makes sense because she has so many more posts than anyone else.

I'm going to try the first solution presented on the page you linked, but have a couple quick questions first:

From the linked article:
If you look in search.php you will find a number of places where this code exists:


WHERE post_id IN (" . implode(", ", $search_id_chunks[$i]) . ")
Simply change the implode “glue” from ", " to "," and you’re done. You’ll have to do this in a number of places to get them all. Frankly I would do this even if you are not having problems with search results being too big, as there is less data to push around.
Am I to add an extra quote mark to both sets of these ", ", so it looks like this:
(" . implode("," "," $search_id_chunks[$i]) . ")
or am I just getting rid of the space between the first comma and second quote mark to wind up with this:
(" . implode(",", $search_id_chunks[$i]) . ") :?:

Since the whole section of code wasn't shown in the article's "after" example, it's a little unclear to me exactly how the whole thing should look when I'm done. I'm guessing I'm just getting rid of the one space and leaving everything else alone, but I want to be sure before I mess with anything.

Thanks for any advice.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66332
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Can't Search One User's Posts

Post by Lumpy Burgertushie » Sun Aug 17, 2008 9:27 pm

no, what you are doing is removing spaces from the code:

Code: Select all

(" . implode(", ", $search
notice the space after the first comma.

remove that so it looks like this:

Code: Select all

(" . implode(",", $search
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

E.Isolation
Registered User
Posts: 25
Joined: Sat Apr 12, 2008 3:07 am

Re: Can't Search One User's Posts

Post by E.Isolation » Sun Aug 17, 2008 9:31 pm

Got it. Thank you!

Locked

Return to “2.0.x Support Forum”