How can I batch delete all unattached images with WP-CLI or other automated process?

You can try this (untested) modification to the answer you linked to by @something wp post delete $(wp post list –post_type=”attachment” –format=ids –post_parent=0) to delete attachments without parents. To target a given mime type, e.g. image/jpeg try: wp post delete $(wp post list –post_type=”attachment” \ –format=ids –post_parent=0 –post_mime_type=”image/jpeg”) Notes: Remember to backup first before testing! … Read more

How to change user_login with wp-cli?

Not allowed by design: If we try to change the user login by the email: wp user update [email protected] –user_login=mary_new or by the user id: wp user update 123 –user_login=mary_new we get the following warning: User logins can’t be changed. This is the reason: if ( isset( $assoc_args[‘user_login’] ) ) { WP_CLI::warning( “User logins can’t … Read more

wp-cli 0.14.1 MySQL error

It seems like Cygwin doesn’t support inline environment variables, like Bash does. Opened a ticket: https://github.com/wp-cli/wp-cli/issues/1086

Using wp-cli can I not query pages by their title?

If we restrict us to the output of wp post list, then here’s a way to search for %test% within the post titles of published posts: wp post list –ignore_sticky_posts=1 –post__in=$(wp db query ‘SELECT ID FROM wp_posts WHERE post_title LIKE “%test%” AND post_status=”publish” AND post_type=”post”‘ –skip-column-names | paste -s -d ‘,’ – ) Here’s the … Read more

WP-CLI – Selecting PHP version

Got the same problem! Just switch the php version. On my server PHP5.6 was default for apache, while CLI was configured with PHP7.1. After installing WP-CLI, with wp –info I got this result: PHP binary: /usr/bin/php7.1 PHP version: 7.1.5-1+deb.sury.org~xenial+1 php.ini used: /etc/php/7.1/cli/php.ini WP-CLI root dir: phar://wp-cli.phar And when i used the wp core install command … Read more

wp-cli Enabling Maintainance Mode

WP-CLI now has native commands for it. # Activate Maintenance mode $ wp maintenance-mode activate # Deactivate Maintenance mode $ wp maintenance-mode deactivate See wp-cli/maintenance-mode-command for more information.