Hi guys :)

I've browsed through the issues and Googled as best I can, apologies if this is a duplicate/known issue, but I have not been able to find it.

In my case, all users (anon and logged in) can flag nodes, then those nodes are later printed in a view (bookmarking, essentially), but for some reason, only logged in users can view the results of the view.

Anon users can see the view (there is Header content in the view, which can be seen by anon users), just not the actual results. When clicking the flag link, anon users are getting the appropriate messages for adding and removing a flag.

From what I can see, permissions are appropriate for views and for flags.

If anyone could shed some light, I would be most grateful :)

Cheers,
Josh

Comments

jfarry’s picture

jfarry commented

Also, if i set the output of the view to display "x" text when results are empty, "x" does not display, so the view does not appear to be empty.

mooffie’s picture

mooffie commented

Also, if i set the output of the view to display "x" text when results are empty, "x" does not display, so the view does not appear to be empty.

(1a) Does this happen for logged in users as well? In othe words: if a logged in user has bookmarked nothing, does he see the "x"?
(1b) Suppose an anonymous user has bookmarked *nothing*, does he see the "x"?

==

(2) Perhaps it's a caching issue. Add "?whatever" to the end of the URL, when you're anonymous on the view page, to ensure that you get a fresh page. Is the view still empty?

(3) Use the Devel module and tell us the SQL query the view generates.

(4) It's a non-global flag, right?

jfarry’s picture

jfarry commented

Hi mooffie and thank you for such a quick reply :)

(1a) I've just checked then on both authenticated users and if there are no flags, they do not see "x" either.
(1b) No. If anon user doesn't bookmark anything, they don't see x either. I guess in hindsight that was a bad test :P

==

(2) Unfortunately it's not a caching issue. I've added a url argument like you said, as well as dumped my cache and the problem remains.

(3) When in the view itself (as in, editing it), the query output is as follows:

SELECT node.nid AS nid,
   node.title AS node_title
 FROM node node 
 INNER JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = 2 AND flag_content_node.uid = ***CURRENT_USER*** AND flag_content_node.sid = 0)

This is an export of the view itself:

$view = new view; $view->name = 'planner_flags'; $view->description = 'Holiday Planner - Flags'; $view->tag = ''; $view->view_php = ''; $view->base_table = 'node'; $view->is_cacheable = FALSE; $view->api_version = 2; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ $handler = $view->new_display('default', 'Defaults', 'default'); $handler->override_option('relationships', array( 'flag_content_rel' => array( 'label' => 'flag', 'required' => 1, 'flag' => 'planner_items', 'user_scope' => 'current', 'id' => 'flag_content_rel', 'table' => 'node', 'field' => 'flag_content_rel', 'relationship' => 'none', ), )); $handler->override_option('fields', array( 'title' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'html' => 0, 'strip_tags' => 0, ), 'empty' => 'empty text for title', 'hide_empty' => 0, 'empty_zero' => 0, 'link_to_node' => 1, 'exclude' => 0, 'id' => 'title', 'table' => 'node', 'field' => 'title', 'relationship' => 'none', ), )); $handler->override_option('access', array( 'type' => 'none', )); $handler->override_option('cache', array( 'type' => 'none', )); $handler->override_option('header', '

sup

'); $handler->override_option('header_format', '1'); $handler->override_option('header_empty', 1); $handler->override_option('style_plugin', 'list'); $handler->override_option('style_options', array( 'grouping' => '', 'type' => 'ol', )); $handler = $view->new_display('block', 'Block', 'block_1'); $handler->override_option('block_description', ''); $handler->override_option('block_caching', -1);

From devel, the closet thing I could find to what I think you're chasing is this:

This is what is generated for authenticated users:

execute
SELECT DISTINCT node.nid AS nid, node.title AS node_title FROM node node INNER JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = 2 AND flag_content_node.uid = 1 AND flag_content_node.sid = 0) LIMIT 0, 10
0.34
1

This is what is generated for anonymous users:

