Author Topic: Error message when try to add a new contribution (Read 809 times)

mgregoire · May 20, 2010, 02:44:47 am

Hi everybody,

I have a problem, when I try to add a contribution, the following messa ge is displayed :

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_pledge.contact_id = 3532' at line 3, 1064

The details are :

Code: [Select]


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

    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => 
SELECT civicrm_pledge.id id
FROM civicrm_pledge
WHERE civicrm_pledge.status_id   IN (,,)        
  AND civicrm_pledge.contact_id = 3532
 [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_pledge.contact_id = 3532' at line 3]
    [type] => DB_Error
    [user_info] => 
SELECT civicrm_pledge.id id
FROM civicrm_pledge
WHERE civicrm_pledge.status_id   IN (,,)        
  AND civicrm_pledge.contact_id = 3532
 [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_pledge.contact_id = 3532' at line 3]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT civicrm_pledge.id id
FROM civicrm_pledge
WHERE civicrm_pledge.status_id   IN (,,)        
  AND civicrm_pledge.contact_id = 3532
 [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_pledge.contact_id = 3532' at line 3]"]
)

Many thanks for the help![/code]

CiviTeacher.com · May 21, 2010, 09:47:18 am

Where I would start with this one is the following:

1. Look up Contact #3532 and see what is the deal with this record. You are trying to add a Contribution but something is erroring with the Pledge.
a. does this contact have any pledges?
b. do you use pledges in your database?
c. have pledges been turned off?

2. What kind of contribution are you trying to add?

3. Where are you adding the contribution from? From the contact's record or another location?

Yashodha Chaku · May 24, 2010, 05:26:59 am

mgregoire :
Can you make sure all the option values corresponding to option group "contribution_status" are enabled for your set up?

You might wanna refer to :
http://drupal.demo.civicrm.org/civicrm/admin/optionValue?reset=1&action=browse&gid=11

or alternately fire a query to check the values are in place as:

Code: [Select]

mysql>  SELECT  v.name as name ,v.value as value, v.grouping as grouping
    -> FROM   civicrm_option_value v,
    ->             civicrm_option_group g
    -> WHERE  v.option_group_id = g.id
    ->   AND  g.name            = 'contribution_status'
    ->   AND  v.is_active       = 1 
    ->   AND  g.is_active       = 1;
+-------------+-------+----------+
| name        | value | grouping |
+-------------+-------+----------+
| Cancelled   | 3     | NULL     | 
| Completed   | 1     | NULL     | 
| Failed      | 4     | NULL     | 
| In Progress | 5     | NULL     | 
| Overdue     | 6     | NULL     | 
| Pending     | 2     | NULL     | 
+-------------+-------+----------+

6 rows in set (0.00 sec)

HTH
-Yashodha

Andrew Perry · June 23, 2010, 12:39:23 am

We were having a similar problem and this helped a lot - thanks!!

CiviCRM Community Forums (archive)

News:

Author Topic: Error message when try to add a new contribution (Read 809 times)

mgregoire

Error message when try to add a new contribution

CiviTeacher.com

Re: Error message when try to add a new contribution

Yashodha Chaku

Re: Error message when try to add a new contribution

Andrew Perry

Re: Error message when try to add a new contribution