Build Search-Index from Commandline

[Andreas]

Just a simple script that might be useful for someone ...

Don't forget to adjust the path before running this!
No longer necessary with new version.

Update 22.04.2010
I've polished the script a bit, it does no longer require to set the path (it will ask you for the path) and output some more status information

Update 26.04.2010
I've added a X % complete status message and changed the code a bit to avoid warnings if readline()-support is not available.

Important Note
fgf
As stated above this Script is unsupported.
Any support requests except for proven bugs will be ignored, please do not waste your or my time writing them.
Thank you :)

[Hornstar]

Thanks, I was wondering how I was going to rebuild mine as I am more then the 1.2 million mark.

That is where people were having problems right?

[MrD]

Hi Andreas,
i got an Error :(
PHP Fatal error: require_once(): Failed opening required '/srv/www/vhosts/domain/httpdocs/vb/search/core.php' (include_path='.:/usr/share/php5:/usr/share/php5/PEAR') in /srv/www/vhosts/domain/httpdocs/searchindex.php on line 33

[Andreas]

That is a standard vBulletin file.
If it is not there your installation is either broken - or you did not adjust the path.

[MrD]

Hi Andreas,
the Permissions are wrong.
the script run´s now to the point that i can entry the elements.
then it goes to the Prompt.

[Andreas]

Strange :)

You can try to comment out the first two lines (error_reporting, ini_set) and see what happens

[MrD]

Hi Andreas
Suchindex neu erstellen
-----------------------
Hinweis: Wenn Sie den Index neu erstellen, sollten Sie den bestehenden vorher l? schen. Suchindex l?schen!
Empty Index [No]: yes

0) Alle
Suchindex w?hlen [All]: all
ID, mit der begonnen werden soll [0]: 0
Anzahl der Elemente, die pro Durchgang verarbeitet werden sollen [10000]: 10000

s15285294:/srv/www/vhosts/domain/httpdocs #

thats all

[Andreas]

If you are commenting out the first two lines you should get at least one warning (unless your CLI php is configured to not display erors which would be a pretty unusal setup)

[MrD]

Hi Andreas,
i got a New error.
I put error Reporting on and now i become follow output.

PHP Notice: Use of undefined constant DIR - assumed 'DIR' in /srv/www/vhosts/domain/httpdocs/includes/class_core.php on line 4493

Notice: Use of undefined constant DIR - assumed 'DIR' in /srv/www/vhosts/domain/httpdocs/includes/class_core.php on line 4493
PHP Notice: Use of undefined constant DIR - assumed 'DIR' in /srv/www/vhosts/domain/httpdocs/includes/class_core.php on line 4494

Notice: Use of undefined constant DIR - assumed 'DIR' in /srv/www/vhosts/domain/httpdocs/includes/class_core.php on line 4494
<br /><strong>Warnung</strong>: parse_url(http:///searchindex.php): Unable to parse URL in <strong>/srv/www/vhosts/domain/httpdocs/includes/class_core.php</strong> (Zeile <strong>2017</strong>)<br />Suchindex neu erstellen


I think ther error is at the http:///

[Andreas]

At least there are some notices now ;)

Did you set the path correctly?

[MrD]

Hi Andreas,
yes the Path is set correctly

/srv/www/vhosts/domain/httpdocs

i think it´s the relativ path

[Andreas]

I've polished the script a bit, it does no longer require to set the path (it will ask you for the path) and output some more status information

[sKippah]

Could u give more explaintation? What is it, what is it doing?? Sry but i dont get it in anyway.

[spoky29]

screenshot please,but thanks anyway :)

[Andreas]

@sKippah, spoky29
No screenshots, no explanation - sorry.
If you do not know what this script is being used for you do not need it anyway.

[Manoel J?nior]

Hello Andreas, can better explain what this script do?

Thank you.

[Andreas]

@Manoel J?nior
This post contains the answer to your question:
https://vborg.vbsupport.ru/showpost.php?p=2025431&postcount=15

[Manoel J?nior]

@Andreas
Thank you for your education!
As always AN EXAMPLE.

--:

#!/usr/local/bin/php -q Please enter the path to your vBulletin directory:
Warning: fgets() expects parameter 1 to be resource, string given in /iG/dominios/XXXX/htdocs/forum/searchindex.php on line 11

[Andreas]

Another little update: It does show "X % complete" now for each loop and should also fix the warning (thanks for the bug report).

[clubplanet]

Thanks! This is just what I needed after an upgrade to vBulletin 4.

[Vogelfreund]

Thanks for the script... you did a great work..

Just rebuilding.. 1,8 million posts..

IDs 0-10000 ... Erledigt (269,63 sec - 0,45%)
IDs 10000-20000 ... Erledigt (204,11 sec - 0,89%)
IDs 20000-30000 ... Erledigt (200,77 sec - 1,34%)
IDs 30000-40000 ... Erledigt (230,40 sec - 1,78%)
IDs 40000-50000 ...

[Fungsten]

Andreas,

How do you use this script? My Search Index has to be rebuilt: the ACP won't do it.

[life is boost]

Will this script work on 4.1.0? our forum has over 4 million entry's, i tried this on our development server and after it ran i got this error when searching.

MySQL Error : Can't find FULLTEXT index matching the column list

i had to drop my searchcore_text table and rebuild the table for search to work again.