FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » Only one search result is returned.
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Only one search result is returned. [message #30152] Tue, 07 February 2006 03:18 Go to next message
stoph is currently offline  stoph   Germany
Messages: 7
Registered: February 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 03:22]

Report message to a moderator

Re: Only one search result is returned. [message #30158 is a reply to message #30152] Tue, 07 February 2006 19:53 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Works here fine without any changes. The changes themselves don't appear to make any sense.

FUDforum Core Developer
Re: Only one search result is returned. [message #30161 is a reply to message #30158] Wed, 08 February 2006 05:09 Go to previous messageGo to next message
stoph is currently offline  stoph   Germany
Messages: 7
Registered: February 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: Only one search result is returned. [message #30164 is a reply to message #30152] Wed, 08 February 2006 15:28 Go to previous messageGo to next message
stoph is currently offline  stoph   Germany
Messages: 7
Registered: February 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Re: Only one search result is returned. [message #30167 is a reply to message #30164] Wed, 08 February 2006 18:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Try to disable the Zend Optimizer, it may be the cause of the problem.

FUDforum Core Developer
Re: Only one search result is returned. [message #31731 is a reply to message #30167] Mon, 15 May 2006 18:54 Go to previous messageGo to next message
damien is currently offline  damien   Canada
Messages: 3
Registered: May 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Re: Only one search result is returned. [message #31734 is a reply to message #31731] Mon, 15 May 2006 20:48 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Sun Oct 22 04:31:46 EDT 2017

Total time taken to generate the page: 0.00746 seconds