After a morning of slow query logging and cussing, a misplaced "GROUP BY" that was turning a 0.04 second query into one that took over fifteen seconds has been fixed. I'll leave the slow query log running overnight though just to make sure I didn't miss any less common ones. If you're still seeing any serious site slowdowns, let us know.
(Score: 2) by Pino P on Wednesday January 09 2019, @12:41AM (5 children)
"Invalid form key" might happen if you click Reply and then wait several hours before submitting.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @12:50AM (4 children)
Or if you change IP addresses, yep.
My rights don't end where your fear begins.
(Score: 2) by Runaway1956 on Wednesday January 09 2019, @03:19AM (1 child)
I've seen both of those. Type a reply, get called away by the wife, come back and hit submit. Or change to VPN, or disconnect from VPN. Both easily solved - hit the "back" button, copy what you had typed, then reload the topic to which you were responding, hit the "reply" button again. It's a mild irritant, might really piss some other people off.
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @04:27AM
It'd probably be a good idea to ditch it for all registered users, honestly. If they get their spam on we have a damned easy recourse, so there's not really a need for them. Cleanup would still be annoying but not insurmountable.
My rights don't end where your fear begins.
(Score: 2) by Pino P on Wednesday January 09 2019, @02:15PM (1 child)
If I'm commenting while riding the city bus, then my IP address will change depending on what hotspots my laptop or phone happens to pick up at the time. Could the form key IP address check be made less stringent for logged-in users, or for excellent-karma logged-in users? Or is it considered a measure against account compromise?
(Score: 2) by The Mighty Buzzard on Wednesday January 09 2019, @02:21PM
It could likely be removed entirely for registered users. I'll need some thought time on the ramifications.
My rights don't end where your fear begins.