Tag Archives: pride

[Solved] pip Fatal error in launcher: Unable to create process using

Problem scenario

When we moved the python folder, the system’s global variables are still the original python path, at this time in cmd, type python, the system will follow the previous path to find python.exe, pip.exe. so you need to modify the global variables. But many friends then modify the global variables, although python is available, but pip still can not be used, will report the error pip Fatal error in launcher: Unable to create process using {original pip path} {now pip path}.

Problem analysis

This is because pip is actually python code, pip inside the python interpreter path or the original path is not updated, modify the system global variables and will not affect the python path in the pip.exe file.

Problem-solving:

The brute force solution is to directly modify the python path inside pip.exe. Note that pip.exe is a binary file and cannot be modified directly.

1. Download and open binary software (WinHex, hedit)

2. Modify and save the file

Modify and save directly on the right

How to Solve Pycharm SQL Union Error

Question

Today, when writing MySQL code in pycharm, I always encounter errors when using Union. Although the syntax itself is correct, the red horizontal line is annoying

It’s just that you have to change union to union all to eliminate the error report.

Press setting -> editor-> Inspections, then find no data sources configured under the SQL on the right, and cancel all related to the red exclamation mark, but it is still fruitless.

However, inspired by the article, the reason for the problem is found in the location of the configuration database

Solution:

The configuration database is in file -> Settings -> Languages & Frameworks -> SQL conversations
the reason for the problem is that I configured the database before. At that time, Clickhouse was configured, which is different from MySQL in the usage of union,
so just change Clickhouse to MySQL.

before change

modified

This will return to normal~

[How to Solve] Reason: Incompatible library version

Today’s respondent reported the following errors when testing the PIL package in Python:

Reason: Incompatible library version: _imaging.cpython-37m-darwin.so requires version 14.0.0 or later, but libjpeg.9.dylib provides version 12.0.0

By analyzing the error message, we can see that it is caused by the version incompatibility between libraries, because the PIL library is old and only supports python2.7, which may lead to this problem. So we think about how to solve it.

Solution

First, consider reloading the library. The basic environment of this environment is Python 3.7. Therefore, enter the code on the command line, delete the library first, and then reinstall it.

conda uninstall pillow
conda install pillow

Finally, the test re imports the library successfully and outputs the size of the picture

Successfully solve the problem!