Slavik XenForo moderator Staff member Oct 6, 2018 #1 On line 465 we calculate reply counts using: Code: node.totalcount - node.textcount AS replycount, Which can result in an out of range error. As we can recalculate this on a rebuild in XenForo would seem best to ignore this calculation.
On line 465 we calculate reply counts using: Code: node.totalcount - node.textcount AS replycount, Which can result in an out of range error. As we can recalculate this on a rebuild in XenForo would seem best to ignore this calculation.
Mike XenForo developer Staff member Jan 28, 2019 #2 In this case, I believe that GREATEST(CAST(node.totalcount AS SIGNED) - CAST(node.textcount AS SIGNED), 0) AS replycount, should be sufficient to resolve the issue (while still returning the expected content).
In this case, I believe that GREATEST(CAST(node.totalcount AS SIGNED) - CAST(node.textcount AS SIGNED), 0) AS replycount, should be sufficient to resolve the issue (while still returning the expected content).
