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

Comments

timwood’s picture

Here'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....

japerry’s picture

Priority: Major » Critical

I 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.

japerry’s picture

Issue tags: +cod 7.x-1.0 radar
CountPacMan’s picture

Status: Active » Needs review
StatusFileSize
new2.25 KB

Fixed. View needed to be updated to pull data from fields:
(attendee) User: Job title
and
(attendee) User: Organization

  • japerry committed 9369ec3 on 7.x-1.x authored by CountPacMan
    Issue #2461233 by CountPacMan: Community attendees view broken after...
japerry’s picture

Status: Needs review » Fixed

Committed. 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.

  • japerry committed 9369ec3 on 7.x-2.x authored by CountPacMan
    Issue #2461233 by CountPacMan: Community attendees view broken after...

  • japerry committed 583357a on 7.x-1.x authored by CountPacMan
    Issue #2461233 by CountPacMan: Community attendees view broken after...

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.