0002135: Drupal search problem

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

Status

closed

Product Version

3.1.3

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.

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.