I was wondering whether other people might be willing to share how they've resolved the problems associated with node access and mysql5, so we can provide good instructions about how best to respond to them.
Basically, the problem is that mysql5 changed its syntax and node access modules are broken as a result.
I've written two posts on this (this badly named one reviews my discoveries, while this post reviews a new problem).
See also http://drupal.org/node/43735, http://drupal.org/node/44049, http://drupal.org/node/40623, for example.
I think it would be useful to gather and coordinate newbie level instructions about how to deal with this very annoying problem. I myself have lost several hours on searching through messy posts to figure things out, and I still don't fully understand what needs to be done.
