*backTrace
#0 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(190): CRM_Core_Error::backtrace()
#1 /home/ehfa/www/www/sites/all/modules/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: syntax error", -2, 16, (Array:2), "nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...")
#3 /home/ehfa/www/www/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-2, 16, (Array:2), "nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...")
#4 /home/ehfa/www/www/sites/all/modules/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -2, 16, (Array:2), "nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...", "DB_Error", TRUE)
#5 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-2, NULL, NULL, "nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...", "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...")
#9 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...")
#10 /home/ehfa/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...")
#11 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(438): DB_DataObject->query("nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...")
#12 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1411): CRM_Core_DAO->query("nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...", TRUE)
#13 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Member/Form/MembershipView.php(283): CRM_Core_DAO::executeQuery("nSELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,n...")
#14 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Form.php(585): CRM_Member_Form_MembershipView->preProcess()
#15 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#16 /home/ehfa/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Member_Form_MembershipView), "display")
#17 /home/ehfa/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Member_Form_MembershipView), "display")
#18 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#19 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Member/Page/Tab.php(253): CRM_Core_Controller->run()
#20 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Member/Page/Tab.php(370): CRM_Member_Page_Tab->view()
#21 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(309): CRM_Member_Page_Tab->run((Array:4), NULL)
#22 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:14))
#23 /home/ehfa/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#24 /home/ehfa/www/www/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4))
#25 /home/ehfa/www/www/includes/menu.inc(527): civicrm_invoke("contact", "view", "membership")
#26 /home/ehfa/www/www/index.php(21): menu_execute_active_handler()
#27 {main}
Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: syntax error
Error Details
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 m.contact_id = r.contact_id_a AND m.is_test = 0) LEFT JOIN civicrm_members' at line 8, 1064
Additional Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )
    [code] => -2
    [message] => DB Error: syntax error
    [mode] => 16
    [debug_info] =>
SELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,
       rt.name_a_b as relation, r.start_date, r.end_date,
       m.id as mid, ms.is_current_member, ms.label as status
  FROM civicrm_relationship r
  LEFT JOIN civicrm_relationship_type rt ON rt.id = r.relationship_type_id
  LEFT JOIN civicrm_contact c ON c.id = r.contact_id_a
  LEFT JOIN civicrm_membership m ON (m.owner_membership_id =
  AND m.contact_id = r.contact_id_a AND m.is_test = 0)
  LEFT JOIN civicrm_membership_status ms ON ms.id = m.status_id
 WHERE r.contact_id_b =  AND r.is_active = 1  AND c.is_deleted = 0 AND r.relationship_type_id IN (16) ORDER BY is_current_member 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 m.contact_id = r.contact_id_a AND m.is_test = 0)
  LEFT JOIN civicrm_members' at line 8]
    [type] => DB_Error
    [user_info] =>
SELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,
       rt.name_a_b as relation, r.start_date, r.end_date,
       m.id as mid, ms.is_current_member, ms.label as status
  FROM civicrm_relationship r
  LEFT JOIN civicrm_relationship_type rt ON rt.id = r.relationship_type_id
  LEFT JOIN civicrm_contact c ON c.id = r.contact_id_a
  LEFT JOIN civicrm_membership m ON (m.owner_membership_id =
  AND m.contact_id = r.contact_id_a AND m.is_test = 0)
  LEFT JOIN civicrm_membership_status ms ON ms.id = m.status_id
 WHERE r.contact_id_b =  AND r.is_active = 1  AND c.is_deleted = 0 AND r.relationship_type_id IN (16) ORDER BY is_current_member 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 m.contact_id = r.contact_id_a AND m.is_test = 0)
  LEFT JOIN civicrm_members' at line 8]
    [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT r.id, c.id as cid, c.display_name as name, c.job_title as comment,
       rt.name_a_b as relation, r.start_date, r.end_date,
       m.id as mid, ms.is_current_member, ms.label as status
  FROM civicrm_relationship r
  LEFT JOIN civicrm_relationship_type rt ON rt.id = r.relationship_type_id
  LEFT JOIN civicrm_contact c ON c.id = r.contact_id_a
  LEFT JOIN civicrm_membership m ON (m.owner_membership_id =
  AND m.contact_id = r.contact_id_a AND m.is_test = 0)
  LEFT JOIN civicrm_membership_status ms ON ms.id = m.status_id
 WHERE r.contact_id_b =  AND r.is_active = 1  AND c.is_deleted = 0 AND r.relationship_type_id IN (16) ORDER BY is_current_member 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 m.contact_id = r.contact_id_a AND m.is_test = 0)
  LEFT JOIN civicrm_members' at line 8]"]
)
Return to home page.*