Hello,

In views, when creating an view to display content types that have signups enabled, I get the following SQL error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'signup.nidISNOTNULL' in 'where clause'

the SQL: SELECT node.title AS node_title, node.nid AS nid, signup.close_signup_limit AS signup_close_signup_limit, signup.status AS signup_status, node.created AS node_created
FROM
{node} node
LEFT JOIN {signup} signup ON node.nid = signup.nid
WHERE (( (node.status = '1') AND (node.type IN ('event', 'events_door_leden')) AND (signup.nidISNOTNULL IS NULL ) ))
ORDER BY node_created DESC

Any idea where to start looking?

thx

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

linuxbcn’s picture

I have the same error

My issue report:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'signup.nidISNOTNULL' in 'where clause'

No more details.

I only need make a simple Views with the nodes with signup module is enable.

jordojuice’s picture

Status: Active » Needs review
FileSize
721 bytes

This patch fixes it for me. Tests would be much appreciated : )

jordojuice’s picture

Status: Needs review » Closed (duplicate)