Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
cPanel v74.0.9 upgrade breaks discussions 'something went wrong'
Hello, just a note for anyone using 2.6.3 and doing the latest upgrade to cPanel.
This cPanel upgrade updates the /etc/my.cnf and breaks your forum.
Changes required in /etc/my.cnf are:
#sql_mode=ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Sincerely,
Donovan
1
Comments
Did a little digging on this and our ops team chimed in with some more info.
It looks like
ONLY_FULL_GROUP_BYis on by default in MySQL as of 5.7.5.This setting is actually a sub-piece of
STRICT_MODE:We've had all our developers working with strict mode enabled by default for a little while now, so the next version of Vanilla should put an end to this sort of sql mode nonsense tripping us up.
I'm curious @donovanb, could you tell me what you mean by "breaks discussions". What exactly triggers the something went wrong, browsing to one discussion? browsing to recent discussions? Any info would be great, thanks!
@link , great!
@topcheese , yes, I'm not sure I'm using the right terms, but the "top-level" categories were fine.. drilling into the discussion thread presented that infamous 'something went wrong' error. The above change fixed it.
Oh, I should add for cPanel, restart MySQL after the change. You can do this in WHM or via: