WP CLI: environment variables not set

[fbertram]

Quick summary

I want to use WP CLI on Windows. When I open a shell by clicking Studio's 'Terminal' button, the environment variables needed to run WP CLI are not set correctly.

Steps to reproduce

1. Start the Studio App on Windows
2. Start an existing WordPress project
3. Click on the 'Open in Terminal' button to open a shell
4. enter a command, e.g., wp user list

What you expected to happen

WP CLI should launch and execute the desired command

What actually happened

because PATH is not set correctly, the wp command is not found. Also, in order to successfully execute C:\Users\[username]\AppData\Local\studio\app-1.0.5\resources\bin\wp.bat, the variable STUDIO_APP_PATH must be set.

Impact

Some (< 50%)

Available workarounds?

Yes, easy to implement

Platform

Windows

Logs or notes

A possible workaround is to:

• set STUDIO_APP_PATH to C:\Users\[username]\AppData\Local\studio\app-1.0.5\Studio.exe
• set PATH to include C:\Users\[username]\AppData\Local\studio\app-1.0.5\resources\bin

[mrfoxtalbot]

I am on Mac, I will let you triage this one, @wojtekn

[peterschimke]

I am a mac user as well. @wojtekn were you able to take a look at this?

[wojtekn]

@mrfoxtalbot @peterbutler I validated and confirmed this issue:

1. Install PHP for Windows CLI using instructions
2. Install WP CLI using instructions
3. Open Terminal from Studio
4. Run wp command
5. See the error

When I open a new terminal tab and run the wp command again, it works correctly:

[t-hamano]

This may not be directly related to the problem reported here, but I had a problem when trying to get WP-CLI to work in Studio. Here's how I solved it, but I hope it helps someone.

PHP and WP-CLI already work on Windows OS:

wp --info
OS:     Windows NT 10.0 build 22631 (Windows 11) AMD64
Shell:  C:\Windows\system32\cmd.exe
PHP binary:     C:\php\php-8.3.14-Win32-vs16-x64\php.exe
PHP version:    8.3.14
php.ini used:   C:\php\php-8.3.14-Win32-vs16-x64\php.ini
MySQL binary:
MySQL version:
SQL modes:
WP-CLI root dir:        phar://wp-cli.phar/vendor/wp-cli/wp-cli
WP-CLI vendor dir:      phar://wp-cli.phar/vendor
WP_CLI phar path:       C:\Users\{username}\Studio\my-wordpress-website
WP-CLI packages dir:
WP-CLI cache dir:       C:\Users\{username}/.wp-cli/cache
WP-CLI global config:
WP-CLI project config:
WP-CLI version: 2.11.0

When I opened the terminal from the Studio app and ran wp user list, the following error occurred:

wp user list
Error: PDO Driver for SQLite is missing. Your PHP installation appears not to have the right PDO drivers loaded. These are required for this version of WordPress and the type of database you have specified.

So I edited php.ini and enabled the following two lines:

extension=pdo_sqlite
extension=sqlite3

By doing this, WP-CLi worked in Studio:

wp user list
+----+------------+--------------+---------------------+---------------------+-----------------------------+
| ID | user_login | display_name | user_email          | user_registered     | roles                       |
+----+------------+--------------+---------------------+---------------------+-----------------------------+
| 1  | admin      | admin        | [email protected] | 2024-11-09 07:20:34 | administrator,bbp_keymaster |
+----+------------+--------------+---------------------+---------------------+-----------------------------+