mattrogowski
Well-known member
- Affected version
- 2.3.2
When determining users to send a report update alert to in
It then finds any comments where
However, if you assign and un-assign the report, the un-assignment changes the status back to
To reproduce:
XF\Service\Report\ClosureNotifierService
it runs this query:
SQL:
$lastOpenDate = $db->fetchOne("
SELECT comment_date
FROM xf_report_comment
WHERE report_id = ?
AND state_change = 'open'
ORDER BY comment_date DESC
LIMIT 1
", $reportId);
It then finds any comments where
comment_date
is greater than or equal to the date queried here, and is_report
is 1
. This should send the alert to users who commented since the report was last opened (or re-opened) as a report.However, if you assign and un-assign the report, the un-assignment changes the status back to
open
. This means that when the report is resolved, the query finds no users to send it to (or at least, no users that had reported it to date), as there are no comments where is_report
is 1
that are from after the report was most recently set to open
.To reproduce:
- Report a post
- Assign the report
- Un-assign the report
- Resolve the report and choose to send an alert
- The reporting user won't receive the alert