vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3 Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=187)
-   -   Howto : Enable FullText Searching in vBulletin 3.0.2/3 (https://vborg.vbsupport.ru/showthread.php?t=66789)

ZiRu$ 07-19-2004 04:57 AM

I don't really understand this fulltext searching....does it only have to do with the members ability to search through the forums or does it allow the ADMIN to search for phrases under "Search Templates"?

Thanks!

MrToasty 08-26-2004 01:25 PM

Bug found - if a user searches for anything with one quotation mark in the query (i.e. 12"), I get an error... but if you use 2 quotation marks, as used with fulltext searching, it works fine...

AnhTuanCool 09-01-2004 12:23 AM

Quote:

Originally Posted by ConqSoft
I did this, and cleared the search index, but it's still showing:

Index Usage 50.31 MB

in the AdminCP stats. Should that be zero?

Can anyone tell me where is that AdminCP stats at? :ermm:

Zachery 09-01-2004 12:59 AM

Quote:

Originally Posted by AnhTuanCOol
Can anyone tell me where is that AdminCP stats at? :ermm:

You need to enable AdminCP Quick Stats in the vBulletin options under AdminCP Prefrecnes.

AnhTuanCool 09-01-2004 01:11 AM

Oh yah, I see it, thanks bro ;)

scotty 09-07-2004 09:41 AM

Quote:

Originally Posted by Erwin
The day that InnoDB supports fulltext, is the day the post table goes InnoDB, to prevent table locking.

does that mean, if i don't use the fulltext search, i can change the post table to InnoDB? and have no table locking any more?

Zachery 09-07-2004 01:58 PM

Quote:

Originally Posted by scotty
does that mean, if i don't use the fulltext search, i can change the post table to InnoDB? and have no table locking any more?

IIRC Erwin found that InnoDB was slower than the current and has moved his other tables back, i may be wrong :)

Killsparer 10-25-2004 07:07 AM

Just wanted to say thanks for this HowTo-Guide!

Switching to FullText-Searching solved all my problems, like timeouts (when editing or deleting a posting/thread) and table-locking (while searching).

Smitty 10-27-2004 01:14 AM

Quote:

Originally Posted by Erwin
The vB 3.0.2 mysql fulltext search is still not as efficient as the vB3 hack version.

Where is the 'hack' version? I did a search here and didn't spot it.

Does it require mysql 4.0.2+?

Zachery 10-27-2004 01:44 AM

Quote:

Originally Posted by Smitty
Where is the 'hack' version? I did a search here and didn't spot it.

Does it require mysql 4.0.2+?

Btoh versions require MysqL 4.0.X


All times are GMT. The time now is 07:24 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01366 seconds
  • Memory Usage 1,735KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete