pages view for profile fields broken [#525058]

In HEAD, when trying to open a pages view for a profile field (i.e. the page with all the users that have the same value in the profile field, just to be clear on that), I get the following SQL error:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.access' in 'where clause': SELECT COUNT(*) AS expression FROM {users} users INNER JOIN {profile_value} v ON u.uid = v.uid WHERE (v.fid = :db_condition_placeholder_7) AND (u.access <> :db_condition_placeholder_8) AND (u.status <> :db_condition_placeholder_9) AND (v.value = :db_condition_placeholder_10) ; Array ( [:db_condition_placeholder_7] => 4 [:db_condition_placeholder_8] => 0 [:db_condition_placeholder_9] => 0 [:db_condition_placeholder_10] => 1 ) in PagerDefault->execute() (line 71 of C:\inetpub\wwwroot\drupal-7.x-dev\includes\pager.inc).

I wrote a tiny patch that fixes the problem.

Comment	File	Size	Author
#10	525058-profile-browse-d7.patch	2.04 KB	andypost
#10
#8	525058-profile-browse-d7.patch	2.55 KB	andypost
#8
#7	Screen shot of error message	41.86 KB	jerdiggity
#6	profile_browse.patch	2.12 KB	mfb
#6
	pagesview.patch	596 bytes	oneoftwo

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

ZoeN CreditAttribution: ZoeN commented 23 July 2009 at 22:15

This tiny patch works like a charm. Check this out, though: http://drupal.org/node/394720 If the profile.module data get migrated to Field API, will that impact this bug?

Comment #2

ZoeN CreditAttribution: ZoeN commented 7 August 2009 at 22:36

Looks like this has become a non-issue.

In this thread, there's a proposal afoot to move the "list of users who have X value for Y profile field" functionality out of profile.module into views. It looks very much as if that is happening - in current d7 HEAD, profile fields displayed on user profiles are already no longer linky.

Comment #3

17 August 2009 at 07:20

Status:

Needs review

» Needs work

The last submitted patch failed testing.

Comment #4

sun.core CreditAttribution: sun.core commented 17 August 2009 at 07:33

Status:

Needs work

» Needs review

Comment #5

25 November 2009 at 05:01

mfb requested that failed test be re-tested.

Comment #6

mfb

they or he

CreditAttribution: mfb commented 12 December 2009 at 16:33

File	Size
profile_browse.patch	2.12 KB

added basic test coverage - just enough to catch this.

Comment #7

jerdiggity CreditAttribution: jerdiggity commented 8 March 2010 at 03:54

Priority:	Normal	» Critical
Issue tags:		+Quick fix

File	Size
Screen shot of error message	41.86 KB

Just encountered the same problem:
**************************

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'u.access' in 'where clause': SELECT COUNT(*) AS expression
FROM
{users} users
INNER JOIN {profile_value} v ON u.uid = v.uid
WHERE (v.fid = :db_condition_placeholder_0) AND (u.access <> :db_condition_placeholder_1) AND (u.status <> :db_condition_placeholder_2) AND (v.value = :db_condition_placeholder_3) ; Array
(
[:db_condition_placeholder_0] => 1
[:db_condition_placeholder_1] => 0
[:db_condition_placeholder_2] => 0
[:db_condition_placeholder_3] => Male
)
in PagerDefault->execute() (line 86 of /includes/pager.inc).

**************************
I then applied the above patch and the problem was resolved. Plz also see attached screen shot.