vb.org Archive
Page 5 of 6 « First 34 5 6
Show 40 post(s) from this thread on one page

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)

Zachery 07-02-2004 04:27 PM
Quote:
Originally Posted by ShiningArcanine
It is in 3.02 but not supported so the devs won't say how to enable it in 3.0.2. :(
hehe You should do a search for new posts

ShiningArcanine 07-02-2004 04:31 PM
I'll do that.

cerebro 07-02-2004 07:17 PM
Quote:
Originally Posted by Zachery
hehe You should do a search for new posts
is that oficial VBulletin TEam word? 3.0.2 whit have this hack ?

Boofo 07-03-2004 04:56 AM
Quote:
Originally Posted by Zachery
hehe You should do a search for new posts
Why don't you just post the link? ;)

cerebro 07-03-2004 06:54 AM
Vb 3.0.2 release...whit Hack on :D

mtha 07-03-2004 10:17 AM
Quote:
Originally Posted by Boofo
Why don't you just post the link? ;)
heheh, he wants people to have/practise some skills in hacking community :D


ok, I give a hint (... or tip) :> it's in "Modification Hints and Tips" section :> :rolleyes: :ninja:

Boofo 07-03-2004 10:38 AM
Quote:
Originally Posted by mtha
heheh, he wants people to have/practise some skills in hacking community :D


ok, I give a hint (... or tip) :> it's in "Modification Hints and Tips" section :> :rolleyes: :ninja:
I already found it. I just thought it would be easier posting the link instead of reading through a bunch of "I couldn't find it" messages. ;)

Nitesh 07-05-2004 10:30 AM
I just tryed the mysql search hack that comes with the new 3.0.2.... crashed my computer lol... So im coming back to this hack, I was wondering when will the next update be with all the optimisations in the thread?

Thank you :)

nexialys 07-06-2004 06:57 PM
@Nitesh... FullText Search is NOW integrated to vB 3.0.2 and 3.0.3 ... so it's useless to add this hack... you will simply trash your installation.
you need to take the SQL query found in your Options screen to enable the Search in FullText... because there is a special feature to add to sql, the FULLTEXT thing... it may be the reason your installation trashed.

ImportPassion 07-06-2004 07:10 PM
bleh, vb one didn't work for me. had to go back to this one, and yes i changed the admin hidden options. Not sure if vb.com has it enabled, but if they do, it doesn't work for "search this thread". that was a few days ago.

Nitesh 07-06-2004 07:26 PM
nexialys, I tryed the vbulletin search with the extra code etc... but it was still running down my server. I installed this hack and its back to working faster then ever :) On a large board its definately best to use this hack rather then vbulletins fulltext search.

Erwin 07-06-2004 10:27 PM
Quote:
Originally Posted by Nitesh
nexialys, I tryed the vbulletin search with the extra code etc... but it was still running down my server. I installed this hack and its back to working faster then ever :) On a large board its definately best to use this hack rather then vbulletins fulltext search.
That's my experience. :) That's why I'm still using this one.

nexialys 07-06-2004 11:03 PM
hum... i see your points here... so the best system is the hack here, isn't it ?!

ok, then, if Erwin and some other posted different debugs, wouldn't it be cool to have a final version to date ?!

Erwin argues are the best i can read, but it seems complicated to read all the 12 pages to see if it's ok or not to do this ir that change... can someone post a final 2.3 version of this hack please?! and updated for vB 3.0.3 ??? because lines are changed a lot!

ImportPassion 07-07-2004 12:03 AM
well, erwin says his wasn't working for search this forum and search this thread, but it is for me, so i didn't do his updates.
the original works great for me.

cerebro 07-07-2004 04:45 AM
Well, i try to install this hacks in a fresh 3.0.3 and is not really easy.

Can some one make some v 2.3 whit a good install instruccion and Erwin addon :P

Nitesh 07-07-2004 10:09 AM
Yeah the original 2.2 version of that hack works fine for me, but its a little tricky to do the file edits on search.php as some of the codes different. After messin about a bit its not too difficult to figure out :)

Which part are you stuck on?

