CiviCRM Community Forums (archive)

Recently upgraded from 2.0 to 3.0.
A custom volunteer intake form now gives a MySQL error.

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 = 4179 ) 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 = 4179 ) 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 = 4179 ) AND (  civicrm_membership.membe' at line 4]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_membership
 
 WHERE ( status_id !=  )  AND (  civicrm_membership.contact_id = 4179 ) 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 = 4179 ) 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 = 4179 ) 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 = 4179 ) AND (  civicrm_membership.membe' at line 4]"]
)

Deceased was showing on the admin page, but no edit/disable/delete links.
It was showing in the database with reserved=1.
I deleted it from the database and added a new 'Deceased' with the GUI.

Problem is still there.