Hello,

I'm using Drupal 7.8, Flag 7.x-2.0-beta6, Flag Abuse - 7.x-2.x-dev (2011-Jun-13). After installing the modules
One can bookmark and flag abusive content. Also, 2 links are generated on the Navigation menu below Add Content as
* Add content
* My bookmarks
* Reported abuse

When i click on My bookmarks it gives me a list of my bookmarks. But when i click on the
Reported abuse link it gives the message


Debug:
'Exception: SQLSTATE[23000]: Integrity constraint violation: 1052 Column \'uid\' in field list is ambiguous'
in views_plugin_query_default->execute() (line 1380 of /opt/httpd/htdocs/www/staging/jopo/sites/all/modules/contrib/views/plugins/views_plugin_query_default.inc).

Regards.
Yashesh Bhatia

CommentFileSizeAuthor
#4 flag_abuse-1286114.patch843 byteswedge

Comments

yasheshb’s picture

yasheshb commented

i was taking a closer look at the view

http://example.com/admin/structure/views/view/all_flag_abuse_node/edit/p...
for the link
http://example.com/admin/content/flags

and it gave an error here too


Error message
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'uid' in field list is ambiguous

partyp’s picture

partyp commented

I'm having the same issue. Did you find anything further?

partyp’s picture

partyp commented

I removed all the fields from the default "abuse_node" view. Then I added back in the fields i wanted. I am not getting the error anymore.

wedge’s picture

wedge commented
Status: Active » Needs review
StatusFileSize
new flag_abuse-1286114.patch843 bytes

The attached patch (ported from #1047954: User warning: Column 'uid' in on clause is ambiguous query on Flag default views) fixed this for me.

roderik’s picture

roderik
Primary language Dutch
Location Amsterdam,NL / Budapest,HU
commented
Status: Needs review » Reviewed & tested by the community

Patch works. Code is straightforward.

pgrond’s picture

pgrond commented

Patch works for me too.

vordude’s picture

vordude commented

Patch Works for me.

"Content That's Been Reported" view is not functional unless this edit is made.

markwk’s picture

markwk commented

I'm getting this same error... patch makes sense... but still not working...

flags for notifying abusive content is a good idea but it seems that this approach hasn't gotten as much attention as it needs in 7.x branch.

cwithout’s picture

cwithout commented

Patch in #4 works and ought to be committed.

A similar change was already committed to the Flag module for the same issue on its views. #1047954: User warning: Column 'uid' in on clause is ambiguous query on Flag default views.

@markwk - If you saved and did not revert your view and/or didn't clear cache, you may not have seen the change take effect.

ezra-g’s picture

ezra-g commented
Status: Reviewed & tested by the community » Fixed

Committed. Thanks!

http://drupalcode.org/project/flag_abuse.git/commit/7796db1

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.