FUDforum: FUDforum 3.0+ » Only one search result is returned.

Home » FUDforum Development » FUDforum 3.0+ » Only one search result is returned.

Show: Today's Messages :: Polls :: Message Navigator

Only one search result is returned. [message #30152]

Tue, 07 February 2006 08:18

stoph

Messages: 7
Registered: February 2006

Karma: 0

Junior Member

Ah, sorry, wrong board. Please move it to bugs Smile

I am using version 2.7.4.
If i do a search only one sesult is returned.

It does its job if i change the lines from 147 in /src/search.php.t
to the following:

	$search_data = '{TEMPLATE: no_search_results}';
	$page_pager = '';
} else {
	$i = 0;
	$search_data = '';

	$tmp = array();

	while ( $r = db_rowobj($c))
	{
		$tmp[] = $r;
	}

	foreach ( $tmp as $r) {
		$search_data .= '{TEMPLATE: search_entry}';
	}

	unset($c);

Die Search results are prefetched into the $tmp array and postet within a foreach loop. The previous code ...

	while ( $r = db_rowobj($c))
		$search_data .= '{TEMPLATE: search_entry}';
	}

	unset($c);

... got me only one sesult.

[Updated on: Tue, 07 February 2006 08:22]

Report message to a moderator

Re: Only one search result is returned. [message #30158 is a reply to message #30152]

Wed, 08 February 2006 00:53

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Works here fine without any changes. The changes themselves don't appear to make any sense.

FUDforum Core Developer

Report message to a moderator

Re: Only one search result is returned. [message #30161 is a reply to message #30158]

Wed, 08 February 2006 10:09

stoph

Messages: 7
Registered: February 2006

Karma: 0

Junior Member

Yes i know that Smile

the only difference is that the data is fetched outside the original while loop. I did some debugging with this.

I don't know which weird php installation we have but the line

$r = mysql_fetch_object ($c)

is executed only once.

Our hoster uses Apache/1.3.31 and PHP Version 4.4.0 with ZendOptimizer.

This is the SystemConfig

PHP built On:  	Linux titanium 2.6.10-as7-he.piii.4gb #1 SMP Thu Jun 2 10:12:05 CEST 2005 i686
Database Version: 	4.0.24_Debian-4.dotdeb.0-log
PHP Version: 	4.4.0
Web Server: 	Apache/1.3.31 (Unix) FrontPage/5.0.2.2635 PHP/4.4.0
WebServer to PHP interface: 	apache
WebServer User/Group: 	99 / 99
Forum Version: 	2.7.4
Relavent PHP Settings: 	
Safe Mode: 	OFF
Open basedir: 	/tmp:/bin:/usr:[..deleted..]
Display Errors: 	OFF
File Uploads: 	ON
Maximum File Upload Size: 	8M
Magic Quotes: 	OFF
Register Globals: 	OFF
Output Buffering: 	Yes
Disabled Functions: 	none
PSpell Support: 	Yes
Zlib Support: 	Yes

Report message to a moderator

Re: Only one search result is returned. [message #30164 is a reply to message #30152]

Wed, 08 February 2006 20:28

stoph

Messages: 7
Registered: February 2006

Karma: 0

Junior Member

Another interesting thing is, that i have the same problem with pdf and rdf generation. After changing the while loops to "Read-In-Temp-First"-Mode everything works.

Perhaps it's a strange php 4.4.0 error.

Report message to a moderator

Re: Only one search result is returned. [message #30167 is a reply to message #30164]

Wed, 08 February 2006 23:28

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Try to disable the Zend Optimizer, it may be the cause of the problem.

FUDforum Core Developer

Report message to a moderator

Re: Only one search result is returned. [message #31731 is a reply to message #30167]

Mon, 15 May 2006 22:54

damien

Messages: 3
Registered: May 2006

Karma: 0

Junior Member

I hit this problem too, and it was due to the mysql_unbuffered_query() function. When I branched uq() to q(), all was back to normal.

Now, what I don't get is that usage of unbuffered_queries seems to be configurable, yet 'Use MySQL 4.1 Performance Options: ' is set to no.... Is there anything else to configure?

Report message to a moderator

Re: Only one search result is returned. [message #31734 is a reply to message #31731]

Tue, 16 May 2006 00:48

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Unbuffered query use is not controlled by configuration options. When deemed safe they are used and in all other places buffered queries are utilized.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	fudforum2.6 + index.php was not found on this server
Next Topic:	HTML and FUDcode together?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 11:40:32 GMT 2024

Total time taken to generate the page: 0.02742 seconds