[drupal-devel] [bug] Author Information block has a bad query

[Robin Monks]

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

 Project:      Drupal
 Version:      cvs
 Component:    profile.module
 Category:     bug reports
 Priority:     normal
-Assigned to:  Anonymous
+Assigned to:  Robin Monks
 Reported by:  samo
 Updated by:   Robin Monks
-Status:       active
+Status:       patch
 Attachment:   http://drupal.org/files/issues/profile_view_query.patch (1.11 KB)

Corrects issue.


Tested to WORK on HEAD.


Robin




Robin Monks



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

May 28, 2005 - 16:41 : samo

line 63 seems wrong:


$result = db_query('SELECT name, title, type, visibility FROM
{profile_fields} WHERE visibility = %d ORDER BY weight',
PROFILE_PUBLIC, PROFILE_PUBLIC_LISTING);


PROFILE PUBLIC_LISTING should have an "S" at the end; also there is
only one variable substitution in the above query.  I believe it should
be:


$result = db_query('SELECT name, title, type, visibility FROM
{profile_fields} WHERE visibility = %d OR visibility = %d ORDER BY
weight', PROFILE_PUBLIC,PROFILE_PUBLIC_LISTINGS);




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

July 7, 2005 - 14:35 : samo

this is still active in HEAD and is a very easy fix.  


anyone?