[drupal-devel] [bug] Author Information block has a bad query
Robin Monks
drupal-devel at drupal.org
Wed Jul 13 13:10:23 UTC 2005
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?
More information about the drupal-devel
mailing list