wp-cli / wp-cli/search-replace-command

WordPress database error Unknown column 'Tables_in_' during search-replace

Open
#207 24 comments 3 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug command:search-replace state:unconfirmed
Dominant language
Gherkin
Stars
61
Forks
47
Avg merge
8m
Merged PRs (30d)
1

Description

Hi all,
using version 1.5, in a multisite installs with wp-content in custom location, if i try to launch
wp search-replace something someone
i get this error
WordPress database error Unknown column 'Tables_in_' in 'where clause' for query SHOW TABLES WHERE Tables_in_ IN [...]

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the reported wp search-replace something someone command in a multisite installation with wp-content in a custom location, using the issue's SHOW TABLES error as the symptom to trace. Follow the search-replace command's database table-discovery entry point and verify that the command completes without the Tables_in_ error in that configuration.

Written by the indexing model from the issue text.

Assessment

Tech stack
wordpress
Domain
cli, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.