Is it me or does the "Find In Thread" functionality fail with this turned on? Is there a quick fix to this?

I've merged boards and fulltext searching means that I won't have to rebuild search indexes on a 300,000+ post forum.

I'm merging again soon to go over the 500,000+ post mark, and I'll have the same request then too ;)

I'm on version 3.0.3, with debug mode on, but there's no "full text" option in the "version info and other untouchables" section (or anywhere else, for that matter). Did they move (or remove) the fulltext option in 3.0.3?

You're looking in the AdminCp right? Under vBulletin Options?

Yep. Admin CP --> vBulletin Options --> Version Info and Other Untouchables

The options in there are:
-vBulletin Version Number
-Save Attachments as Files
-File Attachment Path
-Save Avatars as Files
-Avatar File Path
-Avatar URL
-WYSIWYG Use DIV not P
-BB Code Parser Function

Then the [save] and [reset] buttons, and the debug box below that.

Am I just missed something dumb here? :)

I've looked everywhere (both in my AdminCP and online for answers) and can't find this option. Anyone have an idea where it might be?

As stated in the first post:

You'll need to shut your boards down for security reasons and
enter debug mode, or enable debug mode for yourself only.

So...

Add that in your config.php file.

Right. I did all of that. Then I go to the Admin CP, then to vBulletin Options, and the Version Info and Other Untouchables option is there. I go into that, but don't see an option for fulltext. All I see are:
-vBulletin Version Number
-Save Attachments as Files
-File Attachment Path
-Save Avatars as Files
-Avatar File Path
-Avatar URL
-WYSIWYG Use DIV not P
-BB Code Parser Function

I'm not sure why it's not there. Is it because I'm on 3.0.3 and not 3.0.2?

Its there in my 3.0.3... how did you upgrade?

Nothing out of the ordinary. I've been slowly upgrading since we started back on version 1.something. Do you know what file I might be out of date on and I'll make sure to reupload that correct one?

I've re-uploaded all of the files in the "admincp" directory, but I still don't have the fulltext option in there. Where is a setting like that stored?

When you upgraded you made sure all the files were 3.0.3 and ran the upgrade scripts? If you dont see that option its telling me that the new vboptions.xml didnt get uploaded before you finished the upgrade.

I'm not sure what happened. The last few upgrades went successfully. The problem was a missing entry in the options table (I think that's the name). Anyhow, it's working now.

Next problem... :)

I'm having problems getting one of the ALTER commands to work. After failing with the "post" one a few times, I tried the "thread" one. It completed successfully in just over 4 seconds. I'm running these queries via SSH.

I've run the "post" ALTER command a few times and it's never able to finish. I've repaired the table (no errors), optimized the table and flushed the index. It still won't finish. I might just be impatient, but I let it go for an hour and it hadn't finished. No error message, just no result. The thread table has about 78,000 records in it, the post table has about 1.3 million records in it.

The other strange thing is that my server load while it's working is almost nothing. It's at most 0.05. I would expect that if it was working that hard on the post index it would be putting more strain on the server.

So, the questions:

- Is a one hour wait for this a problem or am I just impatient? Given that the thread table takes 4 seconds and the post table has about 15 times more records, it should only take about 60 seconds, right?
- Is there a way to simplify the query into a few separate ones so that I can run them one at a time?
- Anything else I can do to optimize the table so this might run faster or finish?

Thanks,
Mickey

ALTER commands usualy take a while, and I am not running this on my own board anymore so i cannot comment too much on it, I hope someone who has abit more knowleged about this can respond.

In the hopes of speeding it up, I've cut the post ALTER command down a bit. Instead of:

ALTER TABLE post ADD FULLTEXT INDEX (title,pagetext)

I'm just doing

ALTER TABLE post ADD FULLTEXT INDEX (title)

Assuming it works, I'll do the pagetext as a separate query as well. Right now we're at 40 minutes and no sign of finishing.

The only reason I'm concerned about it taking so long is that the thread table completed so quickly.

I'll let it go a while longer and see what happens...

Mickey

The post talbe is quite abit larger... have you configured mysql's setting since installing mysql? an unoptmized my.cnf/ini can be horrid for running larger querys like the alter querys.

Yep. It's optimized and it's a fast server (dual Xeon, 2 gigs RAM, SCSI). We're at 2 hours now and it'll still working on it. This can't be right...

Ok, I did a bit more digging and I might have found part of the problem. I was looking at the table in PHPMyAdmin, and found that it has a ton of indexes on it. Here is what it has...

There are 1,526,312 rows in that table, so the ones that show that appear to be done. Should I drop all of the title indexes except for one that has all of the records (like title_2)? Or should I drop all of them and try to reindex?

Same problem. Any way to fix this?

This is now all working in vb 3.0.5 :D

Congrats to all for their hard work, it is VERY appreciated. :)

Does anyone know... are Similar Threads driven by the fulltext search too?

i.e. If I purge my word index tables, will I break anything now that most of this appears to be working?

Good question.

What is the status on this? Are a lot of you using it successfully? I'm considering trying it.

I've been using it on my largest site (1.6M posts) for a few months and it's been working very well.

Personally, Iwouldn't recommend the 3.0.x fulltext search for large sites. Functionally, it works, but since it only used In Boolean mode, it canbe resource heavy. The 3.1 FullText search has options for Bololean andNatural Language search as well as many little optimizations throughout the code.

You know , I've seen that option in the vB options in the admin CP. wanted to try it, but wasn't sure if I should. Now can I test it out woithout clearing my search index?? I'd rather not reindex the search index if this doesn't turn out good results.

Thanks for the tip, Freddie. I'll have to read through the thread again so I better understand - You mean vB 3.0.x vs. a future 3.1 version of vBulletin?

My board isn't very big. The data and index of the database is only about 200 megabytes (attachments are in a separate directory).

I don't plan on doing this right now - maybe in a couple of weeks. Just scoping things out in advance.

How do I enter the debug mode??

THanks

Edit your config.php, and place the following line in it:

Hi, I just switched to FullText Search with Vbulletin 3.0.13

I would like to know if the FullText Search is know more stable than it was in the past ? Is it better than the FullText Hack provided by JohnWoo (https://vborg.vbsupport.ru/showthrea...light=fulltext)

Last question : Except the two queries (Index stuffs with Post and Thread tables) and the "vboption[fulltext] = 1", am I supposed to do something else ?

Thanks in advance for your answears !

/Edit : One more question :D The Relevance Search doesn't seem to work with Fulltext ?