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
Comment | File | Size | Author |
---|---|---|---|
#2 | signup-filter-enabled-sql-1285536-2.patch | 721 bytes | jordojuice |
Comments
Comment #1
linuxbcn CreditAttribution: linuxbcn commentedI 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.
Comment #2
jordojuice CreditAttribution: jordojuice commentedThis patch fixes it for me. Tests would be much appreciated : )
Comment #3
jordojuice CreditAttribution: jordojuice commentedMarking this as a duplicate. That patch at http://drupal.org/node/1358258#comment-5561056 fixes this as well as #1399178: Ajax error when trying to use the sign up link in a view