execute
SELECT DISTINCT node.nid AS nid, node.title AS node_title FROM node node INNER JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = 2 AND flag_content_node.uid = 0 AND flag_content_node.sid = 32) INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author'))) LIMIT 0, 10
0.35
1

(4) Yes. It's a non-global flag :)

mooffie’s picture

mooffie commented

Thanks for the additional details.

(1a) I've just checked then on both authenticated users and if there are no flags, they do not see "x" either.

(Very strange. Something is fishy with your "x". Do you see an "x" (if you define it) in empty views that have nothing to do with Flag?)

This is what is generated for anonymous users:

The SQL looks fine.

(5) I see that you're using a node access module. Could you please temporary disable it and see if it solves the problem?

(It seems unlikely, because if your Nodeaccess module prohibits anonymous users from viewing these nodes, then anons won't have a chance to see the "Flag this!" link in the first place. But it's worth doing this check.)

(6) Finally: Do you know how to execute SQL queries? In phpMyAdmin, for example? Alternatively, do you have some software that shows you the contents of a DB table?

mooffie’s picture

mooffie commented

(One more thing: For the time being, please disable the page cache, if you have it enabled. (Administer › Site configuration › Performance.) It's probably irrelevant to your problem, but it won't hurt to eliminate this factor nevertheless.)

jfarry’s picture

jfarry commented

I feel I may not have been clear with the "x". All the "x" is, is when a field is empty, output "x." In this case it's "EMPTY FIELD".

I have altered another (non-flag) view and yes, both authenticated and anonymous users see "x" when the field is empty. In this case they see "Business Type: OUTPUT OF FIELD IS EMPTY"

(5) I just disabled Nodeaccess then, dumped the cache, removed, then re-added flags again on both authenticate and anon roles and the outcome is the same. Anon still cannot see the result of the view.

(6) Yes, SQL is no problems. I've got phpMyAdmin and Heidi, so you can take your pick :P

The page cache is currently disabled. The only thing that is enabled is page compression, but I have tried disabling that also, no dice :(

Thank you again :)

mooffie’s picture

mooffie commented

I feel I may not have been clear with the "x". All the "x" is, is when a field is empty, output "x." In this case it's "EMPTY FIELD".

I'm not sure what you're trying to do.

(7) Can you show us your exported view? The one you posted previously was mangled for some reason. Perhaps it will be easier to put it on pastebin.com and provide a link.

====

Yes, SQL is no problems.

The following SQL returns all the nodes flagged by a certain anonymous user:

SELECT node.nid, node.title FROM node INNER JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND (flag_content_node.fid = 2 AND flag_content_node.uid = 0 AND flag_content_node.sid = 32);

