Command line tool for reindexing large boards?

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
Charles L. Cotton
Registered User
Posts: 76
Joined: Sat Aug 13, 2005 4:15 pm
Contact:

Command line tool for reindexing large boards?

Post 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.

User avatar
Sven2157
Registered User
Posts: 48
Joined: Thu Jun 25, 2015 5:13 pm

Re: Command line tool for reindexing large boards?

Post 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.
Regards,

Sven2157

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Command line tool for reindexing large boards?

Post 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.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests

Charles L. Cotton
Registered User
Posts: 76
Joined: Sat Aug 13, 2005 4:15 pm
Contact:

Re: Command line tool for reindexing large boards?

Post 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.

User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Command line tool for reindexing large boards?

Post by Oyabun1 »

Not with standard phpBB.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests


Locked

Return to “[3.1.x] Support Forum”