nexialys 07-07-2004 12:02 PM
the new 3.0.2+ version have already a part for the fulltext feature because it's now a feature of the board, BUT ... that feature is partial in 3.0.2... this hack have more changes to do with the code, so maybe someone can rewrite it to suite the new options ?!

i would make it, but i'm not ease with it... the best would be to take advantage of the new option of vB and activate this hack when fulltext is activated, and use the old code when it's not ... i've started to try it, but i don't understand the code really well... you guys have more experience on this search feature, i suppose this would help...

cerebro 07-07-2004 06:12 PM
/me vote for that!

nexialys 08-09-2004 06:03 PM
hum.. why this thread was not updated for the last month or so ?! is there someone using it, or we have to forget about it ???

i'd like to see it working properly for 3.0.3, and with everything fixed... is it possible to find it ?!

thanks!

nexialys 08-20-2004 12:10 PM
bumping for the pleasure of it... someone ???

just update the thread please!

ImportPassion 08-20-2004 12:14 PM
i only have one problem, but it works fine in 3.0.3 for me.

if ppl search for 17" rims, it will blow up cause of the ". I should be able to fix it tho.

nexialys 08-20-2004 01:44 PM
the " is easy to deal with, it's a tag... point actually is the install instructions... 3.0.0 is really different from 3.0.3, because of the new fulltext search propriety... is someone updating the install so we can drive it cool ?!

M1th 09-04-2004 03:21 PM
Yep, that'd be cool. It's quite confusing to follow the instructions for 3.0.3.

ImportPassion 09-15-2004 11:30 PM
ok, this thing is now killing my site for some reason, especially when some one searches for say 17" rims.
The vb3 one also kills it, but even worse.

I don't know what to do anymore.

WotC_Tech 09-22-2004 11:15 PM
I've installed this hack and are having good luck with it on vB 3.0.3 with 3 million posts. I did have a performance problem when searching for posts in forums rather than searching against all posts. It appears that Erwin's Add-On helped us a great deal when searching against all posts, but queries against specific forums would often take 30 or more seconds to complete.

We resolved this issue by modifying Erwin's Add-On a bit:

PHP Code:
// Erwin's Add-On

$searchlimit = " WHERE";
$searchforumadd = "";

if ($searchthread) {
$searchlimit = " WHERE post.threadid=$searchthreadid AND";
}

if ($forumchoice) {
$searchforumadd = ", forumid";
// Modified by WotC_Tech
//$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid WHERE forumid IN($forumchoice) AND";
$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid AND thread.forumid IN($forumchoice) WHERE";
}

$fulltext_sql = "SELECT postid$searchforumadd FROM post$searchlimit MATCH (".$what_field.") AGAINST ('$query".$isboolean.") LIMIT 0, ".$vboptions['maxresults'];

// Erwin's Add-On 
It appears that the MySQL optimizer isn't doing its job and running the query as fast as it could.

nexialys 10-08-2004 01:10 PM
diguidi bump! -- want news for this !!!

alexi 11-29-2004 02:25 AM
I'm with nexialys, any chance of getting an updated version of this for 3.03? I'm missing something trying to tie all of these threads together with the changes

Steve St.Lauren 12-27-2004 02:58 PM
With this hack when you search on entire posts it won't search the titles as well. I was searching for a thread on my board and if I did the search on titles only it would come up but if I did the same search on entire posts it won't. Any ideas?

