Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #601  
Old 07-08-2008, 04:29 AM
amcd amcd is offline
 
Join Date: Oct 2004
Posts: 218
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by wtrk View Post
i have a question, can sphinx also search other databases and show the results in vbulletin? like for example can i consolidate a search of vbulletin, photopost and reviewpost into a single result displayed in vbulletin with sphinx?
Since sphinx is a general purpose search tool, I suppose it could be done, but not with the code posted in this thread. It would require major modification of search.php and related modules and templates.
Reply With Quote
  #602  
Old 07-08-2008, 06:12 PM
wtrk wtrk is offline
 
Join Date: Jun 2005
Posts: 256
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by amcd View Post
Since sphinx is a general purpose search tool, I suppose it could be done, but not with the code posted in this thread. It would require major modification of search.php and related modules and templates.
i understand that thats why beyond the scope of this thread. i just wanted to know if it was possible. thanks.
Reply With Quote
  #603  
Old 07-11-2008, 09:04 PM
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Location: Canton, MI USA
Posts: 103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm somewhat geeked: I have Sphinx running on my test forum! Finally got indexer and searchd to run and load. NO errors from what I can tell--this has to be a first!

I did the changes to vB 3.7 (uploaded search_sphinx.php, sphinxapi.php, added the two plugins), but I can't tell if I'm using Sphinx or not. Is there any way I can tell? Searches were fast to begin with on this smaller forum, so time is not a good benchmark here. Any other way to tell? I did enter a new post with the word "privileges" in it, and I see it did not show up in Sphinx (using search at the command line) after I ran the "indexer --all" command for a second time.

I just want to see IF it is working before I test HOW it is working. It seems like it went too easily for it to be working properly...
Reply With Quote
  #604  
Old 07-13-2008, 03:08 PM
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Location: Canton, MI USA
Posts: 103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's working. If I kill searchd, I get an error that it can't connect to "localhost". I now have cron running as well, and new posts are indexed within three minutes.

Speed is actually slightly slower for Sphinx on this smaller test forum, but we don't have that many posts. I may bite the bullet and try this on the main forum soon.
Reply With Quote
  #605  
Old 07-15-2008, 03:39 PM
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Location: Canton, MI USA
Posts: 103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BillP View Post
We are running the new plugin with 3.7.1

When one clicks on a username and chooses "Find More Posts By <user>", the following warning appears on the "Your search is in progress" page:


Then it refreshes, and returns numerous errors followed by the results:

Code:
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
Any ideas on how to fix this?
We just had this same error. I can't duplicate it myself, but another user mentioned that he was doing an advanced search for "Threads started by user" and got multiple instances of this error. I tried the same search (no other options chosen), and it worked OK. Seems random...?
Reply With Quote
  #606  
Old 07-15-2008, 05:06 PM
eoc_Jason's Avatar
eoc_Jason eoc_Jason is offline
 
Join Date: Dec 2001
Location: Houston, TX
Posts: 493
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by wtrk View Post
i have a question, can sphinx also search other databases and show the results in vbulletin? like for example can i consolidate a search of vbulletin, photopost and reviewpost into a single result displayed in vbulletin with sphinx?
There's no reason you couldn't... But it would be custom coding for you... You would have to create extra sources to index first. Then deal with how you are going to search them.

P.S. Sphinx 0.9.8 Gold (or whatever you want to call the final) has been released today!
Reply With Quote
  #607  
Old 07-16-2008, 01:09 PM
RedWingFan's Avatar
RedWingFan RedWingFan is offline
 
Join Date: Oct 2004
Location: Canton, MI USA
Posts: 103
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by RedWingFan View Post
We just had this same error. I can't duplicate it myself, but another user mentioned that he was doing an advanced search for "Threads started by user" and got multiple instances of this error. I tried the same search (no other options chosen), and it worked OK. Seems random...?
Not random. If I choose "View Results as Posts", I get the errors. If I view results as threads, no errors.

Code:
Warning: strpos() [function.strpos]: Empty delimiter in [path]/includes/functions_search.php on line 829
The proper search results do display below, however...
Reply With Quote
  #608  
Old 07-17-2008, 02:44 PM
mute mute is offline
 
Join Date: Dec 2002
Location: Phoenixville, PA
Posts: 152
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just upgraded to 0.9.8, but am running some incredibly old search.php code (on 3.6). So far so good. I had to do a major reorg of my sphinx.conf, but I couldn't resist some of the new options (unlink_old is nice because this box has limited diskspace).

I'm curious if anyone has a definitive status report on what is and is not working properly on 3.7. I see orban has updated the first post recently, but I wasn't sure if all of the quirks that are listed were still applicable.

We're not ready to upgrade to 3.7 yet, but I'd really like to have "Find all posts/threads by user" hitting Sphinx when we do, those queries are sort of brutal for us.

Also, does anyone have a decent guide on "How to search" laying around? Our users seem to have trouble figuring out search operands, searching for phrases, etc. I was hoping someone who uses sphinx might have a FAQ entry done up that explains what you can and can't do with this setup.
Reply With Quote
  #609  
Old 07-18-2008, 04:59 PM
Simetrical Simetrical is offline
 
Join Date: Nov 2006
Location: New York City
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by mute View Post
We're not ready to upgrade to 3.7 yet, but I'd really like to have "Find all posts/threads by user" hitting Sphinx when we do, those queries are sort of brutal for us.
If it only searches for posts by the user and nothing else (no search terms added), you should just add an index on (userid, dateline) to your post table. Then it will be as fast as fetching the posts for a thread. You don't need an external engine like Sphinx to do this fast. The situation with threads is similar, (postuserid, dateline). Use Sphinx for fulltext searching; MySQL proper is still just fine for searches without any text aspect.
Reply With Quote
  #610  
Old 07-18-2008, 07:38 PM
mute mute is offline
 
Join Date: Dec 2002
Location: Phoenixville, PA
Posts: 152
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Simetrical View Post
If it only searches for posts by the user and nothing else (no search terms added), you should just add an index on (userid, dateline) to your post table. Then it will be as fast as fetching the posts for a thread. You don't need an external engine like Sphinx to do this fast. The situation with threads is similar, (postuserid, dateline). Use Sphinx for fulltext searching; MySQL proper is still just fine for searches without any text aspect.
We have 47 million posts, and 2.6 million threads. Trust me, it puts a hurting even on our 8-way Opteron box with 12gb of ram.
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 07:47 PM.


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.07408 seconds
  • Memory Usage 2,285KB
  • 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
  • (2)bbcode_code
  • (7)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
  • (3)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