1. 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

Discussion in 'Enhanced Search Resolved Bugs' started by AndyB, Nov 27, 2013.

  1. AndyB

    AndyB Well-Known Member

    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"
      }
    }
    
     
  2. Mike

    Mike XenForo Developer Staff Member

    Oops, missed this - does your MySQL user have permission to create temporary tables? If not, they need that permission.
     
  3. AndyB

    AndyB Well-Known Member

    Hi Mike,

    I only received this error once. So it looks like you can safely ignore it.
     

Share This Page