Year: 2021
-
Post Views: 15 1. HTTP requests a static TXT file, the first response is 304, and the second time is 200. as shown in Figure 1 2. Reference URL:https://developer.mozilla.org/zh-CN/docs/Web/HTTP/Status/304. HTTP 304 does not change the content of the request that does not need to be transferred again, that is, the content of the cache can be used. This is usually…
-
Post Views: 14 1. Mysql error: 1055 – expression #2 of select list is not in group by clause and contains nonaggregated columnmodel.group_idwhich is not functionally depend on columns in group by cluse; as shown in Figure 1 2. Execute the first SQL clause, no error is reported, and the query result is empty. as shown in Figure 2 3.…
-
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: 14 1. Reference URL:https://blog.csdn.net/zhanghan18333611647/article/details/81434786. Implemented through the program (Python version 2.x ). Create a new migrate.py file. 2. On the self-built Redis machine, connect the self-built Redis and Tencent Cloud come with Redis. Tencent Cloud’s own redis database 0 is empty. It is planned to use this database as the migration target. as shown in Figure 1 3.…
-
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.…