vb.org Archive - Some basic questions to sphinx

Page 2 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Sphinx (https://vborg.vbsupport.ru/forumdisplay.php?f=265)

- - Some basic questions to sphinx (https://vborg.vbsupport.ru/showthread.php?t=241739)

CarlitoBrigante

05-05-2010 07:46 PM

Gotcha, just trying to find a pattern in why this is happening. But the culprit seems to be the MySQL query.

ThorstenA

05-05-2010 08:05 PM

I imported from phpbb a long time ago, maybe its because of that?

CarlitoBrigante

05-05-2010 08:11 PM

No, once you imported into vBulletin, that makes no difference.

I would be interested in knowing how many people are having this problems vs those who are running Sphinx on vB4 without problems.

vauge

05-28-2010 12:17 PM

I am having this issue as well.

CarlitoBrigante

05-28-2010 01:57 PM

There is obviously something horribly wrong, but I would need to know if ALL websites with a significant amount of posts has this issue. Please guys/gals: if you have this problem, write here and post all details about your setup, including:

- PHP version
- MySQL version
- Web server

And, if possible, the host. I am seeing this happening in a host service that is very common among vB users.

vauge

05-28-2010 02:51 PM

PHP Version 5.2.9
Mysql 5.0.90
Apache 2.0

Using CPanel.
=======
root@server [/usr/local/sphinx/cron]# ./delta_norotate.sh
Sphinx 0.9.8-id64-release (r1371)
Copyright (c) 2001-2008, Andrew Aksyonoff

using config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'...
ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.
ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.
FATAL: failed to parse config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'.
Sphinx 0.9.8-id64-release (r1371)
Copyright (c) 2001-2008, Andrew Aksyonoff
==

Please help, really do not want to spend 8 hours reindexing for the default search.

CarlitoBrigante

05-28-2010 07:43 PM

Vauge, your error is caused by the php path on top of vbulletin-sphinx.php file. If you are unsure about your php path, you can ask your host or check with the "which" command via linux.

The most serious error is the one being caused during cronjobs, so far we were unable to pinpoint an obvious cause. It seems that some of those having the problem are using RAID; I would like to know if others have a similar configuration as well.

By the way, terrific forum.

pete_brady

05-28-2010 09:46 PM

Quote:

Originally Posted by vauge (Post 2044654)

https://vborg.vbsupport.ru/showpost....96&postcount=6

vauge

05-28-2010 10:52 PM

This is very strange, which was the first thing I ran.

root@server [/usr/local/sphinx/cron]# which php
/usr/local/bin/php

root@server [/usr/local/sphinx/cron]# head ../etc/vbulletin-sphinx.php

Code:

#!/usr/local/bin/php

<?php



/*

Set $myforumroot to the absolute path to your forum directory.

Example:

$myforumroot = '/home/username/public_html';

*/

$myforumroot = '/home/USERNAME/public_html'; //<-- changed this one

--------------- Added [DATE]1275091134[/DATE] at [TIME]1275091134[/TIME] ---------------

More craziness, if I change it to "/usr/bin/php" - I get the following...

root@server [/usr/local/sphinx/cron]# ./delta_norotate.sh

using config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'...
ERROR: invalid section type 'X-Powered-By' in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 13.
ERROR: invalid section type 'X-Powered-By' in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.
FATAL: failed to parse config file '/usr/local/sphinx/etc/vbulletin-sphinx.php'.
Sphinx 0.9.8-id64-release (r1371)
Copyright (c) 2001-2008, Andrew Aksyonoff

sybakaos

06-11-2010 10:18 PM

I'm trying to install sphinx but I'm experiencing the following error as some other people did previously as well.

ERROR: invalid token in /usr/local/sphinx/etc/vbulletin-sphinx.php line 1 col 1.

I've tried all available PHP paths and I did refer to the correct $myforumpath... I have even reconfigured PHP using suexec, dso etc. Any ideas on how to solve this or perhaps there's an alternative?

All times are GMT. The time now is 02:16 PM.

Page 2 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01929 seconds Memory Usage 1,741KB 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_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (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
Messages: