Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-2044

MySQL syntax erro --- to use near ') AND ( 1 ) ORDER BY contact_a.sort_name' at line 5, 1064

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 1.7
    • Fix Version/s: 1.8
    • Component/s: CiviContribute
    • Labels:
      None

      Description

      We are getting the following error after filling in all of the fields for the contribution page. The monetary transaction goes through fine with civi and the processor. Unfortunately it does not make to the Thank You page.

      It appears to be some syntax 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 ') AND ( 1 ) ORDER BY contact_a.sort_name' at line 5, 1064

      Return to CiviCRM menu.

      Error Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -2
      [message] => DB Error: syntax error
      [mode] => 16
      [debug_info] => SELECT contact_a.id as contact_id, civicrm_individual.id as individual_id, civicrm_individual.first_name as `first_name`, civicrm_individual.last_name as `last_name`, `1-location`.id as `1-location_id`, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.street_address as `1-street_address`, `1-address`.supplemental_address_1 as `1-supplemental_address_1`, `1-address`.city as `1-city`, `1-state_province`.id as `1-state_province_id`, `1-state_province`.abbreviation as `1-state_province`, `1-address`.postal_code as `1-postal_code` FROM civicrm_contact contact_a LEFT JOIN civicrm_individual ON (contact_a.id = civicrm_individual.contact_id)
      LEFT JOIN civicrm_location `1-location` ON (`1-location`.entity_table = 'civicrm_contact' AND `1-location`.entity_id = contact_a.id AND `1-location`.is_primary = 1 )
      LEFT JOIN civicrm_location_type `1-location_type` ON (`1-location`.location_type_id = `1-location_type`.id )
      LEFT JOIN civicrm_address `1-address` ON (`1-address`.location_id = `1-location`.id)
      LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = 22 AND civicrm_contribution.id = ) AND ( 1 ) ORDER BY contact_a.sort_name [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 ') AND ( 1 ) ORDER BY contact_a.sort_name' at line 5]
      [type] => DB_Error
      [user_info] => SELECT contact_a.id as contact_id, civicrm_individual.id as individual_id, civicrm_individual.first_name as `first_name`, civicrm_individual.last_name as `last_name`, `1-location`.id as `1-location_id`, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.street_address as `1-street_address`, `1-address`.supplemental_address_1 as `1-supplemental_address_1`, `1-address`.city as `1-city`, `1-state_province`.id as `1-state_province_id`, `1-state_province`.abbreviation as `1-state_province`, `1-address`.postal_code as `1-postal_code` FROM civicrm_contact contact_a LEFT JOIN civicrm_individual ON (contact_a.id = civicrm_individual.contact_id)
      LEFT JOIN civicrm_location `1-location` ON (`1-location`.entity_table = 'civicrm_contact' AND `1-location`.entity_id = contact_a.id AND `1-location`.is_primary = 1 )
      LEFT JOIN civicrm_location_type `1-location_type` ON (`1-location`.location_type_id = `1-location_type`.id )
      LEFT JOIN civicrm_address `1-address` ON (`1-address`.location_id = `1-location`.id)
      LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = 22 AND civicrm_contribution.id = ) AND ( 1 ) ORDER BY contact_a.sort_name [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 ') AND ( 1 ) ORDER BY contact_a.sort_name' at line 5]
      [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT contact_a.id as contact_id, civicrm_individual.id as individual_id, civicrm_individual.first_name as `first_name`, civicrm_individual.last_name as `last_name`, `1-location`.id as `1-location_id`, `1-location_type`.id as `1-location_type_id`, `1-location_type`.name as `1-location_type`, `1-address`.id as `1-address_id`, `1-address`.street_address as `1-street_address`, `1-address`.supplemental_address_1 as `1-supplemental_address_1`, `1-address`.city as `1-city`, `1-state_province`.id as `1-state_province_id`, `1-state_province`.abbreviation as `1-state_province`, `1-address`.postal_code as `1-postal_code` FROM civicrm_contact contact_a LEFT JOIN civicrm_individual ON (contact_a.id = civicrm_individual.contact_id)
      LEFT JOIN civicrm_location `1-location` ON (`1-location`.entity_table = 'civicrm_contact' AND `1-location`.entity_id = contact_a.id AND `1-location`.is_primary = 1 )
      LEFT JOIN civicrm_location_type `1-location_type` ON (`1-location`.location_type_id = `1-location_type`.id )
      LEFT JOIN civicrm_address `1-address` ON (`1-address`.location_id = `1-location`.id)
      LEFT JOIN civicrm_state_province `1-state_province` ON `1-state_province`.id = `1-address`.state_province_id LEFT JOIN civicrm_contribution ON civicrm_contribution.contact_id = contact_a.id WHERE ( contact_a.id = 22 AND civicrm_contribution.id = ) AND ( 1 ) ORDER BY contact_a.sort_name [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 ') AND ( 1 ) ORDER BY contact_a.sort_name' at line 5]"]
      )

        Attachments

          Activity

            People

            • Assignee:
              shailesh Shailesh Lende
              Reporter:
              joommaster Christopher Wendt
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: