I thought that every time a user edits someone else’s post, this action would be recorded in the user_actions table, but I’ve just realized this only happens sporadically (only for some users some of the time). Is this the intended behavior or is there another condition I’m not considering? It’s hard to give a step-by-step to reproduce this issue, but this is how I detected it: Find a post with an edit notification: [image] Query user_actions for the given acting_user_id (the editor), the given user_id (the edited) and the given topic_id. In my case: select * from user_actions ua where ua.acting_user_id = 229 and ua.user_id = 259 and ua.target_topic_id = 1907; This is what I get: Action type 2 means that the edited user received a LIKE from the editor. Action type 6 means that the editor responded to the edited user. id | action_type | user_id | target_topic_id | target_post_id | target_user_id | acting_user_id | created_at | updated_at -------+-------------+---------+-----------------+----------------+----------------+----------------+----------------------------+---------------------------- 78476 | 2 | 259 | 1907 | 17893 | | 229 | 2020-03-20 03:39:12.255619 | 2020-03-20 03:39:12.395574 78478 | 6 | 259 | 1907 | 17900 | | 229 | 2020-03-20 03:44:04.847102 | 2020-03-20 03:44:04.847102 I can confirm both of these actions in the UI, but I would also expect to find an action_type 11 indicating the EDIT. Besides seeing the edit in the UI, I can also confirm its existence in the post_revisions table querying using the target_post_id: select id, user_id, post_id, number, created_at, updated_at from post_revisions pr where post_id = 17893; id | user_id | post_id | number | created_at | updated_at | ------+---------+---------+--------+----------------------------+----------------------------+-------- 8927 | 229 | 17893 | 2 | 2020-03-20 03:40:06.644576 | 2020-03-20 03:43:32.769535 | So, why doesn’t this action show up in user_actions?

Edits are not meant to be stored there, they are stored in post_revisions.

Right, not the edit. I mean the user_action EDIT event: app/models/user_action.rb main validates :action_type, presence: true validates :user_id, presence: true LIKE = 1 WAS_LIKED = 2 NEW_TOPIC = 4 REPLY = 5 RESPONSE = 6 MENTION = 7 QUOTE = 9 EDIT = 11 NEW_PRIVATE_MESSAGE = 12 GOT_PRIVATE_MESSAGE = 13 SOLVED = 15 ASSIGNED = 16 LINKED = 17 ORDER = Hash[ *[ The thing is that it’s triggered 90% of the time. I don’t understand why it doesn’t work the other 10%

I just realized that either I don’t fully understand the cases where an edit notification is created or this is a much more widespread problem than I thought. Main assumptions If User A edits what User B wrote, several things happen: A new row gets added to the post_revisions table. A new row gets added to the user_actions table with action_type = 11. By going to /u/userB/notifications/edits, User B will be able to see that a new edit was made by User A (this depends on user_actions). By clicking on the pencil icon in his post, User B will be able to see the actual edit that User A performed (this depends on post_revisions). Test If the above assumptions are correct, this query should show all the rows in the post_revisions table for posts created by User B (in this case, id 259) that were edited by any user (other than himself, or the system user), along with the corresponding rows in user_actions for action_type = 11. with my_user_posts as ( select p.id, p.user_id from posts p where p.user_id = 259 -- choose a user id ) select up.user_id as my_user_id, ua.user_id as target_user_id, pr.post_id, ua.target_post_id, pr.user_id as editor_user_id, ua.acting_user_id, ua.action_type, pr.created_at as edit_created_at, ua.created_at as action_created_at from post_revisions pr inner join my_user_posts up on up.id = pr.post_id and up.user_id != pr.user_id -- no self edits and pr.user_id != -1 -- no system edits left join user_actions ua on ua.target_post_id = pr.post_id and ua.action_type = 11 -- only EDIT actions order by pr.post_id, pr.created_at; Expected output Every row has both post_revisions data along with user_actions data. Actual output Some of the post_revisions rows doesn’t have matching user_actions data. Therefore, the user can see the revisions by clicking on the pencil in each post, but wasn’t notified about receiving several edits. [image] Things I’ve tried Adding an additional edit to an old post without user_action data. Result: the user_action data also did not appear. Creating a fake user, copying the pre-edit content of a post without user_action data, creating a post with it and applying the same edit that was done with a different user. Result: the user_action data appeared correctly. Repeating the above procedures when the user is active or offline. Result: no change. Repeating the above procedures changing the editing grace period. Result: no change. Conclusions The issue doesn’t appear to be: user-specific. It happens to practically every user. connection-specific. The fact that the user is active or offline doesn’t change the output. time-specific. Changing the editing grace period had no effect. The issue appears to be action-specific. I have not seen any issues notifying any of the other actions (LIKE, WAS_LIKED, RESPONSE, REPLY, MENTION or QUOTE). The only problem is with EDIT actions. post-specific. It doesn’t happen to every post, only specific ones (seemingly at random) One possibility is that something is happening during the creation of specific posts to prevent EDIT user_actions from being saved, but I have no idea what this could be. It’s also possible that this is happening by design and that there are specific conditions under which users are not notified of edits, but I haven’t seen this documented anywhere. Next steps If you know a reason why edit notifications might not get triggered every time there is an edit, please let me know. If you have your own Discourse instance, could you run the above SQL query on some of your user ids to see if you also see missing user_actions data and report back?

I just want to be 100% sure you’re clear about edit grace periods, which would still apply even if there is a different user editing the post. [image] (Yes, if user A edits user B’s post, there is always a forced edit revision, but that doesn’t mean that if user A edits user B’s post 6 times in 60 seconds, there are 6 revisions and 6 notifications created. There will be only one revision and one notification, as you can see in the above screenshot.) Are each of these edits more than 5 minutes apart?

Thanks for the comment, Jeff. I can confirm that yes, these edits are more than 5 minutes apart. But even if they weren’t, as long as a single post_revision gets created, shouldn’t there ALWAYS be an accompanying EDIT user_action? As a side note, I also tried changing the editing grace period to 0 and when I do that, 2 identical post_revisions are created for every change. I don’t know if this is by design or if it’s an unrelated bug.

[image] Nacho_Caballero: these edits are more than 5 minutes apart Just making sure about that, good to confirm.

[image] Nacho_Caballero: this query Could someone run the above query on their Discourse site to see if they also get post_revisions without corresponding user_actions of type 11?

Digging through our code I think you only get user_action type 11 if you edit someone elses post or trigger a notification regarding the edit in some other way.

Thanks, Sam. That’s what I was expecting, but it’s not what I’ve found (on my site, at least). As you can see from the results of my query, in some cases, user A edits a post by user B (which adds a row in post_revisions), but there is no corresponding row in user_actions (with action_type 11). That is what I don’t understand. [image] Nacho_Caballero: Some of the post_revisions rows doesn’t have matching user_actions data. Therefore, the user can see the revisions by clicking on the pencil in each post, but wasn’t notified about receiving several edits .

Do you have a repro of the issue, is it a once off?

Edits not being stored in user_actions table

Development

codinghorror (Jeff Atwood) May 2, 2020, 2:28am 21

We might have a bug here @Nacho_Caballero after all.. stand by. Thanks for persisting on this.

Topic		Replies	Views
Editing posts cause notification Product Support	23	3767	May 24, 2021
Watching / Tracking / Notifications for post edits for Moderators Feature	21	4647	February 3, 2020
Free to edit post at any time Feature	33	15931	May 22, 2023
Wiki post edits not shown in user's activity Feature	1	511	October 8, 2019
New way to track edits on wiki posts? Product Support wiki-posts	17	743	October 4, 2025

Edits not being stored in user_actions table

Related topics