CiviCRM Community Forums (archive)

I'm trying to install and use CiviCRM 1.8.11536 with joomla 1.5.2. This is a forced choice, because my mantainer has no plan to upgrade to PHP5.
In the backend (administration) everything semms to be OK but in the frontend when i try to access to the civi Event i've got this 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
        (
            [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]"]
)


Is there someone that want to mantain this project on PHP4.xx ?? Aruba.it users will appreciate... [/code]

if civicrm is important to your org, you are better off using a different host and using php5 / mysql5. Will be better for you (and us) in the long term. With the goPHP5 initiative, no projects will have another PHP4 release, i.e. drupal 7 will be php5 (i also think joomla 1.6 will be php5 only)

I'm not sure if anyone is maintaining the 1.8 release. We only support and maintain the latest release

lobo