[drupal-devel] [bug] search_total not being completely built

mitomac drupal-devel at drupal.org
Sat Apr 2 18:12:25 UTC 2005


Issue status update for http://drupal.org/node/19887

 Project:      Drupal
 Version:      cvs
 Component:    search.module
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  mitomac
 Updated by:   mitomac
 Status:       active

Using the latest version of CVS (040205) and mysql.  Converted a 4.5
install to 4.6.  Ran cron.php several times to generate a new
search_index.  That worked fine and the search_index is fully populated
with all the words from the various nodes.  However, search_total is not
being fully rebuilt.  For some reason not all the distinct words are
making it into search_total.  For example:
"SELECT COUNT(DISTINCT(words)) FROM search_index" returns 4641 words,
whereas:
"SELECT COUNT(DISTINCT(words)) from search_total" only returns 1889
words.
No search results are returned for any of the 2752 words omitted in the
search_total table.  
Any ideas on trouble shooting this further.  Because there is no
ordered index, I'm having trouble pinpointing where the update of the
search_total table breaks down.
Thanks in advance,
mitomac


mitomac




More information about the drupal-devel mailing list