Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-16863

Search for event participants from event page causes error DB Error: syntax error

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 4.6.5
    • Fix Version/s: None
    • Component/s: CiviEvent
    • Labels:
      None
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      DUPLICATE: CRM-16858 - but I can't close or change Status

      Error introduced in this version. Reproduced on demo. http://d46.demo.civicrm.org/civicrm/event/search?reset=1&force=1&status=true&event=1

      go to event manage and select participant list from a specific event.
      SQL Is:
      WHERE
      (
      civicrm_event.id = 993

      • AND civicrm_participant.status_id 0*
        AND civicrm_participant.is_test = 0
        ) AND
        (contact_a.is_deleted = 0)

      SQL Code Should Be:

      WHERE
      (
      civicrm_event.id = 993
      AND civicrm_participant.status_id =0
      AND civicrm_participant.is_test = 0
      ) AND
      (contact_a.is_deleted = 0)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sonicthoughts shawn holt
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: