0002135: Drupal search problem

Mantis - Quercus
Viewing Issue Advanced Details

ID:	Category:	Severity:	Reproducibility:	Date Submitted:	Last Update:
2135		minor	always	11-01-07 09:48	02-01-08 03:26

Reporter:	sam	Platform:
Assigned To:	nam	OS:
Priority:	normal	OS Version:
Status:	closed	Product Version:	3.1.3
Product Build:		Resolution:	fixed
Projection:	none
ETA:	none	Fixed in Version:	3.1.5

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:
Relationships
Attached Files:

Notes