CiviCRM Community Forums (archive)

I need anonymous users to get prompted to login to Drupal (or create account) when they try to register for a CiviEvent. In Drupal access control, "authenticated users" have "register for events" and "profile listings and forms" permission. Anonymous users do not.

However, when an anonymous user clicks the "register now" link, they get a default Drupal "access denied" page. When I set this default page to "example.com/user" they get the login page (which is what I want). However, upon loggin in, I immediately see:
     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
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -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]"]
)

Please guide me on how to properly prompt users to log in when they try to register for events. Thanks![/code]

Thanks. That improved things a bit. Seems that the huge MySQL error printing is gone, and users get prompted to log in. Sucks that they are taken to their user page instead of back to the CiviEvent page.

Anybody know how to have them redirected back to whatever they were trying to access, once they log in. Maybe more of a Drupal question  but I'm sure CiviCRM users need to know this. Thanks for the reply!

I'm not sure what the solution is - but I can explain why you're getting that error... Basically the Event ID is getting lost when the Event Registration page is re-loaded after the login. I suspect the entire "query string" is lost.

So instead of the redirect going to:
example.com/civicrm/event/register?id=2&reset=1

... it's going to:
example.com/civicrm/event/register

... and you can create the fatal error by requesting this URL on the demo.

If you can figure out a way to do what you need while preserving the part of the link that comes after the ? - that will solve your problem.