[drupal-devel] [bug] Author information block seems to be broken

[killes]

Issue status update for 
http://drupal.org/node/27948
Post a follow up: 
http://drupal.org/project/comments/add/27948

 Project:      Drupal
 Version:      cvs
 Component:    profile.module
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  robertDouglass
 Updated by:   killes at www.drop.org
 Status:       patch (ready to be committed)

Cvbge and I think that it is equivalent in this case. it is unsure
whether it is faster, but IN () is usually regarded as being fast:
http://mysql.com/in




killes at www.drop.org



Previous comments:
------------------------------------------------------------------------

Mon, 01 Aug 2005 12:27:39 +0000 : robertDouglass

This needs confirmation but I am unable to get fields to be shown in the
author information block. The 'Link to full user profile' will work, but
when I deselect 'Link to full user profile' from
admin/block/configure/profile/0 and select the other fields instead,
the block fails to materialize.




------------------------------------------------------------------------

Thu, 11 Aug 2005 23:08:32 +0000 : tostinni

Attachment: http://drupal.org/files/issues/profile.module_2.patch (1.09 KB)

This little patch does the trick.
The bug came from the fact that the query retrieving user profiles,
didn't take all public fields.




------------------------------------------------------------------------

Thu, 01 Sep 2005 18:57:21 +0000 : killes at www.drop.org

Attachment: http://drupal.org/files/issues/profile_1.patch (1.12 KB)

I've looked at  the patch, changes "in" to "IN" and removed trailign DOS
newlines, and can confirm that it works.




------------------------------------------------------------------------

Thu, 01 Sep 2005 18:58:15 +0000 : killes at www.drop.org

changing status




------------------------------------------------------------------------

Fri, 02 Sep 2005 07:21:03 +0000 : Dries

Is using IN() equivalent to using OR or is one faster than the other?