Apparently there are some problems with the join order and table aliases in certain situations.

http://drupal.org/node/40623

Which is discussed more in:

http://drupal.org/node/43735

Anyone have any ideas on these?

I don't mean to be crossposting - but that topic seems like it might be better discussed here than there.

Greg

Comments

andykemp’s picture

Has no-one got any ideas how to fix this?
It seems to effect lots of modules...
My server upgraded to MySQL5 and as a result I have had to disable the "Simple Access" as this was producing the unknown column error...

Please can someone look into this. I can do simple PHP and MySQL but patching this is a bit beyond me!!

Thanks
Andy