CiviCRM Community Forums (archive)

Hi there,

For a Contribution Page, I've settled a:

- PayPal Pro process, the payment is done, but after finishing payment the same massage than above is displayed.
- PayPal Standard process, when I try to pay, at the beginning, the following message is displayed :

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 ( civicrm_membership.contact_id = 1 ) AND ( civicrm_membership.membersh' at line 4, 1064


Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )
    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_membership
 
 WHERE ( status_id !=  )  AND (  civicrm_membership.contact_id = 1 ) AND (  civicrm_membership.membership_type_id = 1 )
 
 ORDER BY start_date DESC  
 [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 (  civicrm_membership.contact_id = 1 ) AND (  civicrm_membership.membersh' at line 4]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_membership
 
 WHERE ( status_id !=  )  AND (  civicrm_membership.contact_id = 1 ) AND (  civicrm_membership.membership_type_id = 1 )
 
 ORDER BY start_date DESC  
 [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 (  civicrm_membership.contact_id = 1 ) AND (  civicrm_membership.membersh' at line 4]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_membership
 
 WHERE ( status_id !=  )  AND (  civicrm_membership.contact_id = 1 ) AND (  civicrm_membership.membership_type_id = 1 )
 
 ORDER BY start_date DESC  
 [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 (  civicrm_membership.contact_id = 1 ) AND (  civicrm_membership.membersh' at line 4]"]
)


Is someone an idea?

Thanks by advance!

[/code]

Hi,
Many thanks for the help regarding the first message.

After Pending activation, I have now the following message:


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

    [code] => -22
    [message] => DB Error: value count on row
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_financial_trxn (contribution_id , trxn_date , trxn_type , total_amount , fee_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 4 ,  20100414171730 , 'Debit' ,  10.00 ,  0.59 ,  9,41 , 'EUR' , 'PayPal_Express' , '7XP229102S069123V' )  [nativecode=1136 ** Column count doesn't match value count at row 1]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_financial_trxn (contribution_id , trxn_date , trxn_type , total_amount , fee_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 4 ,  20100414171730 , 'Debit' ,  10.00 ,  0.59 ,  9,41 , 'EUR' , 'PayPal_Express' , '7XP229102S069123V' )  [nativecode=1136 ** Column count doesn't match value count at row 1]
    [to_string] => [db_error: message="DB Error: value count on row" code=-22 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_financial_trxn (contribution_id , trxn_date , trxn_type , total_amount , fee_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 4 ,  20100414171730 , 'Debit' ,  10.00 ,  0.59 ,  9,41 , 'EUR' , 'PayPal_Express' , '7XP229102S069123V' )  [nativecode=1136 ** Column count doesn't match value count at row 1]"]
)

Many thanks for the help !

[/code]

After upgrading to Cicicrm 3.1.5, Drupal 6.17. I'm still facing the same problem with paypal express payments. After all the payment process, I'm getting the fatal error described below.
It seems that the column count does'nt match because for some obsure reasin, the currency unit.decimal divider is set to comma.
see ..........'Debit' ,  5 ,  0.72 ,  4,28 , 'CHF' , 'PayPal_Express'
Does anyone knows someting about that, it seem to be some localization issue ore somewhat...

Error Details:

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

    [code] => -22
    [message] => DB Error: value count on row
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_financial_trxn (contribution_id , trxn_date , trxn_type , total_amount , fee_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 9 ,  20100621090438 , 'Debit' ,  5 ,  0.72 ,  4,28 , 'CHF' , 'PayPal_Express' , '0WP23486YK638253H' )  [nativecode=1136 ** Column count doesn't match value count at row 1]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_financial_trxn (contribution_id , trxn_date , trxn_type , total_amount , fee_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 9 ,  20100621090438 , 'Debit' ,  5 ,  0.72 ,  4,28 , 'CHF' , 'PayPal_Express' , '0WP23486YK638253H' )  [nativecode=1136 ** Column count doesn't match value count at row 1]
    [to_string] => [db_error: message="DB Error: value count on row" code=-22 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_financial_trxn (contribution_id , trxn_date , trxn_type , total_amount , fee_amount , net_amount , currency , payment_processor , trxn_id ) VALUES ( 9 ,  20100621090438 , 'Debit' ,  5 ,  0.72 ,  4,28 , 'CHF' , 'PayPal_Express' , '0WP23486YK638253H' )  [nativecode=1136 ** Column count doesn't match value count at row 1]"]
)
[/code]