Category: Web Framework
-
Post Views: 15 1. Request parameter: filter[and][0][or][0][title][like]=\, the generated sql is as follows, the search result is empty. as shown in Figure 1 2. Check the value of the field title in the table plan, one of the records exists \. In theory, it is possible to query a record. as shown in Figure 2 3. Execute SQL in Navicat…
-
Post Views: 16 1. Interface response to SQL error: SQLSTATE[42000]: Syntax error or access Violation: 1064 you have an error in your SQL syntax; check the manual that Corresponds to your MySQL Server version for the right syntax to use near6. as shown in Figure 1 2. Remove the request parameter: filter[and][0][or][1][keyword][fis]=, the response is 200, and no error is…
-
Post Views: 19 1. When the container is upgraded for the first time in Rancher, the database migration will be repeated, and then the error will be reported to the upgrade failure. as shown in Figure 1 2. It has been determined that the database structure has not been manually modified. Analyze the health check of the container. Periodically make…
-
Post Views: 17 1. Migrate data from the CSP database to the Cloud database. `channel-pub-api-csp`.`cpa_channel_app_source`. Query 95 records. as shown in Figure 1 2. `channel-pub-api-cloud`.`cpa_channel_app_source`. A total of 158 records were queried. as shown in Figure 2 3. Migrate data from the CSP database to the Cloud database. Field value changes: id, insert `channel-pub-api-cloud`.`cpa_channel_app_source`. Edit command line scripts. /console/controllers/migrate20210425controller.php 4.…
-
Post Views: 15 1. Modify the multi-domain name mode to a single domain name mode, and modify the file: frontend/config/main.php. as shown in Figure 1 2. Modify the multi-domain name mode to single-domain name mode, and modify the file: etc/nginx/conf.d/ccp_api.conf. as shown in Figure 2 3. Now plan to upgrade the container based on the environment variable: channel_pub_api_cfg_frontend_domain_mode=single|multiple. Default: single.…
-
Post Views: 16 1. Reference URL:https://www.shuijingwanwq.com/en/2021/04/15/10238/. Updating Yii 2 to the latest version based on Composer, upgrade the Yii Framework from version 2.0.35 to 2.0.41.1. ./yii has no output. as shown in Figure 1 2. ./yii has the normal output of output. as shown in Figure 2 3. Edit the ./yii file, there is an output: 0. as shown in…
-
Post Views: 53 1. Composer has been installed before, to ensure the latest version is used. You can update Composer to version 2.0.12 by running composer self-update, as shown in Figure 1 2. Updating Yii 2 to the latest version by running Composer Update, the Yii Framework has been upgraded from version 2.0.35 to 2.0.41.1, as shown in Figure 2…