CiviCRM Community Forums (archive)

Hi,

I'm getting a MySQL Error.
Did an upgrade from Drupal5/CiviCRM2.0.7 -> Drupal6/CiviCRM3.0.4
Everything is working well except for the error.

This is probably not the 'Deceased' issue, because 'Deceased' is in the _membership_status table, and is active.

The site has a custom form. When the 'continue' button is clicked to submit the form, the MySQL error appears. Even though the error appears, the data gets written correctly to the db.

Any ideas?

Sorry. A non-recoverable error has occurred.


DB Error: syntax error

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

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_membership
 
 WHERE ( status_id !=  )  AND (  civicrm_membership.contact_id = 4193 ) 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 = 4193 ) AND (  civicrm_membership.membe' at line 4]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_membership
 
 WHERE ( status_id !=  )  AND (  civicrm_membership.contact_id = 4193 ) 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 = 4193 ) AND (  civicrm_membership.membe' 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 = 4193 ) 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 = 4193 ) AND (  civicrm_membership.membe' at line 4]"]
)

I was unable to figure out the backTrace. I was able to get CiviCRM to spit out the offending query.
Not sure how you can have a status_id that isn't equal. Isn't equal to what?

Any ideas?


 query = SELECT * FROM civicrm_membership
         WHERE ( status_id != )
         AND ( civicrm_membership.contact_id = 4199 )
         AND ( civicrm_membership.membership_type_id = 1 )
         ORDER BY start_date DESC



backTrace

/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 146
, handle,
/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1905
/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1218
/sites/all/modules/civicrm/packages/DB/DataObject.php,
query, 2394
/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 442
/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, find, 701
/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, getContactMembership, 1117
/sites/all/modules/civicrm/CRM/Member/BAO/Membership.php, renewMembership, 1019
/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution/Confirm.php, postProcessMembership, 514
/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 248
/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 249
/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 209
/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 333
, civicrm_invoke,
/includes/menu.inc, call_user_func_array, 348
/index.php, menu_execute_active_handler, 18

OK.

And it's my bad. Pending was the issue. It was there but turned off.

But, for anyone who is searching the forums for the info --

Membership status rules:
Deceased and Pending are required.  If your version of CiviCRM allows you to enable/disable them, make sure they are enabled. And if your version of CiviCRM allows you to delete them, well, you will just have to recreate them.

Are there any other required Membership status rules?