XF 1.1 Search Indexing after Import - Runaway count


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?



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