Something is up with the community attendees content pane view 'cod_community_attendees'. No results are shown and there is an error in the views preview area when editing the view.
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ESCAPE '\\') )))) subquery' at line 4
Also on a fresh COD install, when editing the view I see these other messages.
This view has been automatically updated to fix missing relationships. While this View should continue to work, you should verify that the automatic updates are correct and save this view.
Warning: htmlspecialchars() expects parameter 1 to be string, array given in check_plain() (line 1583 of /var/www/cod.vm/includes/bootstrap.inc).
This is the query from views preview:
SELECT ticket_registration.trid AS trid, users_ticket_registration.picture AS users_ticket_registration_picture, users_ticket_registration.uid AS users_ticket_registration_uid, users_ticket_registration.name AS users_ticket_registration_name, users_ticket_registration.mail AS users_ticket_registration_mail, ticket_registration. AS ticket_registration_, '' AS field_data_field_profile_first__entity_type, '' AS field_data_field_profile_last__entity_type, '' AS field_data_field_profile_job_title__entity_type, '' AS field_data_field_profile_org__entity_type
FROM
{ticket_registration} ticket_registration
INNER JOIN {users} users_ticket_registration ON ticket_registration.user_uid = users_ticket_registration.uid
INNER JOIN {ticket_type} ticket_type_ticket_registration ON ticket_registration.bundle = ticket_type_ticket_registration.ttid
WHERE (( (ticket_type_ticket_registration.entity_id = '1' ) )AND(( (ticket_registration.state LIKE 'checked_in', 'completed' ESCAPE '\\') )))
LIMIT 50 OFFSET 0| Comment | File | Size | Author |
|---|---|---|---|
| #4 | 2461233-community-attendees-view-user-1.patch | 2.25 KB | CountPacMan |
Comments
Comment #1
timwoodHere's a diff of what changed from Beta7 to Beta8 from Drupal's web git viewer. Can anyone make pinpoint what part of the changes might have broken the view?
http://cgit.drupalcode.org/cod_support/diff/cod_community/cod_community....
Comment #2
japerryI think this might be partially due to the changes we've made in the drupalcon branch, we need to revisit this on stock cod for beta9.
Comment #3
japerryComment #4
CountPacMan commentedFixed. View needed to be updated to pull data from fields:
(attendee) User: Job title
and
(attendee) User: Organization
Comment #6
japerryCommitted. I've noticed the community view is a bit troublesome in that people want to change it often. But we'll see how this goes.