vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Fulltext boolean search v.2.2 for vB (https://vborg.vbsupport.ru/showthread.php?t=62282)

nexialys 05-30-2005 02:56 PM

the "actual" version of fulltext inside vB is not working at all... 75% of the results are falsed and bug on most Mysql systems because not fixed... that'S why vB 3.5 will ahve a complete new fulltext integration, mostly based on this one... logically... 0:)

David Bott 05-30-2005 03:27 PM

Ah. Why thank you very much. Thus the issue we had when we made the move to VB3 with the high mysql loads and frequent site outages.

I am guessing then I do not need their...

ALTER TABLE thread ADD FULLTEXT INDEX (title);

...querty and I can dump that index.

nexialys 05-30-2005 03:43 PM

this actual hack was built before the full index modification was applied in vB 3.0.1, therefore you can delete that index... because vB added the fulltext in vB 3.0.2 ...

David Bott 05-31-2005 12:24 PM

Well in the VB version of the code, Full Text seems to work well other than the high loads. Meaning....if someone looks for "the quick brown fox" it finds that. However...I just received this...

Quote:

Is there any way to search for an exact phrase? On the Search FAQ page there are a couple of matching options, including "Match Complete Phrase", but on the Search Forums page there is only a keyword search. For example, if I search the forums for "whole house audio" it returns some 300 threads, all of which contain the three words somewhere, but not necessarily the whole phrase.

I've tried some things like using quotes and Boolean operators (AND, OR, NOT) -- with no luck. Am I missing something, or is this simply not an option?
I tested this and found he is correct. It does not hit like a full text search should.

Anyone have any thoughts on this?

Thank you.


*** Disreguard...NOTE...You need to have "Allow Search Wild Cards" set to YES in the Message Searching Options area of the Vb Options page.

David Bott 06-08-2005 09:23 PM

Hello again...

I searched for the word RAID and the user name of BasementBob on my site in advanced mode. It retured no results even though their are threads by him with the word RAID in it. So the question is...Can you not use both the word box and the user name box at the same time with this hack running?

Can someome please test and advise.

Thanks

David Bott 06-24-2005 11:59 AM

Ok, have some more issues and I have no clue why.

In this thread you can see a user reported an issue with not finding posts with the serach that clearly has the words in it.

http://www.tivocommunity.com/tivo-vb...d.php?t=246239

After testing I had found this to be true and droped the indexes and regreated them based on the information provided in the install text file.

even tried to find that thread above by seraching for "channels" and even "DirectTV" and could not even find that thread that reported the same issue.

Any thoughts on this?

MySQL version = MySQL 4.1.10a

David Bott 07-05-2005 02:25 PM

Hello...Anyone? Is this hack no longer supported?

Thank you.

Steve St.Lauren 07-05-2005 03:51 PM

Do you still have the hack installed? If so then you must have missed some part of the hack install. I just did a search on "+tivo +will +no +longer +change" in titles only in that forum to try to find the thread in question and it returned two threads that didn't include all of those terms in the search results - it shouldn't have returned those. My guess is that you missed some part of the hack install - check it over carefully again.

David Bott 07-08-2005 08:37 PM

I have done so now more than once. Not new to this at all as you may see. ;) I just do not get it. Something justis not right and it happen both on TiVo Community Forum and AVS Forum.

Thank you kindly for the reply.

[Edited to removed requested found item.]

klamm 08-01-2005 02:18 AM

Guys, you saved me! :)

I'm running a >2 Million Posts Board with 500 Users on ... heaviest load during searches using the standard algorithm. Now I tried this hack (vb 3.0.8, including Erwins improved Addon) and load is going down to nearly zero!
Thank God for this hack!

Btw: The built-in-hidden-debug-beta-fulltext-VB-search - don't even think of trying it @ big boards. It will only crash your machines ...


All times are GMT. The time now is 06:44 AM.

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.01663 seconds
  • Memory Usage 1,740KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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