I want to remove admin logs (admin/logs/staff_action_logs) or disable staff logs?
How to?
No. You can’t disable it.
Why would you want to do this?
I think database larger
Could you safely delete using postgres Sql?
thanks yoú
Take a back-up before you start firing off commands though!
There are very few legitimate reasons to do this…what is the reason?
First, @dangtrungluong , congratulations on having a forum that’s so successful that you actually need to worry about the database size.
However, perhaps you should consider sharding / partitioning?
Generating more granular backups?
Simply deleting data is usually a poor idea likely to lead to unforeseen problems. What exactly is the problem you’re having that you’re wanting to solve?
「いいね！」 2
@Mittineague i’m newbie joining to “discourse”
If you are new to using discourse then I do not see what the issue is at the moment and why you feel it will make a massive impact on your database. We have logs going back to 2014 with no impact and I do not believe it takes up a massive amount of space.
「いいね！」 7
It’s not a bad thing to think about things before they become a problem. If anything, I don’t think the database will be a problem as much as heavy weight media files could be. i.e. should you set up a CDN so the requests are served from closest to a visitors location? Do members reallly need to fill up a topic with mega weight files that could slow down page load and consume bandwidth?
hi. thank for all
レールコンソールを使用することもできますが、危険も伴います。したがって、もし私が正しければ、次のようになります。
cd /var/discourse
sudo ./launcher enter app
rails c
これでコンソールに入りました。スタッフアクション/管理者ログ全体を削除する1つの方法は、これを使用することです。
ただし、これはすべてを削除するため、望んでいたものではない可能性があります。期間を制限したり、特定のアクションを調査したりしたい場合があります。
例：
UserHistory.where(action: 17, acting_user_id: 5)
これは、IDが5のユーザーによって削除されたすべての投稿を返します。
または
UserHistory.where(action: 17, post_id: 15643)
これは、IDが15643の投稿を削除したユーザーに関する情報を返します。
テーブルフィールドとアクションIDのリストについては、このファイルを参照してください。
# == Schema Information
#
# Table name: user_histories
#
# id :integer not null, primary key
# action :integer not null
# acting_user_id :integer
# target_user_id :integer
# details :text
# created_at :datetime not null
# updated_at :datetime not null
# context :string
# ip_address :string
# email :string
# subject :text
# previous_value :text
# new_value :text
# topic_id :integer
# admin_only :boolean default(FALSE)
# post_id :integer
# custom_type :string
# category_id :integer
#
# Indexes
#
# index_user_histories_on_acting_user_id_and_action_and_id (acting_user_id,action,id)
# index_user_histories_on_action_and_id (action,id)
# index_user_histories_on_category_id (category_id)
# index_user_histories_on_subject_and_id (subject,id)
# index_user_histories_on_target_user_id_and_id (target_user_id,id)
# index_user_histories_on_topic_id_and_target_user_id_and_action (topic_id,target_user_id,action)
#