Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [error] $Fatal Error Details = Array
- (
- [callback] => Array
- (
- [0] => CRM_Core_Error
- [1] => handle
- )
- [code] => -2
- [message] => DB Error: syntax error
- [mode] => 16
- [debug_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_exposed_id, pledge_civireport.id as civicrm_pledge_id, pledge_civireport.contact_id as civicrm_pledge_contact_id, pledge_civireport.amount as civicrm_pledge_amount, pledge_civireport.currency as civicrm_pledge_currency, pledge_civireport.status_id as civicrm_pledge_status_id, COALESCE(sum(pledge_payment_civireport.actual_amount), 0) as civicrm_pledge_payment_total_paid, IF(pledge_civireport.status_id IN(3, ), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civireport.actual_amount),0)) as civicrm_pledge_payment_balance_due, (address_civireport.street_number % 2) as civicrm_address_address_odd_street_number
- FROM civicrm_pledge pledge_civireport
- LEFT JOIN civicrm_contact contact_civireport
- ON (contact_civireport.id =
- pledge_civireport.contact_id )
- LEFT JOIN civicrm_pledge_payment pledge_payment_civireport ON
- pledge_civireport.id = pledge_payment_civireport.pledge_id
- AND pledge_payment_civireport.status_id = 1
- LEFT JOIN civicrm_address address_civireport
- ON (contact_civireport.id =
- address_civireport.contact_id) AND
- address_civireport.is_primary = 1
- WHERE (pledge_civireport.is_test=0 ) GROUP BY pledge_civireport.id, pledge_civireport.currency ORDER BY contact_civireport.sort_name, contact_civireport.id LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civire' at line 1]
- [type] => DB_Error
- [user_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_exposed_id, pledge_civireport.id as civicrm_pledge_id, pledge_civireport.contact_id as civicrm_pledge_contact_id, pledge_civireport.amount as civicrm_pledge_amount, pledge_civireport.currency as civicrm_pledge_currency, pledge_civireport.status_id as civicrm_pledge_status_id, COALESCE(sum(pledge_payment_civireport.actual_amount), 0) as civicrm_pledge_payment_total_paid, IF(pledge_civireport.status_id IN(3, ), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civireport.actual_amount),0)) as civicrm_pledge_payment_balance_due, (address_civireport.street_number % 2) as civicrm_address_address_odd_street_number
- FROM civicrm_pledge pledge_civireport
- LEFT JOIN civicrm_contact contact_civireport
- ON (contact_civireport.id =
- pledge_civireport.contact_id )
- LEFT JOIN civicrm_pledge_payment pledge_payment_civireport ON
- pledge_civireport.id = pledge_payment_civireport.pledge_id
- AND pledge_payment_civireport.status_id = 1
- LEFT JOIN civicrm_address address_civireport
- ON (contact_civireport.id =
- address_civireport.contact_id) AND
- address_civireport.is_primary = 1
- WHERE (pledge_civireport.is_test=0 ) GROUP BY pledge_civireport.id, pledge_civireport.currency ORDER BY contact_civireport.sort_name, contact_civireport.id LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civire' at line 1]
- [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT SQL_CALC_FOUND_ROWS contact_civireport.sort_name as civicrm_contact_sort_name, contact_civireport.id as civicrm_contact_exposed_id, pledge_civireport.id as civicrm_pledge_id, pledge_civireport.contact_id as civicrm_pledge_contact_id, pledge_civireport.amount as civicrm_pledge_amount, pledge_civireport.currency as civicrm_pledge_currency, pledge_civireport.status_id as civicrm_pledge_status_id, COALESCE(sum(pledge_payment_civireport.actual_amount), 0) as civicrm_pledge_payment_total_paid, IF(pledge_civireport.status_id IN(3, ), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civireport.actual_amount),0)) as civicrm_pledge_payment_balance_due, (address_civireport.street_number % 2) as civicrm_address_address_odd_street_number
- FROM civicrm_pledge pledge_civireport
- LEFT JOIN civicrm_contact contact_civireport
- ON (contact_civireport.id =
- pledge_civireport.contact_id )
- LEFT JOIN civicrm_pledge_payment pledge_payment_civireport ON
- pledge_civireport.id = pledge_payment_civireport.pledge_id
- AND pledge_payment_civireport.status_id = 1
- LEFT JOIN civicrm_address address_civireport
- ON (contact_civireport.id =
- address_civireport.contact_id) AND
- address_civireport.is_primary = 1
- WHERE (pledge_civireport.is_test=0 ) GROUP BY pledge_civireport.id, pledge_civireport.currency ORDER BY contact_civireport.sort_name, contact_civireport.id LIMIT 0, 50 [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '), 0, COALESCE(pledge_civireport.amount, 0) - COALESCE(sum(pledge_payment_civire' at line 1]"]
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement