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

XF 1.5 Creating a missing table again

Discussion in 'XenForo Questions and Support' started by SeaDog, Feb 9, 2016.

  1. SeaDog

    SeaDog Active Member

    Hi, we've had a roller coaster of a time with our site, I think due to merging two old forums (vB and phpBB) in to one. The bottom line is we encountered some major database issues, which have mainly be resolved now. The main 'fix' for this was to remove the xf_search.frm file from the database folder in /var/lib/mysql/xxx.

    The forum is working, but obviously search isn't. I was wondering if anyone could share the necessary MySQL command to recreate this table? I believe it's called simply xf_search - but obviously I don't know what fields it had in or whether it has some data (I assume it's populated during the indexing or is it a log searches?).
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    Look in the following file:

    library/XenForo/Install/Data/MySql.php

    In there you will find an xf_search query; that's the one you need to run to recreate that table.
     
  3. SeaDog

    SeaDog Active Member

    Perfect - located that, thanks @Chris D

    We have 175 tables presently, the only 2 *not* starting with xf_ are archived_import_log and archived_import_log_phpbb

    So with the missing xf_search table, we would have 176 or 174 excluding those 2 above.

    Is that the right number?
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    I'm unsure of the exact number but that sounds about right.
     

Share This Page