Some basic questions to sphinx

1. I installed sphinx and I could see the search results.
   
2. After some days I noticed that the vbulletin database table "vbsphinxsearch_queue" had thousands of entries.
   
3. I was unsure if that was right and looked at the cronjobs. They were looking right.
   
4. I then just run the every-10-minutes-cronjob /usr/local/sphinx/cron/delta.sh That took more than one hour and this time my life board went offline.
   
5. As I could not take my board offline as I could not even get to forum.com/admincp, I shut down the /usr/local/sphinx/cron/delta.sh job while it was running by hitting STRG+C.
   
6. My forum works good after that, also the sphinx search.
   
7. But I can not execute /usr/local/sphinx/cron/delta.sh again, then I always get this error message:
   
   

   (...)
   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
   
   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
   (...)

The forum runs now with the usual vbulletin search engine, but I'd like to know how I can setup sphinx search again

[CarlitoBrigante]

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

[ThorstenA]

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

[CarlitoBrigante]

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]

I am having this issue as well.

[CarlitoBrigante]

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]

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]

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]

Originally Posted by vauge

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.

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

[vauge]

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

#!/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]

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?