Hello ;)

I am trying to list users who have falgged a node with a unflag link in the second field.
I am using views + panels + flag to accomplish this. Every thing is working good as far as I add a Display flag/unflag link field. Then I have this error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'users.nid' in 'field list'

CommentFileSizeAuthor
SQLSTATE[42S22] Column not found 1054.txt10.36 KBMStrzelecki_

Comments

dawehner’s picture

dawehner
Primary language German
commented
Project: Views (for Drupal 7) » Flag
Version: 7.x-3.x-dev » 7.x-2.x-dev
Component: user data » Views integration

This seems to be an issue of the flag module.

MStrzelecki_’s picture

MStrzelecki_ commented

could anyone fix this?

MStrzelecki_’s picture

MStrzelecki_ commented

It seems that this bug has got a long history. http://drupal.org/node/901120
And option that moderators could unflag users items would be nice, not only for me http://drupal.org/node/888934

MStrzelecki_’s picture

MStrzelecki_ commented
Version: 7.x-2.x-dev » 7.x-2.0-beta6

I am using beta6.

derhasi’s picture

derhasi commented

The "flag link" field seems not to be designed for a multi-user/non-current-user view. This leeds to the above error.
Instead, if you simply want to know, some user has flagged a content (content selected by argument), you should use the "flagged time" field.

derhasi’s picture

derhasi commented

EDIT: sorry! double post due to server down time

derhasi’s picture

derhasi commented

EDIT: sorry! double post due to server down time

joachim’s picture

joachim commented
Status: Active » Closed (duplicate)

Marking this as a duplicate of #901120: Views validation: invalid Ops.

Thanks for reporting!