• Installing michaelbelgium/flarum-discussion-views (v7.1.1)
  • Upgrading askvortsov/flarum-pwa (v3.1.0 => v3.1.1)
  • Upgrading flarum/emoji (v1.1.0 => v1.1.1)
  • Upgrading flarum/mentions (v1.1.1 => v1.1.2)
  • Upgrading fof/byobu (1.0.1 => 1.0.2)
  • Upgrading fof/default-group (1.0.0 => 1.0.1)
  • Upgrading fof/formatting (1.0.1 => 1.0.2)
  • Upgrading fof/gamification (1.2.0 => 1.2.6)
  • Upgrading fof/nightmode (1.0.0 => 1.1.1)
  • Upgrading fof/polls (1.0.3 => 1.0.4)
  • Upgrading fof/profile-image-crop (1.0.0 => 1.0.1)
  • Upgrading fof/upload (1.0.5 => 1.0.7)
  • Upgrading fof/user-bio (1.0.0 => 1.0.1)
  • Upgrading ianm/synopsis (1.0.1 => 1.0.2)
  • Upgrading malago/flarum-achievements (0.5.1 => 0.5.2)
  • Upgrading v17development/flarum-user-badges (v0.2.1 => v1.0.0)
积分: 15

n0099
为了增加由腾讯云cdn返回http415 Unsupported Media Type的概率需要在上传.jpg/png扩展名的webp图片时指定mime type为image/webp
但go写的coscli不支持上传时指定header,只有py2写的coscmd支持
https://cloud.tencent.com/document/product/436/10976#.E4.B8.8A.E4.BC.A0.E6.96.87.E4.BB.B6
n0099 webp兼容性通知中增加了google analytics打点事件(不兼容时上报)

积分: 15
4 天 后
8 天 后

n0099 网易云容易加载失败,y, b和n都没问题

练习忠字舞中,少话

积分: 19
8 天 后

由于网宿cdn断供jsdelivr公共cdn:https://www.v2ex.com/t/823281 https://github.com/jsdelivr/jsdelivr/issues/18348
针对以下扩展将其引用的cdn.jsdelivr.net资源url改成字节跳动公共cdn https://cdn.bytedance.com

./vendor/fof/reactions/js/dist/forum.js
replace
//cdn.jsdelivr.net/gh/twitter/twemoji@13/assets
with
https://lf6-cdn-tos.bytecdntp.com/cdn/expire-1-M/twemoji/13.0.0

// https://github.com/FriendsOfFlarum/polls/pull/48#issuecomment-998683662
./vendor/fof/polls/resources/less/forum.less
replace
@import url("https://cdn.jsdelivr.net/npm/flatpickr@4.6.1/dist/flatpickr.min.css"); 
with
@import url("https://lf9-cdn-tos.bytecdntp.com/cdn/expire-1-M/flatpickr/4.6.1/flatpickr.min.css");

./vendor/flarum/emoji/js/dist/forum.js
replace
"https://cdn.jsdelivr.net/gh/twitter/twemoji@"+/([0-9]+).[0-9]+.[0-9]+/g.exec(p.base)[1]+"/assets/"
with
https://lf6-cdn-tos.bytecdntp.com/cdn/expire-1-M/twemoji/13.0.0/

./vendor/clarkwinkelmann/flarum-ext-emojionearea/js/dist/forum.js
replace
https://cdn.jsdelivr.net/npm/emojionearea@3.4.2/dist/
with
https://lf6-cdn-tos.bytecdntp.com/cdn/expire-1-M/emojionearea/3.4.2/

https://discuss.flarum.org/d/28860-i-want-to-increase-my-site-speed-which-extension-should-i-use/4
https://github.com/FriendsOfFlarum/polls/pull/48#issuecomment-998683662

由于不常用且引用了jsdelivr cdn资源,扩展the-turk/flarum-mathren已被禁用

积分: 15
2 个月 后

