- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 25,992
- راهحلها
- 27
- پسندها
- 3,285
- امتیازها
- 113
- سن
- 29
- محل سکونت
- England
- وب سایت
- xenforo.xyz
We have a
The query in
xf_reaction_content table with approching 200 million rows, and there seems to be an issue when reactions are rebuilt during user deletions.The query in
XF\Reaction\AbstractHandler::updateContentReactions which runs the sub-query SELECT content_id FROM xf_reaction_content WHERE content_type = ? AND reaction_user_id = ? is running it with a user ID of 0 - but there's just over 6 million rows with a user ID of 0. As this grows, this query seems to be getting...