永夜

没有不值得去解决的问题，也没有不值得去学习的技术！

永夜 Blog

表：pub_log 中的字段：data 的数据结构为：json，格式化后的数据如下 0

Database / Programming Language / MySQL / PHP / SQL / Yii / MySQL 5.6 / MySQL 5.7 / PHP 7.2 / Yii 2 / Web Application Development

In Yii 2.0, modify a column of data in the MySQL 5.6 database (type: text, the data structure is: json) in the value of a field (that is, to search and replace some text in the field), based on one Implementation of SQL

浏览量： 1 1. Table: Fields in pub_log: The type of data is: text, as shown in Figure 1 2. Table: field in pub_log: data structure of data is: json, the formatted data is as...

执行数据库迁移命令 0

Yii / MySQL 5.7 / PHP 7.2 / Yii 2 / Web Application Development / Database / Programming Language / MySQL / PHP / SQL

In Yii 2.0, migrate a column of data in the A table in the MySQL database to a column of data in the B table, based on the implementation of a SQL

浏览量： 2 1. Reference URL:https://www.shuijingwanwq.com/2019/08/15/3427/ 2. Update table: field in channel_app_source: The value of Permission is: 3, as shown in Figure 1 3. Based on the database migration command, generate the implementation of a...

在 Yii 2.0 中报错：Calling unknown method yii2techarsoftdeleteSoftDeleteBehaviorisTransactional() 0

Yii / Redis 3.0 / PHP 7.2 / Yii 2 / Web Application Development / Server / Programming Language / Web Framework / Redis / Cache Server / PHP

Error in Yii 2.0: Calling unknown method Yii2tech\ar\softdelete\\softdeleteBehavior::IsTransactional() analysis solution

浏览量： 0 1. Error in Yii 2.0: Calling unknown method yii2tech\\ar\\softdelete\\softdeleteBehavior::IsTransactional(), as shown in Figure 1 2. Check the code, because the operation of the Redis model uses soft delete (SoftDelete) 3. Edit the...

在 Rancher 中升级容器，报错：/config/init/config0.sh: line 1314: syntax error near unexpected token `}' 0

Rancher / PhpStorm 2019 / Rancher 1.6.18 / Development Tools / Server / Programming Language / IDE / Cloud Server / Shell / PhpStorm

Upgrade the container in Rancher, error: /config/init/config0.sh: line 1314: syntax error near unexpected token `}analysis solution

浏览量： 0 1. Upgrade the container in Rancher and report an error: /config/init/config0.sh: line 1314: syntax error near unexpected token `}, as shown in Figure 1 2. In phpstorm, edit /config/init/config0.sh, prompt: expected a...

现有新的需求，需要支持字段：user_nick 的模糊查询，但是字段：user_nick 不存在于 MySQL ActiveRecord 中，而是存在于 Redis ActiveRecord 中。且 Redis ActiveRecord 不支持 like 操作符。 0

Yii / MySQL 5.7 / Redis 2.8 / Redis 3.0 / Yii 2 / Web Application Development / Database / Web Framework / MySQL / Redis / Cache Server

In Yii 2.0, you need to query resources based on MySQL ActiveRecord and Redis ActiveRecord

浏览量： 2 1. In Postman, open the URL:http://api.pcs-api.localhost/v1/plan-config-column-users?login_id=2e368664c41b8bf511bcc9c65d86dbc3&login_tid=685f805f71faedfe215f55bbb01b50c6&filter[config_column_id]=1 , only the fields are supported: config_column_id queries, the response is as follows: 2. The SQL statement is as follows: 3. Existing new requirements need to...

在 第 10 步骤执行完毕后，Docker 容器的 CPU：9.9%，内存：541MB，内存增加了 160MB 左右，每 1000 条数据的添加，内存会增加 20 MB 左右。因此，优化的重点在于第 2 个命令行脚本。 0

PaaS / Docker / Cloud Vendors / Tencent Cloud / Linux / CentOS / Web Application Development / Windows / Windows 10 / Cloud Computing / MySQL / MySQL 5.6 / Operating System / Redis / Redis 2.8 / Database / Cache Server / PHP 7.2 / Server / Supervisor / Yii 2 / Management And Monitoring / PHP / Tencent Cloud Redis / Programming Language / Shell / CentOS 7 / Web Framework / Yii / Windows 10 Home Chinese Edition

The command-line script implemented based on Yii 2.0, during the continuous operation, the analysis and solution of excessive memory occupancy

浏览量： 1 1. When the amount of data in MySQL and Redis is small, the CPU of the Docker container: 0.02%, and the memory: 298MB, as shown in Figure 1 and Figure 2 2....

Docker 部署，在 Jenkins 上构建镜像时，报错：composer install returned a non-zero code: 255 0

PHP Development Tools / CentOS 7 / Continuous Integration System / Linux / PHP / Docker / Composer / Development Tools / Jenkins / Operating System / CentOS / Server / PHP 7.2 / Programming Language / Composer 1 / PaaS / Jenkins 2

Docker deployment, modify the directory sobey to mcloud, when building the image, an error is reported: Composer install returned a non-zero code: 255 analysis solution

浏览量： 1 1. Docker deployment, when building an image on Jenkins, an error is reported: composer install returned a non-zero code: 255, as shown in Figure 1 2. The code for the failure of...

查看 \vendor\yiisoft\yii2\i18n\I18N.php，文件映射的类别名：yii、app，始终定义类别 yii 和 app 。前者指的是 Yii 核心中使用的消息框架代码，而后者是指自定义应用程序代码的默认消息类别。其判断类别：app 是否存在，如果不存在，则覆盖，但是，其判断的层级仅为第一级，没有深入至更深的层级，因此，自定义的类别：app 会被覆盖 0

Programming Language / Web Framework / Program Debugging Tools / PHP / Yii / Postman / PHP 7.2 / Yii 2 / Postman v6 / Web Application Development / Development Tools

Yii 2 Advanced Project Template, the bug of internationalized messaging service Analysis of @app/messages/en-us/app.php)

浏览量： 1 1. The configuration code of the I18N application components is as follows: 2. Request the interface in Postman, in headers, accept-language:zh-cn, when the target language is Simplified Chinese, and the category name...

现在耗时 18 分钟 0

PHP / Windows 10 Home Chinese Edition / Cloud Computing / Docker / Development Tools / Alibaba Cloud / Operating System / Composer / Server / Jenkins / Programming Language / CentOS / PaaS / Windows 10 / PHP Development Tools / PHP 7.2 / Continuous Integration System / Composer 1 / Linux / Jenkins 2 / Windows / CentOS 7

Enable Alibaba Cloud Composer Full Image in the Global Configuration in a Windows 10/Docker deployment

浏览量： 2 1. Check the list of global configuration options for Composer. Open the command line window and execute the following command: the image address is the official source address. as shown in Figure...