(It's a shortened version of the SQL you posted earlier.)

(8) If you execute this query, do you see any rows returned?

Note the number "32" there. It identifies the anonymous user that was active when you did your tests. It's called a "session ID" (or "sid" in short).

(9) If you see no rows (which seemingly means that anonymous #32 flagged nothing), examine the flag_content DB table (e.g., by executing "select * from flag_content;"): Do you see any rows whose "sid" column is "32"? If that table has few rows (or even many rows), feel free to paste it on pastebin (or here) so we can see it.

jfarry’s picture

jfarry commented

(7) The exported view is here: http://pastebin.com/Jk1b4bCN

====

(8) No results are returned for UID of 32 :(

(9) There aren't many rows, as the site is still in testing, but no, there are no 32's in there. The pastebin to the sql (for importing) is here: http://pastebin.com/djGkhsm3 and the textual representation of the data is here: http://pastebin.com/FZuwkH5Y :)

mooffie’s picture

mooffie commented

I want you to make Drupal print some diagnostic messages:

(10) In your theme folder you'll find a "page.tpl.php" file. Please add the following to it:

  if ($user->uid == 0) {
    print "Hello, anonymous! ";
    print "It's " . date('H:i:s', time()) . " now. ";
    print "Your SID is " . flag_get_sid() . " ";
    print "and you've bookmarked " . flag_load('planner_items')->get_user_count(0, flag_get_sid()) . " nodes.";
  }

This will print some useful information for anonymous users (e.g., "Hello ... you've bookmarked 3 nodes"). Don't yet tell us what it prints.

Next, edit your view:

(11) Into the Empty text setting type "No flagged nodes were found."

(12) Into the Header setting type:

Hi.
<?php
  print "It's " . date('H:i:s', time()) . " now. ";
  print "Your SID is " . flag_get_sid() . " ";
?>

Choose to "Display even if view has no result". For the "Input format" pick "PHP code" (if you don't have it in the list then you first have to enable the "PHP filter" module).

Now:

Log out. As an anonymous, flag some nodes. Refresh the page.

(13) What does the message we added to page.tpl.php say? (e.g., "Hello ... you've bookmarked 3 nodes") Please paste it here.

(14) Navigate to a page that shows your view. What does its message say? (e.g., "Hi. ... Your SID is ...") Please paste it here. Also paste the other message (the page.tpl.php message) showed on that same page ("Hello ... you've bookmarked 3 nodes"").

(Don't log in yet before doing the following step.)

(15) Put the contents of your flag_content DB table on pastebin and provide the link. (the "textual representation" is enough.)

jfarry’s picture

jfarry commented

(13) As an anonymous user:
On the home page: Hello, anonymous! It's 08:24:37 now. Your SID is 52 and you've bookmarked 0 nodes.
On the first page that is flagged: Hello, anonymous! It's 08:24:56 now. Your SID is 53 and you've bookmarked 0 nodes.
On the second page that is flagged: Hello, anonymous! It's 08:25:01 now. Your SID is 54 and you've bookmarked 0 nodes.

(14) The view output: Hi. It's 08:27:19 now. Your SID is 59.
On the view page, the page.tpl (i got the url wrong a few times, that's why it jumps from 54 to 59): Hello, anonymous! It's 08:27:19 now. Your SID is 59 and you've bookmarked 0 nodes.
Also on the view page, it says: "No flagged nodes were found."

(15)The textual representation of the table is here: http://pastebin.com/90DNx1bj

Again mooffie, thank you so much for your help :)

mooffie’s picture

mooffie commented

Your SID is 52 [...]
Your SID is 53 [...]
Your SID is 54 [...]

Mmm...

Is seems we've found the problem. The SID should remain fixed. If I understand correctly, in your case it's bumped on every page.

Please confirm my understanding: refresh the page a couple of times (don't bother to flag nodes in between) and tell me if the SID keeps bumping.

The problem is likely in the Session API module.

- What version of it are you using?
- Upgrade to its latest version and check things again.
- Can you check things with a different browser? Perhaps the fault is in some cookie-settings in your browser (seems unlikely, but won't hurt to check).

jfarry’s picture

jfarry commented

Hi Mooffie,

Yes, the SID is being bumped on every page. This is not browser specific either, it's happening in Chrome 8, IE 8 and Firefox 3.6.

I was using Session API 6x 1.3, but I have just updated to 6x 1x dev and am having the same problem.

Would you like me to duplicate the problem in their issue queue?

mooffie’s picture

mooffie commented
Component: Views integration » Flag core

(So this issue has nothing to do with Views.)

mooffie’s picture

mooffie commented

Would you like me to duplicate the problem in their issue queue?

Yes, please do so. Thanks. Make the subject "The SID is being bumped on every page" and explain that you put a snippet in page.tpl.php that shows this. (Don't copy our lenthy discussion from here: it's an irrelevant "noise".)

We'll continue the discussion at that new issue.

jfarry’s picture

jfarry commented

Done :) http://drupal.org/node/1005766

mooffie’s picture

mooffie commented
Status: Active » Closed (duplicate)

I'm marking this a dup of #1005766: The SID is being bumped on every page.

(Remember: you'll have to upgrade to the "dev" version of Flag if you want to use page caching. It fixes several related bugs.)