Category: Database Management Tools
-
Post Views: 21 1. Reference URL:https://www.shuijingwanwq.com/2021/12/29/5622/, Laravel 8.x is deployed to Heroku, based on PostgreSQL implementation. Therefore, some steps can be omitted. 2. In the local development environment, the Laravel native environment has been deployed. Open URL:http://larabbs.local/, the response 200. as shown in Figure 1 3. Verify your installation, to verify your CLI installation, use the heroku –version command. Current…
-
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: 14 1. The external network address of the Alibaba Cloud RDS MySQL instance has been applied to connect. as shown in Figure 1 2. Failed to connect in Navicat for MySQL, error: 2003 – CANT connect to mysql server onRM-BP(10060 “Unknown Error”). as shown in Figure 2 3. To access RDS through the external network, you need to…
-
Post Views: 12 1. In Yii 2.0, the active record of Redis (Active Record) is based on the view structure, which is inconsistent with the order of the model fields. as shown in Figure 1 2. Check the Redis activity record class, /common/models/redis/douyinwebappUserAccessToken.php 3. Print the model object of redis (before the update), $redisdouyinWebAppUserAccessToken. 4. Print the model object of…
-
Post Views: 20 1. At this stage, there is a new requirement, and it is necessary to do some initial data work for the product when deploying the product. Prepare the corresponding SQL file in advance. Since multiple SQL statements need to be executed, and subsequent SQL statements depend on the primary key ID generated by the previous SQL statement.…
-
Post Views: 13 1. The request interface, the total number of resources in the response parameters is 30. Resources containing ids equal to 37918 are duplicates. A total of 2. as shown in Figure 1 2. Check the model class, /common/models/redis/cmc_console/user.php 3. Check /common/components/redis/activerecord.php , which defines the prefix and applies to all AR keys. 4. Open RedisDesktopManager, check 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: 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…
-
Post Views: 18 1. Open the task configuration table, as shown in Figure 1 2. Open the task step configuration table, as shown in Figure 2 3. Now there are new requirements: Based on different tenants, the task configuration and task step configuration can be customized. Therefore, it is decided to create a new tenant’s task configuration table and tenant’s…
-
Post Views: 15 1. In the console command of Yii 2.0, an error is reported: yii\db\exception: redis error: err Invalid DB index Redis command was: Select 29 in /vendor/yiisoft/yii2-redis/src/connection.php:736, view /console/runtime/logs/app.log 2. The analysis found that when executing the command: Select 29, switch to the corresponding database: 29 errors, and a Redis instance has 16 databases by default, from 0…