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

XF 1.1 Search Indexing after Import - Runaway count

Discussion in 'Installation, Upgrade, and Import Support' started by MRaburn, Dec 4, 2011.

  1. MRaburn

    MRaburn Active Member

    I just migrated to Xen today! Yay!

    I was letting the search index build and about 3 hours in when it got to be over 3.5Gb big and had over 8mil posts indexed when I only have around 4mil messages I just stopped the indexing.

    Search function works but Im not sure what happened. The index table is bigger than the post table.

    Any suggestions on how to clear it out and rerun the index?

    Thanks!
    Mike
     
  2. Floris

    Floris Guest

  3. MRaburn

    MRaburn Active Member

    I am attempting this method now, thanks!



    Mike
     
  4. MRaburn

    MRaburn Active Member

    I rebuilt the table. I had truncated the data first or after I removed the keys, not sure, because when I ran the Enable Keys, the query ran OK and 0 rows affected.

    Here is what this table stucture looks like, just wanted to see if someone see's anything wrong at this point, as search is working.

    Google ChromeScreenSnapz017.jpg
     

Share This Page