I'm trying to create a view (using the views module) to show all tasks:
-- assigned to a person (my own field)
-- With given status.

Adding my own field as an exposed filter is working OK.
When I add a filter for the Task Status, I get numerous messages of:

warning: preg_match() expects parameter 2 to be string, array given in /home/sites/tri-knight-solutions.co.uk/public_html/includes/bootstrap.inc on line 771.

I also find that the options (values) available for the status are only:
blank
"inserted"

Another issue I have is that the view doesn't work for a user who can own see their own organisation tasks. I Get:

user warning: Unknown column 'n.uid' in 'field list' query: SELECT node.nid AS nid, stormtask.organization_title AS stormtask_organization_title, stormtask.project_title AS stormtask_project_title, node.title AS node_title, stormtask.taskstatus AS stormtask_taskstatus, node_data_field_task_assigned.field_task_assigned_nid AS node_data_field_task_assigned_field_task_assigned_nid, node.type AS node_type, node.vid AS node_vid FROM drupal_node node LEFT JOIN drupal_stormtask stormtask ON node.nid = stormtask.nid LEFT JOIN drupal_content_type_stormtask node_data_field_task_assigned ON node.vid = node_data_field_task_assigned.vid WHERE (( CASE node.type WHEN 'stormexpense' THEN (SELECT IF(node.uid=6,1,0) FROM drupal_stormexpense sex1 WHERE sex1.vid=node.vid) WHEN 'storminvoice' THEN 0 WHEN 'stormknowledgebase' THEN 0 WHEN 'stormnote' THEN (SELECT IF(node.uid=6 OR sno1.organization_nid=2,1,0) FROM drupal_stormnote sno1 WHERE sno1.vid=node.vid) WHEN 'stormorganization' THEN (SELECT IF( sor1.nid=2,1,0) FROM drupal_stormorganization sor1 WHERE sor1.vid=node.vid) WHEN 'stormperson' THEN (SELECT IF( node.uid=6 OR spe1.organization_nid=2,1,0) FROM drupal_stormperson spe1 WHERE spe1.vid=node.vid) WHEN 'stormproject' THEN (SELECT IF( node.uid=6 OR spr1.organization_nid=2,1,0) FROM drupal_stormproject spr1 WHERE spr1.vid=node.vid) WHEN 'stormtask' THEN (SELECT IF( n.uid=6 OR sta1.organization_nid=2,1,0) FROM drupal_stormtask sta1 WHERE sta1.vid=n.vid) WHEN 'stormticket' THEN 0 WHEN 'stormtimetracking' THEN (SELECT IF(n.uid=6 OR stt1.organization_nid=2,1,0) FROM drupal_stormtimetracking stt1 WHERE stt1.vid=n.vid) ELSE 1 END )=1 ) AND ( node.type in ('stormtask') ) in /home/sites/tri-knight-solutions.co.uk/public_html/sites/all/modules/views/includes/view.inc on line 759.

Is this a bug or just me being stupid?

Thanks in advance.

Comments

Magnity’s picture

Magnity commented

(Please try to only post one problem in each Drupal.org issue!)

I believe the preg_match and filter options errors have been solved for the latest -dev release.

The n.uid issue -> I'll have a look at that.

tchurch’s picture

tchurch commented

Sorry. I wasn't sure if they were related to the same problem.

Magnity’s picture

Magnity commented
Status: Active » Closed (duplicate)

I've had a look at these again - and I think both of these have actually been fixed already. Therefore, please could you test the -dev release - if the problems are still there in that release, we'll need to look at them again. I'll put this as a duplicate - please reopen if the problems are still there.

For ref:
- First issue is duplicate of #500876: preg_match error when filtering views based on storm attributes
- Second issue is duplicate of #505322: Workflow error unless task & ticket permission = view all (see also #532428: Unknown column 'node.uid' in 'field list' query for application to timetrackings)

tchurch’s picture

tchurch commented
Status: Closed (duplicate) » Closed (fixed)

Thanks. It seems to all be working now with the -dev release.