The content type is not defined when creating the 'Node: Content Profile' relationship in Views. This creates the error message "Content type field is required." and does not allow removal of the relationship.

INNER JOIN users users ON node.uid = users.uid
LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = ''
LEFT JOIN stormperson stormperson ON node.vid = stormperson.vid

Here's the bit I'm guessing needs work?

 $handler->override_option('relationships', array(
  'content_profile_rel' => array(
    'id' => 'content_profile_rel',
    'table' => 'users',
    'field' => 'content_profile_rel',
  ),

Big thanks,
-H

Comments

juliangb’s picture

juliangb commented
Status: Active » Postponed (maintainer needs more info)

Storm doesn't currently do anything with content profile. Do you still get the error without Storm bits in the query? I think this may be an issue for a different module.

hdennen’s picture

hdennen commented
Project: Storm » Content Profile
Version: 6.x-2.x-dev » 6.x-1.0
Component: Storm Person » Views integration
Status: Postponed (maintainer needs more info) » Active

Indeed.