CiviCRM Community Forums (archive)

Hello,
First off I have CiviCRM 1.9.11960 under Drupal.
The Problem: When people are trying to register for a paid event (not an event that is unpaid) they get the following error:

    Sorry. A non-recoverable error has occurred.

    Database Error Code: 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 'GROUP BY civicrm_participant.event_id' at line 9, 1064

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT   count(civicrm_participant.id) as total_participants,
                           civicrm_event.max_participants as max_participants,
                           civicrm_event.event_full_text as event_full_text 
                  FROM     civicrm_participant, civicrm_event
                  WHERE    civicrm_participant.event_id = civicrm_event.id
                     AND   civicrm_participant.status_id!=4
                     AND   civicrm_participant.is_test=0
                     AND   civicrm_participant.event_id=
                  GROUP BY civicrm_participant.event_id [nativecode=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 'GROUP BY civicrm_participant.event_id' at line 9]
    [type] => DB_Error
    [user_info] => SELECT   count(civicrm_participant.id) as total_participants,
                           civicrm_event.max_participants as max_participants,
                           civicrm_event.event_full_text as event_full_text 
                  FROM     civicrm_participant, civicrm_event
                  WHERE    civicrm_participant.event_id = civicrm_event.id
                     AND   civicrm_participant.status_id!=4
                     AND   civicrm_participant.is_test=0
                     AND   civicrm_participant.event_id=
                  GROUP BY civicrm_participant.event_id [nativecode=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 'GROUP BY civicrm_participant.event_id' at line 9]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT   count(civicrm_participant.id) as total_participants,
                           civicrm_event.max_participants as max_participants,
                           civicrm_event.event_full_text as event_full_text 
                  FROM     civicrm_participant, civicrm_event
                  WHERE    civicrm_participant.event_id = civicrm_event.id
                     AND   civicrm_participant.status_id!=4
                     AND   civicrm_participant.is_test=0
                     AND   civicrm_participant.event_id=
                  GROUP BY civicrm_participant.event_id [nativecode=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 'GROUP BY civicrm_participant.event_id' at line 9]"]
)