Hi

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'flagging_node_field_data.sid' in 'on clause': SELECT node_field_data.created AS node_field_data_created, node_field_data.nid AS nid,

Flag links in views is not working when flag is enabled for anonymous user.

Steps to reproduce

1. Create new flag with the flag's scope as Personal and assign it to some content type

2. Do save some flags

3. Create a View to list all the content from all content type which is a flag is enabled.

4. Go to permission -> allow (un flag and flag permissions) your flags to anonymous user

5. Save or unsave some as anonymous user

then edit the view and see the error.

Comments

karthikeyan-manivasagam created an issue. See original summary.

maaty388’s picture

maaty388 CreditAttribution: maaty388 commented
Status: Active » Needs review

Hi,
There is similar issue, check if something from here works
https://www.drupal.org/node/2825993

maaty388’s picture

maaty388 CreditAttribution: maaty388 commented

Ok here is the patch and it works at least for me.
https://www.drupal.org/files/issues/2825993-24.patch
If this patch does not work for you try another one from here
https://www.drupal.org/node/2825993

socketwench’s picture

socketwench CreditAttribution: socketwench as a volunteer commented
Status: Needs review » Closed (duplicate)

Marking as a duplicate of #2825993: Fix Views support for anonymous flaggings (Unknown column 'flagging_node_field_data.sid')