0002135: Drupal search problem

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0002135

[Quercus]

minor

always

11-01-07 09:48

02-01-08 03:26

Reporter

sam

View Status

public

Assigned To

nam

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.5

Product Version

3.1.3

Product Build

Summary

0002135: Drupal search problem

Description

(rep by jan, http://forum.caucho.com/index.php?q=node/111) [^]

On the Drupal site forum.caucho.com:

Just searched for 'Reflection'
Went back a page, then forward, then back. (In firefox).

Got this in a nice pink box at the top.

* user warning: Table 'temp_search_sids' already exists query: CREATE TEMPORARY TABLE temp_search_sids SELECT i.type, i.sid, SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND (i.word = 'reflection') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in var/www/hosts/forum.caucho.com/webapps/ROOT/includes/database.mysql.inc on line 177.

* user warning: Table 'temp_search_results' already exists query: CREATE TEMPORARY TABLE temp_search_results SELECT i.type, i.sid, 5 * (5.678873758132476 * i.relevance) + 5 * POW(2, (GREATEST(n.created, n.changed, c.last_comment_timestamp) - 1191414942) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + c.comment_count * 0.16666666666666666)) AS score FROM temp_search_sids i INNER JOIN search_dataset d ON i.sid = d.sid AND i.type = d.type INNER JOIN node n ON n.nid = i.sid LEFT JOIN node_comment_statistics c ON c.nid = i.sid WHERE (d.data LIKE '% reflection %') ORDER BY score DESC in var/www/hosts/forum.caucho.com/webapps/ROOT/includes/database.mysql.inc on line 177.

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0002709) nam 02-01-08 03:26	php/1435-1438

Issue History
Date Modified	Username	Field	Change
11-01-07 09:48	sam	New Issue
02-01-08 03:25	nam	Status	new => assigned
02-01-08 03:25	nam	Assigned To	=> nam
02-01-08 03:26	nam	Status	assigned => closed
02-01-08 03:26	nam	Note Added: 0002709
02-01-08 03:26	nam	Resolution	open => fixed
02-01-08 03:26	nam	Fixed in Version	=> 3.1.5

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.