Duplicate entry 'conformist' for key 1 query: INSERT INTO search_total and many similair errors

Fresh install 4.7.2
It appears to happen when the cron runs and tries to update the search indexes.

What contributed modules are the rest of you running?
Here's my list:

buddylist
countdown
glossary
invite
nodevote
nodewords
notify
poormanscron
print
privatemsg
tagadelic
userpoints

http://www.webwiseone.com
It's all about community.

Do no Drupal developers check this forum? It would be great to get a resolution to this issue, I'm having it as well. I only share poormanscron with the list desm0n supplied in a reply above. Every cron run that involves indexing produces these errors for me, it has happened since I first started populating my site with content.

Will a Drupal dev please give a helping hand in this matter.

Nick

It appears on our site that the errors occur when a user hits the site and triggers poorman's cron.

Still a mystery to me.

I've posted an issue against Poorman's Cron to see if someone over there will look into it: http://drupal.org/node/85171

Kevin

http://www.webwiseone.com
It's all about community.

You should have the following code (HACK) in the CORE (modules/search/search.module). This is critical issue.

function search_update_totals() {
  // Update word IDF (Inverse Document Frequency) counts for new/changed words
  foreach (search_dirty() as $word => $dummy) {
    // Get total count
    $total = db_result(db_query("SELECT SUM(score) FROM {search_index} WHERE word = '%s'", $word));
    //// === hack, custom by eric START
    $exist = db_result(db_query("SELECT COUNT(word) FROM {search_total} WHERE word = '%s'", $word));
    if (!empty($total) && $exist) {
      // Apply Zipf's law to equalize the probability distribution
      $total = log10(1 + 1/(max(1, $total)));
      db_query("UPDATE {search_total} SET count = %f WHERE word = '%s'", $total, $word);
      //if (!db_affected_rows()) {
      //  db_query("INSERT INTO {search_total} (word, count) VALUES ('%s', %f)", $word, $total);
      //}
    } else {
      db_query("INSERT INTO {search_total} (word, count) VALUES ('%s', %f)", $word, $total);
    }
    //// ==== hack, custom by eric END
</em>
  }
  // Find words that were deleted from search_index, but are still in
  // search_total. We use a LEFT JOIN between the two tables and keep only the
  // rows which fail to join.
  $result = db_query("SELECT t.word AS realword, i.word FROM {search_total} t LEFT JOIN {search_index} i ON t.word = i.word WHERE i.word IS NULL");
  while ($word = db_fetch_object($result)) {
    db_query("DELETE FROM {search_total} WHERE word = '%s'", $word->realword);
  }
}