Page 1 of 1

Command line tool for reindexing large boards?

Posted: Sat Aug 15, 2015 7:42 pm
by Charles L. Cotton
I upgraded/migrated from 3.0.12 to 3.1.5. I don't know if there was a problem with the upgrade, but I am having to reindex the board. With almost 1 million posts, this is taking a very long time. My web host said they would run a command line tool to reindex, if phpBB has such a tool.

I searched but can't find one. Is a command line tool available for reindexing?

Thanks,
Chas.

Re: Command line tool for reindexing large boards?

Posted: Sat Aug 15, 2015 9:33 pm
by Sven2157
There is a script called phpbbcli.php, and it is located in the /bin folder. From inside that folder, if you run:

Code: Select all

php phpbbcli.php
It should return something like this:

Code: Select all

phpBB Console version 3.1.5

Usage:
  [options] command [arguments]

Options:
  --help           -h Display this help message.
  --quiet          -q Do not output any message.
  --verbose        -v|vv|vvv Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug.
  --version        -V Display this application version.
  --ansi              Force ANSI output.
  --no-ansi           Disable ANSI output.
  --no-interaction -n Do not ask any interactive question.
  --safe-mode         Run in Safe Mode (without extensions).
  --shell          -s Launch the shell.

Available commands:
  help                           Displays help for a command
  list                           Lists commands
cache
  cache:purge                    Purge the cache
config
  config:delete                  Deletes a configuration option
  config:get                     Gets a configuration option’s value
  config:increment               Increments a configuration option’s value
  config:set                     Sets a configuration option’s value
  config:set-atomic              Sets a configuration option’s value only if the old matches the current value
cron
  cron:list                      Prints a list of ready and unready cron jobs.
  cron:run                       Runs all ready cron tasks.
db
  db:migrate                     Updates the database by applying migrations.
dev
  dev:migration-tips             Finds migrations that are not depended on.
extension
  extension:disable              Disables the specified extension.
  extension:enable               Enables the specified extension.
  extension:purge                Purges the specified extension.
  extension:show                 Lists all extensions in the database and on the filesystem.
fixup
  fixup:recalculate-email-hash   Recalculates the user_email_hash column of the users table.
You should be able to find what you need there.

Running:

Code: Select all

php phpbbcli.php help
And:

Code: Select all

php phpbbcli.php help list
Should reveal several more options, for you.

NOTE: I have the php executable set globally, via the .bashrc EXPORT. You may need to include the full path for this to work. I believe CentOS/RHEL default install is /usr/bin/php. You will have to check with your distro for location, or locating it.

Re: Command line tool for reindexing large boards?

Posted: Sat Aug 15, 2015 10:02 pm
by Oyabun1
Sven2157 wrote:There is a script called phpbbcli.php, and it is located in the /bin folder.
Recreating the search index is not an option for that.

Re: Command line tool for reindexing large boards?

Posted: Sat Aug 15, 2015 10:13 pm
by Charles L. Cotton
Oyabun1 wrote:
Sven2157 wrote:There is a script called phpbbcli.php, and it is located in the /bin folder.
Recreating the search index is not an option for that.
Hi Bill:
I take it from your post that there is no command line tool for creating an index?

Regards,
Chas.

Re: Command line tool for reindexing large boards?

Posted: Sat Aug 15, 2015 10:42 pm
by Oyabun1
Not with standard phpBB.

Re: Command line tool for reindexing large boards?

Posted: Sat Aug 15, 2015 10:59 pm
by Charles L. Cotton
Thanks Bill.

Chas.