On Mon, 27 Feb 2006 23:30:57 -0500 Walt Daniels wrote:
I think there are bugs which deserve a similar high priority, e.g. the MySQL 5.12+ bug.
there's no 1 bug. this bug is spread out over numerous contrib modules. the best summary and solution (that i've seen) is described here: http://drupal.org/node/43735#comment-92865 starbow (the author of that post) and i have submitted patches to the event, image, taxonomy, and project modules. so far, the one for event was applied, but none of the others have been committed (yet). there are probably other modules where this is a problem (e.g. http://drupal.org/node/51696), but we've only found/fixed this bug for the modules we're actively using. the solution is usually very easy: you just have to re-order the tables in a SELECT query so that if you're JOIN'ing w/ the {node} table, that it comes first. otherwise, db_rewrite_sql() will break SQL standards compliance if you enable any of the node access modules (node_privacy_byrole, simple_access, taxonomy_access, etc), since they add an "INNER JOIN {node_access} ON na.nid = n.nid" before the "{node} n" in the query. it's really just up to each module maintainer to apply these patches that already exist, or, in cases where there's no patch yet, a relatively trivial change to the code can get their module to work with MySQL 5.0.12+. i'd be happy to help folks test patches to various modules if needed. -derek p.s. for the interested reader, here are links to the not-yet-applied patches: image -- http://drupal.org/node/49433 project -- http://drupal.org/node/50572 taxonomy -- http://drupal.org/node/49430