CiviCRM Community Forums (archive)

we get this error using advanced search and choosing a canned civicrm group, "Paid Members- Special Permissions". Any advice?  Otherwise 2.0 is working just great and we like it  after a few years of use.

doug/friendsofthebbt.org


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 ') = 'all' AND civicrm_contribution.is_test = '0' AND civicrm_membership.members' at line 2, 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 DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact `civicrm_group_contact-17,10` ON contact_a.id = `civicrm_group_contact-17,10`.contact_id   WHERE  ( ( ( `civicrm_group_contact-17,10`.group_id IN (17,10) AND `civicrm_group_contact-17,10`.status IN ("Added") ) OR ( 
                            ( contact_a.id IN ( SELECT DISTINCT(contact_a.id) as id  FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id  INNER JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id  WHERE  ( LOWER(  ) = 'all' AND  civicrm_contribution.is_test = '0' AND civicrm_membership.membership_type_id IN (5,7,4,1,10,6,8,9) AND  civicrm_membership.is_test = 0 )  AND  ( 1 )  AND 1    ) 
                              AND contact_a.id NOT IN (
                              SELECT contact_id FROM civicrm_group_contact
                              WHERE civicrm_group_contact.group_id = 10 AND civicrm_group_contact.status = 'Removed' ) ) ) ) )  AND  ( 1 )     [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 ') = 'all' AND  civicrm_contribution.is_test = '0' AND civicrm_membership.members' at line 2]
    [type] => DB_Error
    [user_info] => SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact `civicrm_group_contact-17,10` ON contact_a.id = `civicrm_group_contact-17,10`.contact_id   WHERE  ( ( ( `civicrm_group_contact-17,10`.group_id IN (17,10) AND `civicrm_group_contact-17,10`.status IN ("Added") ) OR ( 
                            ( contact_a.id IN ( SELECT DISTINCT(contact_a.id) as id  FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id  INNER JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id  WHERE  ( LOWER(  ) = 'all' AND  civicrm_contribution.is_test = '0' AND civicrm_membership.membership_type_id IN (5,7,4,1,10,6,8,9) AND  civicrm_membership.is_test = 0 )  AND  ( 1 )  AND 1    ) 
                              AND contact_a.id NOT IN (
                              SELECT contact_id FROM civicrm_group_contact
                              WHERE civicrm_group_contact.group_id = 10 AND civicrm_group_contact.status = 'Removed' ) ) ) ) )  AND  ( 1 )     [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 ') = 'all' AND  civicrm_contribution.is_test = '0' AND civicrm_membership.members' at line 2]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT UPPER(LEFT(contact_a.sort_name, 1)) as sort_name  FROM civicrm_contact contact_a  LEFT JOIN civicrm_group_contact `civicrm_group_contact-17,10` ON contact_a.id = `civicrm_group_contact-17,10`.contact_id   WHERE  ( ( ( `civicrm_group_contact-17,10`.group_id IN (17,10) AND `civicrm_group_contact-17,10`.status IN ("Added") ) OR ( 
                            ( contact_a.id IN ( SELECT DISTINCT(contact_a.id) as id  FROM civicrm_contact contact_a LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id  INNER JOIN civicrm_membership ON civicrm_membership.contact_id = contact_a.id  WHERE  ( LOWER(  ) = 'all' AND  civicrm_contribution.is_test = '0' AND civicrm_membership.membership_type_id IN (5,7,4,1,10,6,8,9) AND  civicrm_membership.is_test = 0 )  AND  ( 1 )  AND 1    ) 
                              AND contact_a.id NOT IN (
                              SELECT contact_id FROM civicrm_group_contact
                              WHERE civicrm_group_contact.group_id = 10 AND civicrm_group_contact.status = 'Removed' ) ) ) ) )  AND  ( 1 )     [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 ') = 'all' AND  civicrm_contribution.is_test = '0' AND civicrm_membership.members' at line 2]"]
)