Posted by executrex on November 17, 2012 at 9:13pm
I've got timeline working in Drupal 7 views when view is "content" type but when I do a user view with contextual filter as uid and relationship content authored, and then set a filter to my content type that I want to see on the timeline, it doesn't work. it works if I set the view to table, or whatever, but not timeline.
I get SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node.nid' in 'field list'
Is this a bug, or am I trying to do something that timeline doesn't do, or am I missing something.
As a work around I set node view permissions for view own content in my "content" type view, but the timeline view showed all users content. This is an important part of my site so any help would be appreciated.
thanks
Comments
Do you have the content id
Do you have the content id (node nid) added as a field in the view?
I'm unique, just like everybody else.
If I helped, please pay it forward, backward or sidelong.
node id
No, not a field in the view
do that- the message is
do that- the message is telling you it can't find the content id (node.nid). You should be able to set it to not display, but try with it displaying first to see if that fixes the issue.
I'm unique, just like everybody else.
If I helped, please pay it forward, backward or sidelong.
Node id
I had actually tried it before when you suggested it, but no difference. I just tried playing around with it again, but to no avail.
It seems to me to be a bug in the timeline module. WHen I try to access the view, I get
Notice: Undefined variable: class in include() (line 8 of /home/herus/public_html/sites/all/modules/timeline/views-view-timeline.tpl.php).
Notice: Undefined variable: width in include() (line 8 of /home/herus/public_html/sites/all/modules/timeline/views-view-timeline.tpl.php).
Notice: Undefined variable: class in include() (line 10 of /home/herus/public_html/sites/all/modules/timeline/views-view-timeline.tpl.php).
Notice: Undefined variable: timeline_theme in include() (line 10 of /home/herus/public_html/sites/all/modules/timeline/views-view-timeline.tpl.php).
Notice: Undefined variable: height in include() (line 10 of /home/herus/public_html/sites/all/modules/timeline/views-view-timeline.tpl.php).
Drupal 7.18 fixed it
Just upgraded to Drupal 7.18 from 7.17 and it seems there is some new functionality so now from a view type of content, I can set a relationship to content author, then a contextual filter to user Uid, then a filter to current user. So it would seem it's no longer necessary to create user type view to get content by current user. Anyway, my timeline is now showing current user's stuff. Thanks