update index questions

[tribedude]

1. If i open up my admin CP and then select update search index and then close my browser or log out is it still updating the seach index?

2. We have a large board (3 million posts). We have a separate database server that is a lot faster than our web server. It seems that the web server is the slow part of this update operation as the process keeps feeding back the status of the operation every 250 posts to the user CP. Is there a way to update the search indexes without using the admin CP interface - by doing it right from our database?

3. If the process is interupted and I restart, does it start from the begining, or from where it left off?

It is taking for evar

[Steve Machol]

1. Yes, it should.

2. You could try using the searchshell.php script that is available in the 'do_not_upload' folder of the zip file. To run searchshell.php, upload it to your forums directory, login with telnet or SSH, then run this at the command line:

php searchshell.php

3. It starts from the beginning unless you specify a beginning Post ID.

[tribedude]

Well I have done this but when I type:

php searchshell.php

it asks me the path of my includes directory. when I respond with the path it reponds with:

"is an invalid directory, please re-enter"


the directory exists but it won't recognize it for some reason...

[tribedude]

never mind, i have it figured out now...

[Steve Machol]

Are you using the full and exact path to this directory?

[tribedude]

now i am getting these timeouts when i run it:

PHP Fatal error: Maximum execution time of 30 seconds exceeded in....functions_databuild.php on line 1080

and it hangs.

it will process about 1000 posts and it hangs. I have tried setting the "Posts to process per cycle? (100000)" to lower nimbers to no avail. It seems to stop after about 30 seconds and that is that...

[tribedude]

I have run it a few times and it always stops after 30 seconds. Sometimes it processes a few more posts but not many more, usually around a 1000. I have 3 million to index!

[Steve Machol]

You PHP is timing out. Either use smaller batches or ask your host to increase the max_execution_time setting in php.ini. I recommend setting this to '120' instead of '30'.

[DJ RRebel]

Are you using the full and exact path to this directory?

Steve ... I'm getting the following via putty .. (note that I 'cd' to the forum's main directory where the script is before running it) :

-bash-3.00$ php searchshell.php
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/modules/pgsql.so' - libpq.so.4: cannot open shared object file: No such file or directory in Unknown on line 0
Welcome to vB3 search re-indexer
What is the full path to your main forum directory?

Please delete any parts of the above code if it comprimises my site's security in any way


I'm quite new to Putty and SSH and all that .. can you please tell me the format to enter the directory path. Is it simply the following?

/httpdocs/PathToMainVbDirectory/

Thanks

[Steve Machol]

On Unix/Linux systems you can find the complete path name by telnetting or sshing into your server, going to that directory and typing:

pwd