Category: MySQL
-
Post Views: 14 1. In the previous release interface, only one channel is supported for a release. Therefore, the release of the three channels needs to call the interface (APP, Netease account, Weibo) 3 times respectively, as shown in Figure 1 2. On the current release interface, it is ready to publish at one time and can be published on…
-
Post Views: 14 1. When the data length of PA_LOG is: 6.16 GB, as shown in Figure 1 2. Get the first page of the log list, the response time is about 1000ms, which is acceptable, as shown in Figure 2 3. Get the last page of the log list, the response timeout: 504 gateway time-out, as shown in Figure…
-
Post Views: 18 1. The article involving the 1st table, the Penguin number: cpa_qq_article, the field needs to be verified: the uniqueness of the title, the structure of the table is shown in Figure 1 2. The task of the application of the channel involved in the second table, the application task of the channel: CPA_CHANNEL_APP_TASK, field: task_id and the…
-
Post Views: 60 1. In Navicat for MySQL, when editing the database, the database name cannot be edited, as shown in Figure 1 2. Rename the database in phpmyadmin, it can be seen that phpmyadmin can support the operation of direct rename, as shown in Figure 2 3. Prepare to rename g-s-yii2-app-advanced-test in Navicat for mysql, and create a new…
-
Post Views: 17 1. When the environment of the application running is the development environment, that is, when the value of yii_env is dev, close the schema cache and edit environments/dev/common/config/main-local.php 2. When the application running environment is the production environment, that is, when the value of yii_env is prod, turn on the schema cache, edit environments/dev/common/config/main-local.php 3. After enabling…
-
Post Views: 17 1. Get the task list of the application of the Penguin, the list is empty, as shown in Figure 1 2. Types of published articles: standard (normal, graphic) articles, successful publishing (that is, the storage is successful), check the sql statement of the publishing task, as shown in Figure 2 3. Get the task list of the…
-
Post Views: 14 1. Perform database migration in Yii 2.0: the MediumText type of MySQL. The four text types are TinyText, Text, MediumText, and LongText. Only supported: text 2. Reference file: \vendor\yiisoft\yii2\db\schemabuildertrait.php, copy to \console\db\mysql\schemabuildertrait.php, refer to the implementation of the text type, add support for tinytext, mediumtext, and longtext 3. In the database migration file, refer to the newly…
-
Post Views: 19 1. Enter the CentOS server based on Xshell 6, compress and package the website program directory, execute the compression command, and the execution result is shown in Figure 1 2. Connect to the FTP server based on FlashFXP, download the compressed package: shuijingwanwq.com-20191203.zip to the local, as shown in Figure 2 3. Connect to the MySQL server…