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]"]
)