[drupal-devel] [bug] Author Information block has a bad query
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?
participants (1)
-
Robin Monks