nexialys 02-20-2005 11:02 AM
as msimplay released his new hack for this tool (https://vborg.vbsupport.ru/showthread.php?t=76678), can someone update the install script for 3.0.6 ???

there is a completely different file structure after 3.0.1+, so this would be more than efficient to update the script install process...

someone ?!

msimplay 02-20-2005 11:33 AM
Quote:
Originally Posted by nexialys
as msimplay released his new hack for this tool (https://vborg.vbsupport.ru/showthread.php?t=76678), can someone update the install script for 3.0.6 ???

there is a completely different file structure after 3.0.1+, sothiswould be more than efficient to update the script install process...

someone ?!
Someone has already used the same hack with vb3.06 its installed

nexialys 02-20-2005 03:04 PM
Quote:
Originally Posted by msimplay
Someone has already used the same hack with vb3.06 its installed
yeah, i know, but the hack require some changes to be following the 3.0.6 structure of codes... i know it's possible to install it...

msimplay 02-20-2005 04:42 PM
Quote:
Originally Posted by nexialys
yeah, i know, but the hack require some changes to befollowing the 3.0.6 structure of codes... i know it's possible toinstall it...
what exactly happens when u try to use the installer ?

nexialys 05-23-2005 06:32 PM
hum.. little request here...

vB 3.5 will have the FullText integration complete, is there a beta tester here that knows if THIS hack is the same as the one they will introduce in 3.5 or if it's a complete different story ?!

:)

kmike 05-23-2005 06:52 PM
Fulltext search is available in official vB release ever since version 3.0.2. Though it isn't supported - you have to know where to look to enable it.
Conceptually this hack should be very similar to vB's own implementation. Details will differ of course.
The point is, you can already have look at the official fulltext search code, and compare it to this hack.

nexialys 05-23-2005 07:56 PM
... hum... you did not follow the topic, why do you answer this ?!...
and also, look at who you're talking to, you'll spare some words... (yes i'm the guy in perpetual bad mood)

JohnWoo 05-24-2005 12:07 PM
And I can say only sorry :) I have never seen vb3 other then vb3.0.0 Gold and can't say something exactly...

David Bott 05-27-2005 12:29 PM
Hello John...(Running 3.0.6 (this security updates applied.)

I have a question if I may. I see your full text search requires two different indexes in the post table. One is TITLE and the other is PAGETEXT (keynames). Looking at the structure for the POST table I see these two indexes with pagetext having a 1 after it.

Now looking at how Vb asked for it to be done, they want you to run...

ALTER TABLE post ADD FULLTEXT INDEX (title,pagetext);
ALTER TABLE thread ADD FULLTEXT INDEX (title);

This results, as you know, in a single new index in POST for TITLE that has both TITLE and PAGETEXT in one keyname. (title). Then they wanted another full text search index for the THREAD table for TITLE.

My questions, because I really do not know...

1) What is the difference having two keynames in the POST table, like yours, and only having one (theirs)? What does help with?

2) Does it matter, or will it help, with your code to have the full text search index in the THREAD table like they requested? (I made it just in case.)

I have your code now running on TiVo Community Forum and I am looking to run it on AVS Forum (Even though it is from last year, I hope the code is still ok with the current version Iam running). I am looking for solutions for we are getting killed with the searches more so on AVS Forum. (We went to VB3 last Sunday.)

Thank you for your time.

(Note...I noticed in the VB3 search.php it really needs help. Espically when you have it limite the return. It still searches and returns ALL HITS and then purnes it down to the limit number. Thus the return is still very large. I think your code actually does it correct by stopping when it reached the limit.)

Update...I just installed it on AVS Forum. It took my MySQL load from 1.4 (or more) to currently .38 with 2000 users on-line.

Just need to know why. :)

David Bott 05-30-2005 01:50 PM
Hello Again...

Sad to see no answer to the above. So far the code seems to do very well. But still would love to know why it seems to have a lesswof an impact on MySQL vs what VB3 used.

kmike 05-30-2005 02:10 PM
Quote:
Originally Posted by David Bott
Now looking at how Vb asked for it to be done, they want you to run...

ALTER TABLE post ADD FULLTEXT INDEX (title,pagetext);
ALTER TABLE thread ADD FULLTEXT INDEX (title);
...
1) What is the difference having two keynames in the POST table, like yours, and only having one (theirs)? What does help with?
Two indexes are required to search both title AND post text in default search mode.

David Bott 05-30-2005 02:14 PM
Hello...

Yes, I do see that and have it that way and all is well.

But th questionis as to why. Just wondering what the difference is and why do it that way vs the way VB asked for it to be done. It is more affective? Do I still need the "ALTER TABLE thread ADD FULLTEXT INDEX (title);" as they request?

I guess I am seeking why this hack works so much better than the VB3 version of the Full Text Search.

Thank you.


All times are GMT. The time now is 11:11 AM.
Page 5 of 6 « First 34 5 6
Show 40 post(s) from this thread on one page

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.01416 seconds
  • Memory Usage 1,830KB
  • 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_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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