The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Issues converting to Fulltext search (duplicated index)
Hello everyone.
I have a quite large forum (1,200,000+ posts, 15,000 members) and I'm currently unable to use the search funtion. I've opened a support ticket but the responses I've got didn't solve my problem so I think this would be the best place to open this thread I was having a lot of issues with my forum so I tried to convert to fulltext, hoping I would have a better performance. When I ran the query, my server went crazy so I had to stop it. Final result: post table crashed and a duplicated index on the table (title and title_2). After 15 hours of repairing the post table and trying to recreate the index, I still have a duplicated index (though it shows as fulltext), but when checking the search options, it still shows that I'm using the vB search function instead of Fulltext search. And of course, the normal search doesn't work properly cause I had to empty the index. Having so many problems with my DB lately, I'm scared to delete the wrong index, so I could really use some help. By the way, I ran the query to alter the thread table too. I'm a little bit lost. Anyone willing to help? I'll prepare cookies for everyone :erm: Thanks in advance, guys! Edit: When I enter the post table through phpMyAdmin I get a warning: 'The following indexes appear to be equal and one of them should be removed: title, title_2' |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|