smilbuta wrote: ↑Tue Oct 06, 2020 2:11 pm
Hello,
Yep it worked, Thanks!
I was simply doing house cleaning on old messages. Had plenty of space. All other folders allowed for bulk deletion except that one.
Cool, glad you're good to go. Thanks for the quick follow-up!
For those interested in the technical bits of what happened:
phpBB (for some reason) stored the number of messages in a folder in a table, rather than calculating it every time. Likely for speed, which makes sense. It somehow got out of sync, and the stored size was less than the number of messages that were actually in the folder. When it tried to zero out that stored size value, the calculation ended up as a negative number, which won't fit inside a column that's an unsigned integer (positive numbers only). So, the database errored out, phpBB panicked and we got the error message reported.
I solved it by manually setting that stored count of messages to the real number of messages in the folder. I used this solution for two reasons:
- If the operation failed again in normal use (when I asked smibuta to try again) then I'd know the issue was repeatable, and I could take it to phpBB as a bug. I would then have worked with smibuta to handle the issue in a more manual method (likely manually deleting things from the database), or left it until phpBB could help, if it's non-urgent.
- I don't know what extra steps phpBB takes under the hood when things get deleted, nor did I want to try and take the time to find out. For all I know, just deleting the messages manually could have weird consequences for the users who sent/received those messages. Safer to not mess with things unless I absolutely have to. That said, I did manually update the table in this case. However, it's one simple value, and easy to revert.
At this point, I'm considering this as a one-off fluke unless it happens again.
MagickalMemories wrote:Please, nobody take this the wrong way when I say... Plarz, I love you.
No, no, guard, turn, parry, dodge, spin and -
then - thrust!
Plarzoid.com: A Miniatures Blog
Currently trading with: - |
Owed Refs from: - |
Owe refs to: -
If I owe you a ref, PM me!