CiviCRM Community Forums (archive)

I hv civicrm 1.7 on Drupal 4.7. I have three civicrm profiles that appear in the registration form. Personal, Alumni and Group profiles. The Group profile has only the group(s) field for an individual.

I recently disabled this Groups profile and created a group(s) field for an individual in the Alumni profile. After this change I get the errors below even if I revert to my original configuration. If I disable the Group profile the problem goes away.

Any help will be highly appreciated.

Thanks
Gerry

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 'of 1953, Class of 1955, Class of 1957, Class of 1958, Class of 1960, Class of 19' at line 10, 1064

Return to CiviCRM menu.

Error Details:


Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT
                    civicrm_group_contact.id as civicrm_group_contact_id,
                    civicrm_group.title as group_title,
                    civicrm_group.visibility as visibility,
                    civicrm_group_contact.status as status,
                    civicrm_group.id as group_id,
                    civicrm_subscription_history.date as date,
                    civicrm_subscription_history.method as method FROM civicrm_contact contact_a LEFT JOIN civicrm_group_contact ON contact_a.id = civicrm_group_contact.contact_id  LEFT JOIN civicrm_group ON civicrm_group.id =  civicrm_group_contact.group_id  LEFT JOIN civicrm_subscription_history
                                   ON civicrm_group_contact.contact_id = civicrm_subscription_history.contact_id
                                  AND civicrm_group_contact.group_id   =  civicrm_subscription_history.group_id WHERE contact_a.id = 603 AND civicrm_group.is_active = 1  AND civicrm_group_contact.status = 'Added' AND  (  ( civicrm_group_contact.group_id IN (Class of 1953, Class of 1955, Class of 1957, Class of 1958, Class of 1960, Class of 1961, Class of 1962, Class of 1963, Class of 1964, Class of 1965, Class of 1966, Class of 1967, Class of 1968, Class of 1969, Class of 1970, Class of 1971, Class of 1972, Class of 1973, Class of 1974, Class of 1975, Class of 1976, Class of 1977, Class of 1978, Class of 1979, Class of 1980, Class of 1981, Class of 1982, Class of 1983, Class of 1984, Class of 1985, Class of 1986, Class of 1987, Class of 1988, Class of 1989, Class of 1990, Class of 1991, Class of 1992, Class of 1993, Class of 1994, Class of 1995, Class of 1996, Class of 1997, Class of 1998, Class of 1999, Class of 2000, Class of 2001, Class of 2002, Class of 2003, Class of 2004, Class of 2005, Class of 2006, Class of 2007, Daily Registeration, Ex-Teachers, Friends of Stanislaus, Junior College 1979, Junior College 1980, Junior College 1981, Managing Comittee, Stanislites of Australia, Stanislites of Canada, Stanislites of India, Stanislites of New Zealand, Stanislites of UAE, Stanislites of United Kingdom, Stanislites of United States, Teachers and School Admin ) AND civicrm_group_contact.status = 'Added' )  )   ORDER BY civicrm_group.title  [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 'of 1953, Class of 1955, Class of 1957, Class of 1958, Class of 1960, Class of 19' at line 10]
    [type] => DB_Error
    [user_info] => SELECT
                    civicrm_group_contact.id as civicrm_group_contact_id,
                    civicrm_group.title as group_title,
                    civicrm_group.visibility as visibility,
                    civicrm_group_contact.status as status,
                    civicrm_group.id as group_id,
                    civicrm_subscription_history.date as date,
                    civicrm_subscription_history.method as method FROM civicrm_contact contact_a LEFT JOIN civicrm_group_contact ON contact_a.id = civicrm_group_contact.contact_id  LEFT JOIN civicrm_group ON civicrm_group.id =  civicrm_group_contact.group_id  LEFT JOIN civicrm_subscription_history
                                   ON civicrm_group_contact.contact_id = civicrm_subscription_history.contact_id
                                  AND civicrm_group_contact.group_id   =  civicrm_subscription_history.group_id WHERE contact_a.id = 603 AND civicrm_group.is_active = 1  AND civicrm_group_contact.status = 'Added' AND  (  ( civicrm_group_contact.group_id IN (Class of 1953, Class of 1955, Class of 1957, Class of 1958, Class of 1960, Class of 1961, Class of 1962, Class of 1963, Class of 1964, Class of 1965, Class of 1966, Class of 1967, Class of 1968, Class of 1969, Class of 1970, Class of 1971, Class of 1972, Class of 1973, Class of 1974, Class of 1975, Class of 1976, Class of 1977, Class of 1978, Class of 1979, Class of 1980, Class of 1981, Class of 1982, Class of 1983, Class of 1984, Class of 1985, Class of 1986, Class of 1987, Class of 1988, Class of 1989, Class of 1990, Class of 1991, Class of 1992, Class of 1993, Class of 1994, Class of 1995, Class of 1996, Class of 1997, Class of 1998, Class of 1999, Class of 2000, Class of 2001, Class of 2002, Class of 2003, Class of 2004, Class of 2005, Class of 2006, Class of 2007, Daily Registeration, Ex-Teachers, Friends of Stanislaus, Junior College 1979, Junior College 1980, Junior College 1981, Managing Comittee, Stanislites of Australia, Stanislites of Canada, Stanislites of India, Stanislites of New Zealand, Stanislites of UAE, Stanislites of United Kingdom, Stanislites of United States, Teachers and School Admin ) AND civicrm_group_contact.status = 'Added' )  )   ORDER BY civicrm_group.title  [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 'of 1953, Class of 1955, Class of 1957, Class of 1958, Class of 1960, Class of 19' at line 10]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT
                    civicrm_group_contact.id as civicrm_group_contact_id,
                    civicrm_group.title as group_title,
                    civicrm_group.visibility as visibility,
                    civicrm_group_contact.status as status,
                    civicrm_group.id as group_id,
                    civicrm_subscription_history.date as date,
                    civicrm_subscription_history.method as method FROM civicrm_contact contact_a LEFT JOIN civicrm_group_contact ON contact_a.id = civicrm_group_contact.contact_id  LEFT JOIN civicrm_group ON civicrm_group.id =  civicrm_group_contact.group_id  LEFT JOIN civicrm_subscription_history
                                   ON civicrm_group_contact.contact_id = civicrm_subscription_history.contact_id
                                  AND civicrm_group_contact.group_id   =  civicrm_subscription_history.group_id WHERE contact_a.id = 603 AND civicrm_group.is_active = 1  AND civicrm_group_contact.status = 'Added' AND  (  ( civicrm_group_contact.group_id IN (Class of 1953, Class of 1955, Class of 1957, Class of 1958, Class of 1960, Class of 1961, Class of 1962, Class of 1963, Class of 1964, Class of 1965, Class of 1966, Class of 1967, Class of 1968, Class of 1969, Class of 1970, Class of 1971, Class of 1972, Class of 1973, Class of 1974, Class of 1975, Class of 1976, Class of 1977, Class of 1978, Class of 1979, Class of 1980, Class of 1981, Class of 1982, Class of 1983, Class of 1984, Class of 1985, Class of 1986, Class of 1987, Class of 1988, Class of 1989, Class of 1990, Class of 1991, Class of 1992, Class of 1993, Class of 1994, Class of 1995, Class of 1996, Class of 1997, Class of 1998, Class of 1999, Class of 2000, Class of 2001, Class of 2002, Class of 2003, Class of 2004, Class of 2005, Class of 2006, Class of 2007, Daily Registeration, Ex-Teachers, Friends of Stanislaus, Junior College 1979, Junior College 1980, Junior College 1981, Managing Comittee, Stanislites of Australia, Stanislites of Canada, Stanislites of India, Stanislites of New Zealand, Stanislites of UAE, Stanislites of United Kingdom, Stanislites of United States, Teachers and School Admin ) AND civicrm_group_contact.status = 'Added' )  )   ORDER BY civicrm_group.title  [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 'of 1953, Class of 1955, Class of 1957, Class of 1958, Class of 1960, Class of 19' at line 10]"]
)





This was an issue with CiviCRM v1.7 and is fixed in v1.8
check: http://issues.civicrm.org/jira/browse/CRM-1966

kurund