• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Cannot reproduce Server error log reports - Table 'xf_search_index_temp' already exists

AndyB

Well-known member
#1
I recently upgraded to ElasticSearch 1.0.2 and I just got this in my Server error log:

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Table 'xf_search_index_temp' already exists - library/Zend/Db/Statement/Mysqli.php:214
Generated By: Rick, 35 minutes ago

...

array(3) {
  ["url"] => string(50) "http://www.myforum.com/forums/search/search"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(12) {
    ["keywords"] => string(0) ""
    ["users"] => string(6) "Rick, "
    ["user_content"] => string(6) "thread"
    ["date"] => string(0) ""
    ["reply_count"] => string(3) "110"
    ["nodes"] => array(1) {
      [0] => string(2) "19"
    }
    ["order"] => string(4) "date"
    ["type"] => string(4) "post"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(25) "/forums/search/?type=post"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
 

Mike

XenForo developer
Staff member
#2
Oops, missed this - does your MySQL user have permission to create temporary tables? If not, they need that permission.