Author: 永夜
-
Post Views: 19 1. Use puttygen to convert the .pem file to .ppk format: open puttygen. Click Load and select the .pem file. Click Save Private Key to save as a .ppk file. as shown in Figure 1 2. Use putty to log in: open putty. In the Connection > ssh > auth, select the .ppk file. as shown in…
-
Post Views: 22 1. In a custom field (location), it needs to be stored as a JSON format. UI design. as shown in Figure 1 2. In the interface design, the request parameter is longitude and latitude. Since the name of the location needs to be displayed in the details interface, the location name needs to be obtained based on…
-
Post Views: 19 1. View the response data in the interface, and the reasoning is that the checkin_location_coordinates in the response field is the point type of mysql. as shown in Figure 1 2. Decide to adjust the query sql, use mysql spatial functions (such as st_x and st_y) to extract the latitude and longitude, and avoid direct manipulation of…
-
Post Views: 21 1. In Yii2, the SQL generated after the validation rule of the existentiality is written is not as expected. as shown in Figure 1 2. Give up the use of TargetRelation, and use TargetClass and TargetAttribute instead. Generating SQL is as expected.
-
Post Views: 16 1. TortoiseGitPlink Fatal Error No Supported Authentication Methods Available (Server Sent: publicKey). as shown in Figure 1 2. I finally decided to replace the address of the remote origin from git@gitee.com:about/xxx.git withhttps://gitee.com/about/xxx.git。如图2 3. Re-execute the pull, when pulling, enter the user name and password respectively: wang-qiang-shui, private token. The pull is successful, no more errors are reported.…
-
Post Views: 17 1. In phpMyAdmin, it prompts: An error was detected, the error report has been generated but failed to send. If you are having problems, please submit vulnerability reports manually. You need to refresh the current page. as shown in Figure 1 2. Because it is downloaded phpmyadmin-5.2.2-all-languages.zip. After decompression, run directly, and decide to refer to: installing…
-
Post Views: 22 1. npm : The file cannot be loaded c:\program files\nodejs\npm.ps1 because the script is prohibited from running on this system. For more information, see about_execution_policies in https:/go.microsoft.com/fwlink/?LinkId=135170. 2. Confirm that the file C:\Program Files\NodeJS\npm.ps1 exists. as shown in Figure 1 3. Enter one of the following commands to change the execution policy, which is permanently changed (valid…
-
Post Views: 21 1. When logging in in phpMyAdmin, prompt: mysqli::real_connect(): The server requested authentication method unknown to the client[caching_sha2_password]. as shown in Figure 1 2. Starting with MySQL 8.0, the default authentication method is changed from MYSQL_Native_password to caching_sha2_password. While this new approach is more secure, older versions of PHP (before 7.4) and some MySQL client libraries do not…