Good morning! Please pardon the delayed response - for some reason I had a mammoth session of sleep.
I've got a patch for you which I think resolves all of the issues you've described above, plus another one I discovered during testing. You should be OK in terms of MyConversations to then leave ONLY_FULL_GROUP_BY set, although I'm surprised your board was functional at all, because I encountered an error for a query in `showthread.php` itself when I enabled ONLY_FULL_GROUP_BY.
Are you comfortable applying patches?
In case you need them, here are some brief instructions:
I've got a patch for you which I think resolves all of the issues you've described above, plus another one I discovered during testing. You should be OK in terms of MyConversations to then leave ONLY_FULL_GROUP_BY set, although I'm surprised your board was functional at all, because I encountered an error for a query in `showthread.php` itself when I enabled ONLY_FULL_GROUP_BY.
Are you comfortable applying patches?
In case you need them, here are some brief instructions:
- Download the supplied patch file to your web server's filesystem.
- Open a command shell on your web server and change directory to your forum root.
- Then run Code:
patch -p2 --dry-run -i path-to-the-patch/myconversations-bug-fixes-for-larry.patch
- If all goes well with that, then you can remove the `--dry-run` argument and run the patch for real.