Go Back   vb.org Archive > vBulletin Modifications > Premium Modifications > vBulletin Open Source Products > Sphinx
Reload this Page Troubles executing the indexer
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Troubles executing the indexer Details »»
Troubles executing the indexer
Version: , by RedFoxy RedFoxy is offline
Developer Last Online: Dec 2021 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 06-08-2010 Last Update: Never Installs: 0
 
No support by the author.

Hi all!
I installed lastes sphinx from FreeBSD ports, I created /usr/local/sphinx with /var/log and /data then i changed the owner in the one created by port...

After that I followed the vbulletin.com guide to complete the installation...

I've 2 troubles but one is not a really trouble...

First problem:
PHP Code:
/usr/local/sphinx# ./cron/main_norotate.sh 
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/usr/local/sphinx/vbulletin-sphinx.php'...
ERROR: invalid token in /usr/local/sphinx/vbulletin-sphinx.php line 1 col 1.
ERROR: invalid token in /usr/local/sphinx/vbulletin-sphinx.php line 1 col 1.
FATAL: failed to parse config file '/usr/local/sphinx/vbulletin-sphinx.php'
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff 
That trouble come because I can't execute /usr/local/sphinx/vbulletin-sphinx.php directly:
PHP Code:
/usr/local/sphinx# ./vbulletin-sphinx.php
Extension '/home/apacheweb/softairmania.it/_sphinx/vbulletin-sphinx.php' not present. 
but if i execute it using php ./vbulletin-sphinx.php it goes, than I runs it saving the output in a file but running for example:

PHP Code:
/usr/local/sphinx# /usr/local/bin/indexer --config /usr/local/sphinx/softairmania.conf ForumMain
Sphinx 0.9.9-id64-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff

using config file '/usr/local/sphinx/softairmania.conf'...
indexing index 'ForumMain'...
ERROR: index 'ForumMain': sql_query_pre[0]: Table 'my_vb_database.vbsphinxsearch_queue' doesn't exist (DSN=mysql://my_user:***@my_database_ip:3306/my_vb_database).
total 0 docs, 0 bytes
total 0.004 sec, 0 bytes/sec, 0.00 docs/sec
total 0 reads, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg
total 0 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg 
It don't found a table called vbsphinxsearch_queue, then I checked the vbulletin-sphinx.php and I seen that it searches tables that I haven't in my database, like vbsphinxsearch_queue.

There is something that I haven't...

What can I do to fix it?

Thank's

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-08-2010, 10:24 AM
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
Senior Member
  
Join Date: Aug 2002
Location: France
Posts: 515
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Did you imported the product?
Reply With Quote
  #3  
Old 06-08-2010, 11:12 AM
RedFoxy's Avatar
RedFoxy RedFoxy is offline
 
Join Date: Sep 2007
Location: Italy
Posts: 179
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
mmmm no... *giggles*

I thinked to prepare the database before to activate it
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 09:14 AM.

Contact Us - Archive - Top

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.03592 seconds
  • Memory Usage 2,219KB
  • Queries Executed 16 (?)
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
  • (3)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (5)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (3)postbit_onlinestatus
  • (3)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete