永夜

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

永夜 Blog

现在的需求如下，需要基于文章发布的时间范围，筛选基于文章发布数量的帐号排行。 0

Database / MySQL / MySQL 5.7 / PHP / PHP 7.4 / Programming Language / SQL / Web Application Development / Web Framework / Yii / Yii 2 / Yii2 Database Migration

In Yii 2.0, when connecting two tables, specify some additional conditions in the ON section of the join query, based on the implementation of the ActiveDataFilter query filter

浏览量： 1 1. The current requirements are as follows. Based on the time range of article publishing, it is necessary to filter account rankings based on the number of articles published. as shown in...

GET http://api.channel-pub-api.localhost/v1/channel-app-tasks?group_id=c10e87f39873512a16727e17f57456a5&filter[and][0][or][0][baijia_article_type_code]=video&filter[and][0][or][1][customize_article_type_code]=video&filter[and][0][or][2][douyin_article_type_code]=video&filter[and][0][or][3][netease_article_type_code]=video&filter[and][0][or][4][qq_article_type_code]=video&filter[and][0][or][5][weibo_article_type_code]=video&filter[and][0][or][6][wx_article_type_code]=video 。响应数据。 0

SQL / Yii / MySQL 5.7 / PHP 7.4 / Yii 2 / Web Application Development / Yii2 Data Filter / Database / Programming Language / Web Framework / MySQL / PHP

In Yii 2.0, when there are multiple associations in the table structure (the same associated field exists in multiple tables), the implementation of query filtering based on ActiveDataFilter

浏览量： 2 1. Main table: CPA_CHANNEL_APP_TASK and Schedule: CPA_Task: many-to-one. as shown in Figure 1 2, table: cpa_task and Table: CPA_baijia_article|cpa_customize_article|cpa_douyin_article|cp a_netease_article|cpa_qq_article|cpa_weibo_article|cpa_wx_article The association relationship: one-on-one. Table: A record in cpa_task will only exist...

在 Rancher 中升级容器时，报错：CHANNEL_PUB_API_CFG_APP_AVATAR_UPLOAD_PATH: unbound variable。 0

Operating System / Rancher 1.6.18 / Server / Programming Language / Linux / Cloud Server / PHP / Shell / CentOS / Rancher / PHP 7.4 / CentOS 7

When upgrading a container in Rancher, an error is reported: channel_pub_api_cfg_app_avatar_upload_path: analysis solution for unbound variable

浏览量： 1 1. When upgrading the container in Rancher, an error is reported: channel_pub_api_cfg_app_avatar_upload_path: unbound variable. as shown in Figure 1 2. View the file: /config/init/config0.sh. 3. Even in Rancher Add environment variables: channel_pub_api_cfg_app_avatar_upload_path_url,...

重新升级后，reserved 状态的队列数量快速变化为 0 ，查看标准输出日志文件，stdout_logfile = /data/logs/yii-copy-asset-queue-worker-stdout.log。attempt 的值分别等于 140、136。 0

Cloud Computing / Redis 3.0 / Database / PHP 7.4 / Management And Monitoring / Yii 2 / Programming Language / Tencent Cloud Redis / Web Framework / Yii2 Queue Extension / Cloud Vendors / Redis / Supervisor / PHP / Yii / Web Application Development / Tencent Cloud

Yii2 queue extension, in the Redis driver, when the info command prints information about the queue status, the analysis of the queued state queue

浏览量： 1 1. Yii2 queue extension, in the Redis driver, when the info command prints information about the queue status, the queue of the reserved state has always existed. Check the system log, there...

sort=-channel_app_task_count 。响应资源列表。查看日志中的 SQL 语句 。符合预期。 0

PHP 7.4 / Yii 2 / Web Application Development / Programming Language / Web Framework / PHP / SQL / Yii

In Yii 2.0, the sorting of alias fields based on the ActiveDataFilter implementation is sorted

浏览量： 1 1. Check the search model file: /common/logics/weiboWeiBoConnectWebAppUsersarch.php. 7. Edit method entry file: /weibo/rests/weibo_weibo_connect_web_app_user/indexaction.php. Implement the search and sorting of the channel_app_task_count. The inclusion of channel_app_task_count is prerequisite for the channel_app_task field status...

查看终端输出，报错：runtime error: invalid memory address or nil pointer dereference。 0

Go / Firebase / Google URL Shortener / Go 1.13 / Website Building System / Programming Language / Short URL Service

Runtime Error: Invalid memory address or nil pointer dereference when using the URL shortener API

浏览量： 61 1. Reference URL: https://github.com/unknwon/the-way-to-go_zh_en/blob/master/ebook/09.11.md . Test by browsing the page of http://localhost:8080/. Enter: http://www.destandaard.be in shorten this, and click: Give me the short URL. Loading until timeout. as shown in Figure 1...