Mantis Bugtracker
  

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