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.

Assessment

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

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.

Description

bug command:search-replace state:unconfirmed

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 [...]

Dominant language
Gherkin
Stars
61
Forks
47
Avg merge
8m
Merged PRs (30d)
1

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.

More from wp-cli/search-replace-command

All issues in wp-cli/search-replace-command

Similar issues

More CLI issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.