Mantis Bugtracker
  

Viewing Issue Advanced Details Jump to Notes ] View Simple ] Issue History ] Print ]
ID 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   OS
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[^]
Copyright © 2000 - 2005 Mantis Group
29 total queries executed.
26 unique queries executed.
Powered by Mantis Bugtracker