安装了扩展the-turk/flarum-stickiest
更新flarum至1.2,更新了以下扩展

  • Upgrading afrux/news-widget (v0.1.0 => v0.1.1)
  • Upgrading clarkwinkelmann/catch-the-fish (1.1.1 => 1.1.2)
  • Upgrading flarum-lang/chinese-simplified (v1.0.4.1009 => v1.1.1.1220)
  • Upgrading flarum/akismet (v1.1.0 => v1.2.0)
  • Upgrading flarum/approval (v1.1.0 => v1.2.0)
  • Upgrading flarum/bbcode (v1.1.0 => v1.2.0)
  • Upgrading flarum/core (v1.1.1 => v1.2.0)
  • Upgrading flarum/emoji (v1.1.1 => v1.2.0)
  • Upgrading flarum/flags (v1.1.0 => v1.2.0)
  • Upgrading flarum/lang-english (v1.1.0 => v1.2.0)
  • Upgrading flarum/likes (v1.1.0 => v1.2.0)
  • Upgrading flarum/lock (v1.1.0 => v1.2.0)
  • Upgrading flarum/markdown (v1.1.0 => v1.2.0)
  • Upgrading flarum/mentions (v1.1.2 => v1.2.0)
  • Upgrading flarum/nicknames (v1.1.0 => v1.2.0)
  • Upgrading flarum/pusher (v1.1.0 => v1.2.0)
  • Upgrading flarum/statistics (v1.1.0 => v1.2.0)
  • Upgrading flarum/sticky (v1.1.0 => v1.2.0)
  • Upgrading flarum/subscriptions (v1.1.0 => v1.2.0)
  • Upgrading flarum/suspend (v1.1.0 => v1.2.0)
  • Upgrading flarum/tags (v1.1.0 => v1.2.0)
  • Upgrading fof/best-answer (1.1.6 => 1.1.8)
  • Upgrading fof/byobu (1.0.2 => 1.1.1)
  • Upgrading fof/follow-tags (1.0.2 => 1.1.1)
  • Upgrading fof/gamification (1.2.6 => 1.3.3)
  • Upgrading fof/masquerade (1.0.0 => 2.1.0)
  • Upgrading fof/merge-discussions (1.0.0 => 1.2.1)
  • Upgrading fof/nightmode (1.1.1 => 1.2.0)
  • Upgrading fof/polls (1.0.4 => 1.0.5)
  • Upgrading fof/reactions (1.0.2 => 1.0.4)
  • Upgrading fof/sitemap (1.0.2 => 1.0.3)
  • Upgrading fof/socialprofile (1.1.0 => 1.1.1)
  • Upgrading fof/stopforumspam (1.1.1 => 1.2.0)
  • Upgrading fof/upload (1.0.7 => 1.1.0)
  • Upgrading fof/user-bio (1.0.1 => 1.0.2)
  • Upgrading fof/user-directory (1.1.0 => 1.2.2)
  • Upgrading ianm/follow-users (1.0.4 => 1.0.5)
  • Upgrading ianm/synopsis (1.0.2 => 1.2.0)
  • Upgrading katosdev/signature (1.1.3 => 1.2)
  • Upgrading kyrne/whisper (0.1.3 => 0.1.4)
  • Upgrading malago/flarum-achievements (0.5.2 => 0.5.4)
  • Upgrading michaelbelgium/flarum-discussion-views (v7.1.1 => v7.1.2)
积分: 15
16 天 后
19 天 后

找出所有只设置了子tag但没有设置parent tag的orpha tag状态的主题帖的sql:

SET @parentTagID = 15;
SELECT DISTINCT discussion_id FROM prefix_discussion_tag AS A WHERE discussion_id IN (SELECT discussion_id FROM `prefix_discussion_tag` WHERE tag_id IN (SELECT id FROM prefix_tags WHERE parent_id = @parentTagID)) AND NOT EXISTS (SELECT 1 FROM prefix_discussion_tag WHERE discussion_id = A.discussion_id AND tag_id = @parentTagID) ORDER BY discussion_id ASC;
积分: 15