Go Back   vb.org Archive > Community Central > vBulletin.org Site Feedback
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #11  
Old 07-20-2009, 12:15 PM
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Also, please note that another work-around that does not require any changes to vB or the MySQL configuration is to use Google site search.

(That is what we did, and it works great.)

So... there are many solutions to the problem, and all are pretty "quick and easy".

If you don't want to alter MySQL, then Google site search is a great alternative.
Reply With Quote
  #12  
Old 07-20-2009, 12:16 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

We are not alone on this server. Changing the MySQL config would take a few minutes, rebuiolding the sewarch indexes would take a few days (!!!) and would leave all the Jelsoft sites offline during this.
Reply With Quote
  #13  
Old 07-20-2009, 12:18 PM
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Marco van Herwaarden View Post
The vB Options don't work if you are using MySQL Full text search, these options only work if you are using the vB internal search
So, then just alter the MySQL Full text search, LOL

It takes 15 seconds to make the change and a few minutes for MySQL to rebuild the index.

The issue is not "it is quick or easy" to do it. It seems you simply don't want to do it.

There is quite a difference in saying "it is not easy" versus "we don't want to do it".

--------------- Added [DATE]1248095946[/DATE] at [TIME]1248095946[/TIME] ---------------

Quote:
Originally Posted by Marco van Herwaarden View Post
The vB Options don't work if you are using MySQL Full text search, these options only work if you are using the vB internal search
(Or simply install Google site search, that is what we did, ROTFL... too easy)

--------------- Added [DATE]1248096434[/DATE] at [TIME]1248096434[/TIME] ---------------

Quote:
Originally Posted by Marco van Herwaarden View Post
We are not alone on this server. Changing the MySQL config would take a few minutes, rebuiolding the sewarch indexes would take a few days (!!!) and would leave all the Jelsoft sites offline during this.
Nonsense. Rebuilding a search index will not bring down this site. It is intensive, but will not bring down the site or sites. Do it on the weekend :-)

Anyway, to the original poster, it is obvious the site is not going to make any changes and will more-than-likely not install Google site search, so nevermind.. just do something with Google like:

Quote:
ads site:vbulletin.org
--------------- Added [DATE]1248096832[/DATE] at [TIME]1248096832[/TIME] ---------------

For others interested in this for vB, the process to rebuild a vB MySQL fulltext search index is documented here:

How to enable 3-letter-words in Vbulletin w/ MySQL fulltext search

... and no, it will not bring down your forum. That is why there are holidays and weekends :-)
Reply With Quote
  #14  
Old 07-20-2009, 01:08 PM
Wayne Luke's Avatar
Wayne Luke Wayne Luke is offline
Senior Member
 
Join Date: Jan 2002
Location: Southern California
Posts: 1,694
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by imported_silkroad View Post
Nonsense. Rebuilding a search index will not bring down this site. It is intensive, but will not bring down the site or sites. Do it on the weekend :-)
Not going to happen. All the official vBulletin sites would have to have their indexes rebuilt. Including the almost 1 million threads in the Support Ticket system and the customer database. Those systems will have to be taken offline until the indexes are rebuilt and that isn't something we're willing to do, even on a weekend and support knows no holidays. You will have to live with the limitations at this time.
Reply With Quote
  #15  
Old 07-20-2009, 01:41 PM
imported_silkroad imported_silkroad is offline
 
Join Date: Dec 2003
Posts: 563
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Actually, it makes little difference to me, as I search with Google using site:blahblah.com . However, it makes a difference for many users on technical sites because 4 letters is way to short. Three letters is the recommended mininum for technical sites.

What most people do when they have production systems (and cannot risk building the index on line) is to simply rebuild the fulltext search index table on a development server and move the table(s) from development to production It is pretty easy to do this and well documented.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:49 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.05506 seconds
  • Memory Usage 2,228KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (5)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete