Neural Gourmet Archives | Feed Your Brain
Neural Gourmet Archives | Feed Your BrainThere's a bug in mySQL 4.1.21 that Neural Gourmet seems to have just run into that affects the SELECT DISTINCT(x) command when using ORDER BY. The effect it's having on Neural Gourmet is that some users (like myself) may be seeing posts all out of order. I'm trying to determine the extent of the users that have the problem so if you're having a strong sense of deja-vu and are seeing stuff from earlier in the year or last year on the front page please, please let me know in comments on this post. It doesn't appear to affect anonymous users (i.e.: people who aren't logged in) but some logged in users might be having this problem.
The home page looks fine to me, but since you bring up thread order, could that bug be related to how replies to forum topics are ordered? Ever since I joined, the "last reply" was ordered to reflect, I think, when the OP was replied to, but not when replies were replied to. I thought it was a peculiarity of the forum software.
In any case, the new format of the particular forum pages is much easier to navigate now.
This is a recent issue (since the server got upgraded to mySQL 4.1.21). Based on what people have reported at Drupal.org, the ordering problem only happens for logged-in admin users but I wanted to be sure.
I have filed a support ticket with the hosting company but they're still dealing with the power outage and probably consider patching mySQL to apply the fix extremely low priority and may in fact wish until CPanel applies the fix in a nightly update (in which case it may be weeks before it is fixed). However if the ordering problem only affects me then that is something I can live with for now.
Again, to be clear, the bug is in mySQL 4.1.21. The bug is not in Drupal core or Neural Gourmet. However, because NG and Drupal rely upon mySQL we are affected by the bug. However the bug only manifests for very specific users.
There is no new format for the forum pages either, but individual users have always been able to select how they want the forum comments to display (flat or threaded, newest or oldest comment first).
This means it's probably just constrained to admin roles (i.e. me).
