Go Back   vb.org Archive > Community Discussions > Forum and Server Management
  #771  
Old 03-01-2010, 08:42 PM
ivanp ivanp is offline
 
Join Date: Sep 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any update for Sphinx for vB4?
Reply With Quote
  #772  
Old 03-01-2010, 09:12 PM
Lea Verou Lea Verou is offline
 
Join Date: Jul 2005
Location: Greece
Posts: 1,856
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Has anyone used Sphinx with languages != english?
Does it work correctly?
FULLTEXT had issues with greek...
Reply With Quote
  #773  
Old 03-13-2010, 04:18 PM
boggseric's Avatar
boggseric boggseric is offline
 
Join Date: Sep 2009
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kerplunknet View Post
Has anyone figured out the "Find More Posts by UsernameHere" issue? It results in these error messages, but the results seem to work properly:

PHP Code:
Warningstrpos() [function.strpos]: Empty delimiterin /includes/functions_search.html on line 868

Warning
strpos() [function.strpos]: Empty delimiterin /includes/functions_search.html on line 868

Warning
strpos() [function.strpos]: Empty delimiterin /includes/functions_search.html on line 868

Warning
strpos() [function.strpos]: Empty delimiterin /includes/functions_search.html on line 868

Warning
strpos() [function.strpos]: Empty delimiterin /includes/functions_search.html on line 868

Warning
strpos() [function.strpos]: Empty delimiterin /includes/functions_search.html on line 868

Warning
strpos() [function.strpos]: Empty delimiterin /includes/functions_search.html on line 868 
I really don't want to put Sphinx live until this is fixed... any advice would be welcome.

I am wondering if it has something to do with using an older 3.6 version of vBulletin.
This is a pretty old post but it is still relevant. The from looking at the line it's refereing to it looks like he problem is with the function that it is trying to find the search text in the post result to highlight it. Since there is no search text the value is null and strpos does't like that.


edit: I think I got it fixed. The problem is with the process_quote_removal function.
Keep in mind I am running 3.8.4pl2
I edited includes/functions_search.php and made the following changes

Search for this block of code:
Code:
function process_quote_removal($text, $cancelwords)
{
	$lowertext = strtolower($text);
	foreach ($cancelwords AS $word)
	{
		$word = str_replace('*', '', strtolower($word));
		if (strpos($lowertext, $word) !== false)
		{
			// we found a highlight word -- keep the quote
			return "\n" . str_replace('\"', '"', $text) . "\n";
		}
	}
	return '';
}
This line is the culprit for me:
Code:
if (strpos($lowertext, $word) !== false)
it appears that $word ends up being null which causes strpos to puke the errors.

so I changed the function to this:
Code:
function process_quote_removal($text, $cancelwords)
{
	$lowertext = strtolower($text);
	foreach ($cancelwords AS $word)
	{
		$word = str_replace('*', '', strtolower($word));
		if ($word !== '')
		{
		   if (strpos($lowertext, $word) !== false)
		   {
			   // we found a highlight word -- keep the quote
			   return "\n" . str_replace('\"', '"', $text) . "\n";
		   }
		}
	}
	return '';
}
You can see I just added an if statement to check if $word is null. If $word is null it skips over the code since there is obviously nothing to highlight.

I have tested the normal search and the search term is still highlighted and I am no longer getting errors during search for more posts by this user.. YMMV.
Reply With Quote
  #774  
Old 03-13-2010, 11:11 PM
WoodiE WoodiE is offline
 
Join Date: May 2002
Posts: 317
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is this real or just an info about Sphinx? Someone told me that it costs $2,000 to have it setup on vBulletin - no?
Reply With Quote
  #775  
Old 03-13-2010, 11:57 PM
TechGuy TechGuy is offline
 
Join Date: Nov 2001
Location: Waynesboro, PA USA
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Unfortunately, no... you can install Sphinx yourself for free, but it is no small task and there are some issues to deal with.

The $2k is likely referring to the "Axivo Searchlight" product, though I hesitate to use the word product as it's been "coming soon" for more than a year. They finally released a closed beta, so I suspect it's still being developed, but that was over three months ago and still no product.
Reply With Quote
  #776  
Old 03-13-2010, 11:59 PM
boggseric's Avatar
boggseric boggseric is offline
 
Join Date: Sep 2009
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by WoodiE View Post
Is this real or just an info about Sphinx? Someone told me that it costs $2,000 to have it setup on vBulletin - no?
I just set it up using the info in post 1 and the files from post 582

I used the info from this post to make sure it stayed running and this post to setup the crons for delta and nightly.

Other than that the only changes I made were from my previous post to fix the "find more posts by this user" issue.

It is now up and running on my 3.8.4pl2 forums with:
Threads: 799,861, Posts: 11,892,282, Members: 24,815

I set the max amount of of results to 20,000 and it's working great. Searches no longer take my forum to it's knees.

The things I haven't done yet are to remove the indexes from post and convert my tables to innodb.


Total cost? My time reading through this never ending thread and compiling the data above.
Reply With Quote
  #777  
Old 03-14-2010, 01:10 PM
WoodiE WoodiE is offline
 
Join Date: May 2002
Posts: 317
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

TechGuy - I didn't realize there was two different options for using Sphinx on vBulletin. Though by the sounds of it neither are very easy to setup. One either very pricey, two according to boggseric a lot of files and editing to do - both still have issues and nothing everything working.

Does anyone know of any other solutions to making vBulletin search easier on the server and sill maintain all of vB's features?
Reply With Quote
  #778  
Old 03-14-2010, 06:24 PM
adnoid adnoid is offline
 
Join Date: May 2008
Posts: 13
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by boggseric View Post
I just set it up using the info in post 1 and the files from post 582

I used the info from this post to make sure it stayed running and this post to setup the crons for delta and nightly.

Other than that the only changes I made were from my previous post to fix the "find more posts by this user" issue.

It is now up and running on my 3.8.4pl2 forums with:
Threads: 799,861, Posts: 11,892,282, Members: 24,815

I set the max amount of of results to 20,000 and it's working great. Searches no longer take my forum to it's knees.

The things I haven't done yet are to remove the indexes from post and convert my tables to innodb.


Total cost? My time reading through this never ending thread and compiling the data above.
Thank you for putting this all together. I've been looking at the alternatives for our board, now approaching 5,000,000 posts. I'm not a heavyweight coder, but I'll be giving your method a shot.
Reply With Quote
  #779  
Old 03-15-2010, 11:39 AM
boggseric's Avatar
boggseric boggseric is offline
 
Join Date: Sep 2009
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by WoodiE View Post
TechGuy - I didn't realize there was two different options for using Sphinx on vBulletin. Though by the sounds of it neither are very easy to setup. One either very pricey, two according to boggseric a lot of files and editing to do - both still have issues and nothing everything working.

Does anyone know of any other solutions to making vBulletin search easier on the server and sill maintain all of vB's features?
You'd probably be best off if you did it yourself, that way if you need to make changes in the future you know what you are doing. It's not overly complicated.

I don't know squat about linux or vB but I know computers and some programming (other than PHP). I managed to fumble my way through it.

If you can afford the 2k solution, good. If not maybe you'd be better off paying someone to set sphinx up for you.
Reply With Quote
  #780  
Old 03-15-2010, 11:42 AM
TechGuy TechGuy is offline
 
Join Date: Nov 2001
Location: Waynesboro, PA USA
Posts: 55
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My point is that even if you can afford the $2k solution, it doesn't matter -- that solution doesn't exist.

Without reading through the entire thread, what's the status of using advanced search fields using the solution you mentioned earlier? (It was a long time ago when we last tried, but I remember we had to drop it because we couldn't sort by most of the fields.)
Reply With Quote
Reply

Thread Tools
Display Modes

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 07:35 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04609 seconds
  • Memory Usage 2,291KB
  • Queries Executed 12 (?)
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
  • (3)bbcode_code
  • (1)bbcode_php
  • (4)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
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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